show only that date is

jansky

hello to all guru

how can i display date that is lesser than the date today

here is my table

id | date (date format)
1 2005-3-12
2 2005-1-19
3 2005-11-28

halojoy

jansky wrote:
hello to all guru

how can i display date that is lesser than the date today

here is my table

id | date (date format)
1 2005-3-12
2 2005-1-19
3 2005-11-28

when you store 'timestamp' field in that (problem) database
you should do like this.

<?php

//first read time
$timestamp = time();
// store $timestamp into that MoXXX database TYPE 'timestamp' = a number

?>

'timestamp' in table IS NOT a STRING
it is a number from time();

if you want store date string, you can call column
TABLE 'mytable' COLUMN 'my_date_string' TYPE 'string'

You understand what I say???
hope so..

/halojoy

Weedpacket

I do believe that MySQL has some date and time functions that would allow you to obtain today's date, and compare it with the date stored in a date field. Consulting the MySQL manual on this will get you your answer.

inerte

SELECT id, date
FROM table
WHERE data < CURRENT_DATE()