Modify query

[zzz]

I have a table that among several fields has the following two:

item_posted

and

item_updated

I need to be able to query something like this except I need to be able to get the last item that was updated and if none is available or has NULL as default value get the one that was last posted:

SELECT *
FROM t1
WHERE ID = ".$myid."
ORDER BY item_posted ASC LIMIT 1

How do I perform that check on the fly?

[esukf]

Add a time_stamp field to the table and change your post item and update item scripts to insert and update the timestamp.

You can them use something like

 SELECT *
FROM t1
WHERE ID = ".$myid."
ORDER BY time_stamp DESC LIMIT 1

to get the last posted or updated item.