timestamp

[daok]

Here is one field in my mySql database:

date_items timestamp(14)

When I insert or update it put the current date automatic. My problem is that I want to do a SELECT order to take only information who is over 2hours so how can I do that?

I tryed something like :

$sql = 'SELECT id_items , price_items , date_items
FROM Market
WHERE date_items < '.time().' - (2*3600)
ORDER BY '.$type_order.' '.$type_croissant.' LIMIT '.$first.', 30';

Doesn't work...how can I do that?

[jkohns]

I'd use the UNIX_TIMESTAMP function-

SELECT id_items , price_items , date_items
FROM Market
WHERE (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`date_items')) > 7200)
ORDER BY '.$type_order.' '.$type_croissant.' LIMIT '.$first.', 30';

[daok]

jkohns you the man!

Thx! so much