Re: LAST_INSERT_ID & LAST_UPDATE_ID

What I want to do is: 1-user has 10 columns (fields). 2- User updated one of these fields using CONCAT_WS(adding new data to previous data). 3- When user views any of his information he sees only the last updated part of the data. So, timestamp/datetime field is not going to work. Stut <stuttle@gmail.com> wrote: sam rumaizan wrote: > 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 LAST_INSERT_ID will not work because you're not inserting anything. The clue, you see, is in the name. Your best bet would be to add a timestamp/datetime field to the table and include that in the update. Then you can use that field to get the last row that was changed. -Stut -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --------------------------------- Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out.