mysql query - insert new while delete old entries

[Dj_Jestar]

 

[marc2003]

/off topic

INSERT blah blah ON DUPLICATE KEY UPDATE field1=blah field2=blah

thanks for that. because i suck so much i didn't know you could do that. until now i've been running a select query first and then running either an update or insert depending on the result.