[Resolved] last increment id problem

[slimjim]

How can i get the last incremented id from table and then figure out the one that will be used now so that I can use that to rename the graphic ?

	copy($our_file, "$bannerpath/$id") or die("Couldn't Upload the file!");  

[yelvington]

Be careful. If you query the database to find the highest id, there is a possibility that another process will do an insert after your query and you both will try to use the same number.

So instead, do your sql INSERT first, then get the ID of that transaction and use it to name your data file.

You didn't say what database you were using, but if it is mysql, mysql_insert_id() will return the value.

[slimjim]

Thats what I did and it worked .
Thanks