select help needed

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

select help needed

Post by pelegk2 »

i have this code :

Code: Select all

select * from order_color where   month(from_unixtime(order_date)) = '2'  and year(from_unixtime(order_date))='2004'
an what i am missing i want to add to the select question todays day of the month!
how do i do that?
htnaks in advance
peleg
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Post Reply