Hi,
I am trying to create results that tell how many days an order is overdue, but I can't get php to evaluate the expression I want use. It gives me a parse error saying the the less taht or equal sign is unexpected:
$datequery = "SELECT DATEDIFF(dd,orderdate,GETDATE()) as daysoverdue
from mydb.dbo.orders
where orders.ordernumber = $ordernumber;";
$dateresult = mssql_query($datequery) or die ("Error in query: $datequery. ".mssql_error());
while ($daterow = mssql_fetch_row($dateresult)){
$od_date = int($daterow[0]);
if ( $od_date >= 1 && <= 30 ) {
echo "<tr><td><b>1-30 Days Past</b></td>
<td>$ordernumber</td>";
} else {
echo "<tr><td><b>1-30 Days Past</b></td>
<td>$0.00</td>";
}
}
Can someone help me out?