Select and update in one query?

[sidsel]

If I have a simple select query that select everthing in a row like

SELECT * FROM profiles WHERE .....

can I also make a update in conjunction with the selection? Like 'column+1' so I will get a field telling me how many times a specfic rowID has been viewed?

What about speed? Is there any difference in running two queries right after each other or running one query with a combined select/update?

[leatherback]

Hi,

I do a double query:

$updatequery = "UPDATE images SET downloads= downloads+1 where Id=$id";
$sql_results = mysql_query($updatequery);
}

$sql_query = "SELECT * from images where Id = $id";

[thorpe]

depending what db your using you might even be able to use triggers. sqlite, postgresql both have them, and i believe mysql5 now has triggers aswell.