Hi all, I have a mysql question. My php script is adding an article to a database. However, it must also add one or more rows to an article_products table, which consists of just two fields, an article id and a product id, which form a composite primary key. The problem is that the article_products table can't be updated until the script knows the id of the article being added, so I need two separate queries to create everything: create the article, then create all rows necessary in the article_products table. My question, therefore, is: what is the best way to get the id of the article just created? The id is an auto_increment integer. I have so far thought about pulling the first record when records are sorted in descending order by id, but it seems like there might be a better way. If not, what would the syntax be? I plan on using something like: select article_id from articles sort by article_id desc limit 1; Is there a better way? Thanks in advance. -- Have a great day, Alex (msg sent from GMail website) mehgcap@xxxxxxxxx; http://www.facebook.com/mehgcap __________ View the list's information and change your settings at //www.freelists.org/list/programmingblind