Dear list, I test the following script on local web server and it runs fine. But when I upload the script to the real web server I get the following error/message, but the script works fine. Do you know why?
Here is the error/message I get: Undefined variable : id in test.php on line 6 And here is the script file (test.php): <html> <body> <?php $db = mysql_connect("localhost", "root", "root"); mysql_select_db("penpal",$db); if ($id) $result = mysql_query("select * from penpal where id = $id",$db); $myrow = mysql_fetch_array($result); printf("<b>ID:</b> %s\n<br>", $myrow["id"]); printf("<b>Name:</b> %s\n<br>", $myrow["name"]); printf("<b>Age/Sex/Location:</b> %s\n<br>", $myrow["asl"]); printf("<b>Description:</b> %s\n<br>", $myrow["description"]); printf("<b>Email:</b> %s\n<br>", $myrow["email"]); } else { $result = mysql_query("select * from penpal order by id desc", $db); if ($myrow = mysql_fetch_array($result)) { do { printf("<a href = \"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["name"], $myrow["asl"]); } while ($myrow = mysql_fetch_array($result)); } else { echo "Sorry, no records"; } } ?> </body> </html> The id field in my table has the attribute: id tinyint (4) Thanks in advance NOBBY -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]