extract date from timestamp and compare

[omerbutt]

hi there i am making a page where customer can edit his current order, the tools i am using are mysql and php
i am using 2 tables for this
1.rage_uk_bulk_order
2.rage_uk_bulk_order_products

i have the time stamp in the 1st table rage_uk_bulk_order and all the other information in the 2nd table iall is going fine it is fetching all the records for the current user/customer but i want to display only those orders from the table that the user has ordered today not those of the previous for that i had to compare todays date with the time stamp saved in the 1st table and pick all those records and display them buit i am not getting it in the right format here is my query
THE ERROR CODE

Parse error: syntax error, unexpected ',' in D:\Server\htdocs\borialas\edit_bill.php on line 42
 

the above line 42 is the line no 27 here on this post
[PHP]
if(isset($_GET['a']) && isset($_GET['a1'])){
$bulk_odr_prod_id=substr(base64_decode($_GET['a']),17);
$odr_bulk_id=substr(base64_decode($_GET['a1']),12);
}
$tstamp=time();
$tstamp=date("Y-m-d",$tstamp);
$mem_id="2";
$str_ordEdit="SELECT
rage_uk_bulk_order.odr_bulk_stamp,
rage_uk_bulk_order_products.bulk_odr_prod_name,
rage_uk_bulk_order_products.bulk_odr_prod_price,
rage_uk_bulk_order_products.bulk_odr_prod_qty,
rage_uk_bulk_order_products.bulk_odr_prod_length,
rage_uk_bulk_order_products.bulk_odr_prod_weight,
rage_uk_bulk_order_products.bulk_odr_prod_version,
rage_uk_bulk_order_products.bulk_odr_prod_total,
rage_uk_bulk_order_products.odr_bulk_id,
rage_uk_bulk_order_products.bulk_odr_prod_id,
rage_uk_bulk_order_products.pro_id
FROM
rage_uk_bulk_order_products,rage_uk_bulk_order
WHERE
rage_uk_bulk_order_products.bulk_odr_prod_id='$bul k_odr_prod_id'
and
rage_uk_bulk_order_products.odr_bulk_id='$odr_bulk _id'
and
'$tstamp'=".date("'Y-m-d'".,."'rage_uk_bulk_order.odr_bulk_stamp'".)."" ;
//echo $str_ordEdit;
$res_ordEdit=mysql_query($str_ordEdit) or die(mysql_error().'<br />'.$str_ordEdit);
[/PHP]
thanks for any help in advance,
regards,
omer

[Atli]

Hi.

What are you trying to do in that line?
Incorporating the PHP date function into the MySQL query?

That won't work. PHP will need the actual value before it can format it, not just the column name in the MySQL query.

Try using the MySQL DATE_FORMAT function instead.