When I was your age I didn't have luxuries like...
Submitted by phrax on Mon, 2004-11-22 15:27.
Bad Architecture
being able to select more than one column from the database at a time!
(thanks to Nightflyer for this submission)
<?php
$server = "localhost";
$user = "root";
$password = "";
$database = "mmnetrix";
$tbl_content = "netcard";
$db_connect = mysql_connect($server, $user, $password);
$db_close = mysql_close($db_connect);
$db_select = mysql_select_db($database, $db_connect);
$id = $_GET['id'];
$sql_name = mysql_query("SELECT name FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_strasse = mysql_query("SELECT strasse FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_plz = mysql_query("SELECT plz FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_ort = mysql_query("SELECT ort FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_tel = mysql_query("SELECT tel FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_fax = mysql_query("SELECT fax FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_email = mysql_query("SELECT email FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_inet = mysql_query("SELECT inet FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_ansprpartner = mysql_query("SELECT ansprpartner FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_hlkurztext = mysql_query("SELECT hlkurztext FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_kurztext = mysql_query("SELECT kurztext FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_hllangtext = mysql_query("SELECT hllangtext FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_langtext = mysql_query("SELECT langtext FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_hlliste = mysql_query("SELECT hlliste FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_liste = mysql_query("SELECT liste FROM $tbl_content WHERE id = '$id'", $db_connect);
$sql_grafik = mysql_query("SELECT grafik FROM $tbl_content WHERE id = '$id'", $db_connect);
?>