update multiple entries in 1 query possible?

[amites]

extra question for the night:

 

any way for me to update more than one entry in a single query?

 

I want to set a timestamp and add to a counter,

 

hoping I don't have to do it in 2 queries for the sake of the DB...

 

many thanks

[pdkv2]

i am not getting what exactly you want to do .

[fenway]

Provided you want to update all the records the same way, yes.

[amites]

I suppose it would have helped if I posted some code with my question,

 

	$query = "UPDATE bil_msg_sent AS s"
	. "\n JOIN bil_msg_look AS l ON (l.locid = s.locid)"
	. "\n JOIN bil_users AS u ON (u.id = s.userid)"
	. "\n JOIN bil_location AS loc ON (l.locid = loc.id)"
	. "\n SET s.last_read = now()"
	. "\n WHERE s.msg_date BETWEEN l.look_date - INTERVAL 1 hour AND l.look_date + INTERVAL 1 hour"
	. "\n AND s.active = 1"
	. "\n AND l.active = 1"

 

I'd also like to update field "s.read" to equal "s.read + 1"

though I'm not certain how to do that one,

 

any suggestions would be greatly appreciated

[fenway]

You can say s.read = s.read + 1, but that's not necessarily thread-safe.

[mikefrederick]

if it is an auto increment field, don't use sread+1. you have to retrieve the next increment, which is a little harder. let me know if you need help with that.

[amites]

it's not an autoincrement field,

 

it's just an int field used to count the number of times the record has been accessed,