Php Query Help

[fluiduk]

Hi All

Quick question for you. I am working on a new CMS for a site at the moment and am stuck.

I have a query that inserts an article into a database and its assigned an auto id, is there anyway that I can feed back that ID from the table back into the script. As I need to assign it to pictures and related links that are added via a seperate form. At the moment I just use another query to get the latest ID out of the table although this is not ideal

Thanks
Aaron

 

[chesterstu]

I think this is what you are looking for mysql_insert_id($dbcon); for more info Click me baby