I've got an mysql_fetch_array(): error and I can't see why, please help

sdm

I have been working on this page all day, it worked fine on local testing but now i've uploaded it I get this message mysql_fetch_array():

Would someone please have a look at this and see if they can see where the error is as it's driving me nuts.

Is anything wrong with this for a start ?

<?php
$rs = @mysql_connect("localhost", "pixelaceuk", "w469015e");
$rs = @mysql_select_db("pixelaceuk");
$sql = "select * from callevapark_businesses where category = $category";

$rs = @($sql);

while ($row = mysql_fetch_array($rs))
{
?>

Thanks,

SDM

sdm

This is the url where i am getting the error

http://www.pixelace.co.uk/callevapark/directory.php

Thanks,

SDM

Weedpacket

Take the @ signs off and then you might see some more useful error messages.

you can also use mysql_error() to get MySQL's take on what the error is, e.g.

$rs = mysql_query($sql) or die(mysql_error());

sdm

Thanks for that.

now i'm getting this message:

You have an error in your SQL syntax near '' at line 1

The code is:

<?php
$rs = mysql_connect("localhost", "pixelaceuk", "w469015e");
$rs = mysql_select_db("pixelaceuk");
$sql = "select * from callevapark_businesses where category = $category";

$rs = mysql_query($sql) or die(mysql_error());

while ($row = mysql_fetch_array($rs))
{
?>

Any idea what is causing it, it is only on initial arrival at the page, it works fine apart from that.

I'm grateful for any help as I need to resolve this in the next hour if possible.

Thanks

cgraz

I can't remember if this causes a syntax error or not, but it's all I see as a potential problem. Try placing single quotes around $category so your query looks like this

$sql = "SELECT * FROM callevapark_businesses WHERE category='$category'";

Cgraz