Baffling MySQL error!

This MySQL error has got me totally baffled! but maybe it just needs another pair of eyes to find out whats wrong, but here it is:

this is the page: subcategories.php?cat=Explorations

and this is the coding:

Quote:

<html>
<head>
<title>Items</title>
<body topmargin=0 leftmargin=0 bgcolor=555555>

<?php
$connection = mysql_connect ("localhost", "******", "********");
if ($connection == false) {
echo mysql_errno().": ".mysql_error()." ";
exit;
}

$query = "select * from exp_dl_subcate where cat=".$catup;
$result = mysql_db_query ("tnrstudios", $query);

if ($result) {

$numOfRows = mysql_num_rows ($result);
for ($i = 0; $i < $numOfRows; $i++){
$name = mysql_result ($result, $i, "name");
$catup = mysql_result ($result, $i, "catup");
$description = mysql_result ($result, $i, "description");
$date = mysql_result ($result, $i, "date");
$id = mysql_result ($result, $i, "id");

echo "$name - $description - $catup";
}

} else {
echo mysql_errno().": ".mysql_error()."";
}

mysql_close ();
?>

</table>
</body>
</html>

and this is the error I get:
1064: You have an error in your SQL syntax near '' at line 1

IM BAFFLED! :p any help or ideas is appreciated :)

Baffling MySQL error! ( 6 Views )

Related Topics ... (or search in 1.720.883 topics !)