long time no see! I see that devnetwork has got a new look, very nice, clean... +10
Can somebody help me with this problem?
This is the case:
i have a mysql table with members. This table has a field called regidate that contains the unix timestamp of the registration date. Till here, no problem.
Now i want to make a query where i want to call all the members that registered on for example '7 january 08'.
I found a way that works (code beneath), but i feel that this is not the beautifull way to script this case.
Here is how i did it:
Code: Select all
[color=#FF0000]$query = "SELECT * FROM members WHERE regidate > " . strtotime('7 January 2008')." AND regidate < " . strtotime('8 January 2008')."";[/color]
Many thanx in advance!
grtz,
tom