[nycphp-talk] PHP/MySQL environment problem??

Glenn glenn310b at
Sat Mar 1 00:25:31 EST 2008

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.


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
> NYPHPCon 2006 Presentations Online
> Show Your Participation in New York PHP
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1772 bytes
Desc: not available
URL: <>

More information about the talk mailing list