-----------------------------------------------------------------------
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
----------------------------------------------------------------------
2009/2/26 PJ <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 ?
>
> 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
> 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
>
>
