It is commented out because I am using "mysql_connect...." I don't think it would be good to use both, since the db1 references another db. But even when I use the db1.php and change the database and table, I get the same error message. But what I did miss is my typo in "What is wrond with this file?" :-) > Hi PJ, > Could it be that you have "//include ("lib/db1.php"); " commented > out? Try uncommenting that line and see what happens. The error > message will always print because the query is never executing > properly if you have the db connections file commented out. > > On Thu, Feb 26, 2009 at 12:28 PM, PJ <af.gourmet@xxxxxxxxxxxx> wrote: >> What is wrond with this file? same identical insert works from console >> but not from this file :-( >> >> <html> >> <head> >> <title>Untitled</title> >> </head> >> >> <body> >> <? >> //include ("lib/db1.php"); // Connect to database >> mysql_connect('biggie', 'user', 'password', 'test'); >> $sql1 = "INSERT INTO example (name, age) VALUES ('Joe Blow', '69')"; >> $result1 = mysql_query($sql1,$db); >> if (!$result1) { >> echo("<P>Error performing 1st query: " . >> mysql_error() . "</P>"); >> exit(); >> } >> ?> >> >> </body> >> </html> >> >> Seems to be good to print out the error message, but that's all. db not >> written. >> >> -- >> >> Phil Jourdan --- pj@xxxxxxxxxxxxx >> http://www.ptahhotep.com >> http://www.chiccantine.com >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=dsteplight@xxxxxxxxx >> >> > -- Phil Jourdan --- pj@xxxxxxxxxxxxx http://www.ptahhotep.com http://www.chiccantine.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php