Just curious.
Why not use an autoincrement ?
I'm probably missing something...???
Back to your question;
I think I remember reading something about last_insert_id() being
different between mysql versions.
Regards,
Glenn
On Feb 28, 2008, at 2:11 PM, PaulCheung wrote:
The application is a classic traditional computer applications of add,
update and read selected record. The add record routine lines up the
next record to be added by checking what the last record added number
was.
The application was developed on “localhost”, Windows environment,
and all working as expected, adding, updating and reading records up
to a preset maximum of 100.
Then thethe whole application was transfered into its' “production
environment” on my web space, Linux environment for testing.
Everything works fine for the first record only. I cannot add records
thereafter. I have “desk checked” the coding and with the exception of
the MySQL database parameters (host, user, password and database). All
coding remains the same.
I cannot understand what is wrong is it because of the different
operating environments or could it be something else? Has anybody got
any ideas
.
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
