LAST_INSERT_ID & LAST_UPDATE_ID
| From: | sam rumaizan | Date: | Thu, 24 May 2007 21:26:42 +0000 |
| Subject: | LAST_INSERT_ID & LAST_UPDATE_ID | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-27960@lists.php.net to get a copy of this message | ||
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