Re: [PHP] Good eve

2002-12-07 Thread rolf vreijdenberger
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 in

Re: [PHP] Good eve

2002-12-06 Thread Miguel Brás
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

Re: [PHP] Good eve

2002-12-06 Thread rolf vreijdenberger
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

Re: [PHP] Good eve

2002-12-06 Thread Brad Bonkoski
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/

[PHP] Good eve

2002-12-06 Thread Miguel Brás
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