Re: [PHP] Uncertainties about MySQL commands

2001-11-01 Thread Jason G.
Regarding your mysql_insert_id() function: I believe that it works on a connection by connection basis. Therefore, if you execute an insert, and then call that function, you are guarenteed to have the correct ID. Look up the LAST_INSERT_ID() function in the MySQL manual on www.mysql.com for

[PHP] Uncertainties about MySQL commands

2001-11-01 Thread TD - Sales International Holland B.V.
Hey list, i'm new to php so bare with me... got some questions on mysql commands. I'd like to know how the mysql_insert_id() function works exactly. First of all how reliable is it? What happens this happens: Table: (ID int unsigned primary key auto_increment, Stuff text, MoreStuff text) (my s