[we_undertaker]

$query = "insert into item(item_title, item_price, item_category, item_closedate, iterm_pic, user_id) values('".$_POST['item_title']."', '".$_POST['item_price']."', '".$_POST['item_category']."', '".$_POST['close_year']."-".$_POST['close_month']."-".$_POST['close_day']."'	,'".$filename."',  ".$_REQUEST['userid'].")"; 

this is the query that i will insert into database, but i got stuck that.
i dont know how to display the item in the auction pages, that products are be4 close date. if any product after closedate then it will not display in the auction page.. its about the date in sql. but this problem first time i face...i tried to search but could not help...
plz help me.

[pemcconnell]

Solution:

you can use mathmatical operators on the date in a where clause, for example:

[code]
SELECT * FROM table WHERE closedate < NOW();
[code]

Notes:

This should be reviewed if you are to make this a production level application, as the above query won't cache as you are causing the query to change every time it is executed. An ideal solution would be to generate the date in php and pass that to the SQL query so it can just cache the results on a daily basis (meaning you have a faster and more efficient application). But don't worry about that stuff yet if you are only starting MySQL. It will work either way.

This post has been edited by pemcconnell: 22 April 2009 - 06:39 AM