...

View Full Version : MySQL - retreiving last 'row' added - n/m solved



PaulC2K
05-30-2007, 02:14 AM
Hi,

I've had this before, gone through post history and a few sites ive built where i might have used this and cant find it.

Say ive just added a new peice of information to my table, i know theres a simple way of requesting that peice of info so i can get its auto-incremental ID number given to that row. That way i can then take that ID and pass it onto another table without having to search for the information i've just submitted.

Thx,
PaulC2K

PaulC2K
05-30-2007, 02:19 AM
nevermind, what a n00b, couple of minutes later and i spot what im looking for on the previous from where i was looking!

mysql_insert_id();

:)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum