Subversion-Projekte lars-tiefland.content-management

<?
        require_once "../powerstation-pc.de/connect.php";
        function create_tags($tab)
        {
                $result = mysql_query ("show fields from $tab;") or die (mysql_errno().": ".mysql_error());
                while($zeile=mysql_fetch_array($result))
                {
                        $buffer=$zeile[0]." ".$zeile[1]." ";
                        if (!$zeile[2]) {$buffer=$buffer."NOT NULL ";}
                        if ($zeile[4]) {$buffer=$buffer."DEFAULT '".$zeile[4]."' ";}
                        $buffer=$buffer.$zeile[5];
                        $create_tags[]=$buffer;

                        switch($zeile[3])
                        {
                                case "PRI": 
                                                        $primary[]=$zeile[0];
                                                        break;
                                default: break;
                        }
                }
                $create_tags[]="PRIMARY KEY  (".implode(", ",$primary).")";
                $create_tags="CREATE TABLE $tab\n(\n".implode(",\n",$create_tags)."\n);";
                return $create_tags;
        }
?>
<?
echo create_tags("artikel");
?>