[SOLVED] Sort by date problem

[mikebyrne]

I want my program to list all orders that have been procesed today.

 

At present my code looks like

 

<table width="850" border="0" cellspacing="0" cellpadding="0">
<?php
// let's get some data
include('adminconnect.php');
$sql = mysql_query("SELECT OrderNo, Orderdate, Custname, Amount, Shippingmet FROM admin WHERE Orderdate = 01/22/08");
while( $row = mysql_fetch_array($sql) ) {
// loop through and display
?>

<tr align="left">
<td width="33"> </td>
<td width="82"><a href="javascript:openWindow('popup_detail.html', 'NewWindow', 615, 600)" class="black"><?php echo $row['OrderNo'];?></a></td>
<td width="61"><?php echo $row['Orderdate'];?></td>
<td width="61"><?php echo $row['Dispatchdate'];?></td>
<td width="230"><?php echo $row['Custname'];?></td>
<td width="170"><?php echo $row['Trackno'];?></td>
<td width="56" align="right"><?php echo $row['Amount'];?></td>
<td width="21"> </td>
<td width="136">test</td>
</tr>


<?
}
?>
</table>

 

Is the a varible that will automatically assign todays date so I wont have to keep changing the date??

 

Also the date fields are in US Format in my database so that will make a difference

 

[rajivgonsalves]

this 

 

 

$sql = mysql_query("SELECT OrderNo, Orderdate, Custname, Amount, Shippingmet FROM admin WHERE Orderdate = 01/22/08");

 

should be

 

$sql = mysql_query("SELECT OrderNo, Orderdate, Custname, Amount, Shippingmet FROM admin WHERE Orderdate = CURR_DATE");

 

hope its helpful

[mikebyrne]

I tried that before but I'm getting an error

 

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\Admin_files\New.php on line 210

 

Line 210 refers to

 

//loop through records

 

so i assume the line above it is the problem

 

[rajivgonsalves]

try this

 

 

$sql = mysql_query("SELECT OrderNo, Orderdate, Custname, Amount, Shippingmet FROM admin WHERE Orderdate = DATE_FORMAT(now(),'%m/%d/%y')") or die("Cannot execute :".mysql_error());

[mikebyrne]

THANKS!!!!