I am trying to import products into my osCommerce website (localhost on a machine running win XP) using an import tool program but I get the following error messages.
Can you help? If you need more info let me know
Warning: Supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\admin\ProductsImport\index.php on line 135
Warning: Supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\admin\ProductsImport\index.php on line 141
Here are the relevant lines I think(marked with a *)
// Print the HTML table header (first row)
print "<table border=1 cellpadding=2 cellspacing=0>";
print "<tr>";
*for($i = 0; $i < mysql_num_fields($dataResult); $i++) {
echo "<th>".mysql_field_name($dataResult,$i)."</th>";
}
print "</tr>";
// Format data into an HTML table
*for($i = 0; $i < mysql_num_rows($dataResult); $i++) {
$dataRow = mysql_fetch_array($dataResult);
print "<tr>";
for($j = 0; $j < mysql_num_fields($dataResult); $j++) {
print "<td>".substr($dataRow[$j],0,30);
if(strlen($dataRow[$j]) > 30) print "...";
print "</td>";
}
print "</tr>";
}
print "</table>";
