can anyone tell me why i get this error??
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/quotes/test2.php on line 12
<?php include "header.php" ?>
<center>
<?PHP
$db = mysql_connect("xxxx", "xxxx", "xxxx") or die("Problem connecting");mysql_select_db("xxxx") or die("Problem selecting
database");
echo "<B>$YEAR $MAKE Options</b>";
echo "<br></br>";
echo "<TABLE BORDER=\"0\" width=\"50%\">";
echo " <tr>\n" .
" <TD width=\"30%\"><font color=\"#dd0000\" size=\"2\">MAKE<TD width=\"30%\"><font color=\"#dd0000\" size=\"2\">MODEL<TD width=\"30%\"><font
color=\"#dd0000\" size=\"2\">BODY</b></td>\n" .
" </tr>";
$result2 = mysql_query("SELECT * FROM glass WHERE gg LIKE '%$MF_PART_NO%' Order by MF_PART_NO ASC", $db);
while (list($PART_ID, $COLOR, $ATTACH, $PREMIUM, $DESCRIP, $BLOCK1, $BLOCK2, $GASKET, $MOULDING, $CLIPS, $ADHESIVE, $TSB, $MF_ID, $MF_PART_NO, $PRICE,
$P_DATE, $PREV_P, $P_P_DATE, $PRICE_D, $P_PROCE_D) = mysql_fetch_row($result2)) {
echo " <tr>\n" .
" <TD width=\"30%\"><font color=\"#000000\" size=\"2\"><a href=\"select.php?MF_PART_NO=$MF_PART_NO\">$MF_PART_NO<TD width=\"30%\"><font
color=\"#000000\" size=\"2\"><a href=\"select.php?MF_PART_NO=$MF_PART_NO\">$MODEL<TD width=\"30%\"><font color=\"#000000\" size=\"2\"><a
href=\"select.php?MF_PART_NO=$MF_PART_NO\">$BODY</a></b></td>\n" .
" </tr>\n";
}
?>
</center>
<p align="center"><font face="Arial" size="2" color="#FFFFFF">*</font></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<?php include "footer.php" ?>
I have tried assoc,and array also, same error.
Michael
