[SOLVED] Simple SELECT query just not working

[sloth456]

Ok, this has been irritating the £$%* out of me for the past hour and a half.

 

I've sucessfully connected to my mysql database and am using the following code to select some data

 

$sql="SELECT url,anctext,aclinks,linkcap FROM clientsites WHERE index='$siteid' AND active='1'";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);

 

I get an error pointing to the first line saying there's some kind of SQL syntax error.  If I remove the

 

WHERE index='$siteid' AND active='1'

 

it pulls the data fine, just not the exact data I want.

 

Essentially I'm asking, what's wrong with this line

 

$sql="SELECT url,anctext,aclinks,linkcap FROM clientsites WHERE index='$siteid' AND active='1'";

 

I'm thinking I've made a simple error, but just haven't spotted it.  Any suggestions?

 

[GKWelding]

try

 

$sql="SELECT url,anctext,aclinks,linkcap FROM `clientsites` WHERE `index`='$siteid' AND `active`='1'";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);

[sloth456]

Thanks for the fast reply - I've used those wierd apostrophe's before but just couldn't remember the syntax.

 

Anyway, everything works now!

 

Problem solved.

[GKWelding]

Yeah, backticks solve everything MySQL related!!!! Lol.