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");

?>