sorry, I read your post wrong!
don't use php functions, but use native database functions.
in mysql you can use date_format()
SELECT field from table where date=DATE_FORMAT(now(), '%d/%m/%y);
this makes the format of now(), which is 2002-12-07 into a format with first
the days of the week
I have a table with several field, one of them has a date insertion on the
d/m/y format.
I would like to return only the data for the present day (today will be date
05/12/02 tomorrow will be 06/12/02)
I will do SELECT field1, field2, field3 FROM table WHERE date=?
What is missing on the
Check out:
http://www.php.net/manual/en/function.mktime.php
HTH
-Brad
Miguel Brás wrote:
I have a table with several field, one of them has a date insertion on the
d/m/y format.
I would like to return only the data for the present day (today will be date
05/12/02 tomorrow will be 06/12/02)
SELECT field1, field2, field3 FROM table WHERE date=NOW()
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
thx to both
Miguel
Rolf Vreijdenberger [EMAIL PROTECTED] escreveu na mensagem
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
SELECT field1, field2, field3 FROM table WHERE date=NOW()
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
5 matches
Mail list logo