UPDATE on consecutive records issue

lottos

UPDATE 'table_posts' SET fid="15" WHERE fid="6" AND closedate <> '0' AND closedate < CURRENT_DATE()

Only problem is that there are also other records that I want to update the fid record on that don't have the close date.

These records share same unique 'tid' record number but I only want to update them if the first record that has the closedate is less than today's date.

fid=6, closedate=20030709, tid=21, pid=11 update works
fid=6, closedate=, null tid=21, pid=12 want to update
fid=6, closedate=, null tid=21, pid=13 want to update

Can anyone help me on this one?

barand

Sounds like you need 2 queries

SELECT tid FROM table_posts WHERE closedate IS NOT NULL AND
closedate < CURRENT_DATE

Then, for each $tid returned by that query

UPDATE table-posts SET fid="15" WHERE fid="6" AND tid = $tid

hth