here is the error that i am getting:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/foxhollo/public_html/Nathan Code/displayorders.php on line 14
here is line 14:
Code: Select all
$orders = mysql_query("SELECT DISTINCT * FROM fhforders ORDER BY ordernumber");and here is the .php file that contains the code:
Code: Select all
<?php
include("top.inc");
if(isset($tobedeleted)){
mysql_query("DELETE FROM fhforders WHERE ordernumber="$tobedeleted"");
}
echo("<table align="center" width="600" bgcolor="#333333" border="3" bordercolor="black" cellspacing="0" cellpadding="3">" .
"<tr bgcolor="#666666"><td><b>Order Number</b></td><td><b>username</b></td><td><b>item number</b></td><td><b>date</b></td><td></td></tr>");
$tempcheck = "do not confuse me";
$orders = mysql_query("SELECT DISTINCT * FROM fhforders ORDER BY ordernumber");
while ($row = mysql_fetch_array($orders))
{
$ordernumber = $rowї"ordernumber"];
$username = $rowї"username"];
$itemnumber = $rowї"itemnumber"];
$material = $rowї"material"];
$quantity = $rowї"quantity"];
$date = $rowї"date"];
if($tempcheck!=$ordernumber)
{
echo("<tr><td><a href="displayorder.php?checking=$ordernumber">$ordernumber</a></td><td>$username</td><td>$itemnumber</td><td>$date</td><td><a href="$PHP_SELF" . "?tobedeleted=$ordernumber">delete</a></td></tr>");
}
$tempcheck=$ordernumber;
}
echo("</table>");
include("bottom.inc");
?>