Posted by Dave Nash on 01/11/07 10:43

I have a site working locally fine with PHP

Local php version = PHP Version 4.4.3
Live version = Version 4.3.2


Ive then moved the site live to test and I keep getting the following
error

Couldn't execute query

code is as follows.

$query = "select * from categories where parentid = $catid";
$result = mysql_query($query) or die ("Couldn't execute query");
$numofrows = mysql_num_rows($result);
for($i = 0; $i < $numofrows; $i++) {
$row = mysql_fetch_array($result);
echo "<div class=\"boxfront\">";
echo "<div class=\"thumbimage\"><a
href=\"list_items.php?catid=".$row['catid']."\" class=\"a\"><img
src=\"upload/".$row['image']."\" border=\"0\"></a></div>";
echo "<div class=\"thumbtitle\"><a
href=\"list_items.php?catid=".$row['catid']."\"
class=\"a\">".$row['catname']."</a></div>";
echo "</div>";
// end constant menu
}

[Back to original message]