Well what database? If mysql you can use the php function mysql_insert_id(); http://www.php.net/manual/en/function.mysql-insert-id.php ----- Original Message ---- From: sam rumaizan <samcalc@xxxxxxxxx> To: php-windows@xxxxxxxxxxxxx Sent: Thursday, May 24, 2007 4:26:42 PM Subject: LAST_INSERT_ID & LAST_UPDATE_ID How can I select (retrieve) the last updated cell (field). Basically I need to pull the new information only. I'm using for updating my database: UPDATE table SET column = CONCAT_WS ('column,'" . $column."') WHERE column= value; I need to select data: SELECT * FROM table WHERE column=Whatever I found LAST_INSERT_ID but i doesn't work Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.http://us.rd.yahoo.com/evt=48518/*http://autos.yahoo.com/carfinder/;_ylc=X3oDMTE3NWsyMDd2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDY2FyLWZpbmRlcg-- hot CTA = Yahoo! Autos new Car Finder tool
