help with a mysql query? Huh
Posted 02 September 2006 - 02:32 PM
So...I have a field in a table, with a date int. It's a script that groups news elements by day. Then all the news for that specific day must be displayed. And I'm having trouble with that...
The int in the database field contains the info of the day, year, month etc (basically date("U") )
But I only need to get the day, to get all the news of a specific day...how could I make a query like that ???
Posted 02 September 2006 - 02:40 PM
Posted 02 September 2006 - 02:44 PM
And I can format that date to my likings to get day/month/etc... that's why I use it. But I only need to compare the day...and I can't figure out how to make a query like that one..
thanks for your help
Posted 02 September 2006 - 04:14 PM
<?php $timestamp = time(); $day = date("j", $timestamp); ?>Then use $day in your SQL query.
Note j in the date function returns the day without the leading zero eg (1 - 31)
if you wnat the leading zero use d
Posted 02 September 2006 - 05:34 PM
in your example I would have to do something like
SELECT * FROM news WHERE dateint='$day'
and that wouldn't work out, would it?
Posted 02 September 2006 - 05:46 PM
As it is, the only route I see is to get a specific date (via form input or URL) and then process it so as to get the 'time' at 00:00 on that day and the 'time' at 23:59 on that day and then do a SELECT where yourtimefield is less than the 23:59 time AND yourtimefield is more than the 00:00 time.
Posted 02 September 2006 - 05:49 PM
Posted 02 September 2006 - 05:55 PM
... wanted to know if someone knew how to do it
Isn't that what I just told you? Write a snippet of code to try. The manual pages on the date() and time() functions tell you all you need to know. If you run into trouble, post your code and explain the troubles you're having.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users