9el wrote: > > ----------------------------------------------------------------------- > Use FreeOpenSourceSoftwares, Stop piracy, Let the developers live. Get > a Free CD of Ubuntu mailed to your door without any cost. Visit : > www.ubuntu.com <http://www.ubuntu.com> > ---------------------------------------------------------------------- > > > 2009/2/26 PJ <af.gourmet@xxxxxxxxxxxx <mailto:af.gourmet@xxxxxxxxxxxx>> > > Something is rotten here. Twist it any way you like and it just > does not > work. > I am trying to figure out the working of SELECT LAST_INSERT_ID() and > cannot get beyond the first $sql - But it works fine from > command-line! > > <? > include ("lib/db1.php"); // Connect to database > > $sql1 = "INSERT INTO test (name, age) VALUES ('Joe Blow', '69')"; > $result1 = mysql_query($sql1,$db); > if ( !$result) { > > At the above line $result1 ? A typo after the fact does not alter the fact. The INSERT does not work as it should! I don't understand why it should work on command line and not from a file. > > > echo("<P>Error performing query: " . > mysql_error() . "</P>"); > exit(); > } > > THIS IS WHERE IT STOPS WITH ERROR.$sql1 just refuses to work. db > connection is fine and the INSERT works from xterm on remote puter. > Can't figure this out. > ============ > > > $sql = "SELECT LAST_INSERT_ID() FROM test"; > $result = mysql_query($sql,$db); > if (!$result) { > echo("<P>Error performing query: " . > mysql_error() . "</P>"); > exit(); > } > while ( $row = mysql_fetch_array($result) ) { > echo("<P>" . $row["id"] . "</P>"); > } > ?> > > What am I missing here? Or how can I trace the error? > > -- > > Phil Jourdan --- pj@xxxxxxxxxxxxx <mailto: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 > > -- 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