sql error ?

[Alicia]

Hi,

 

I encounter this error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

on this query :

$result = mysql_query("SELECT * FROM `vrequest` WHERE `type`='student now' AND `to`='$id'") or die(mysql_error());

 

I have checked multiple times and really have no idea whats wrong with this simple query.

 

please advise.

[rhodesa]

what is the value of $id?

 

what does this output:

$sql = "SELECT * FROM `vrequest` WHERE `type`='student now' AND `to`='$id'";
print $sql;
$result = mysql_query($sql) or die(mysql_error());

[Alicia]

number-- e.g : 1, 21, 311 and etc

 

SELECT * FROM `vrequest` WHERE `type`='student now' AND `to`='1'

[rhodesa]

well...i don't see anything semantically wrong with your code. again, do the print $sql code to make sure the value of $id is what you expect. also, try changing this:

die(mysql_error());

to something more distinguishing:

die("Failed to SELECT from vrequest: ".mysql_error());

just to make sure that is the actual point of failure

[Alicia]

yes., $id is the value i am expecting..

[rhodesa]

if you echo the query, and copy/paste it into phpMyAdmin (or whatever you use to manage your DB), does it work?

[Alicia]

yes,, it works in phpmyadmin

 

[rhodesa]

well...there is nothing wrong with the code you posted. further remediation:

 

1) Make sure you are definitely looking at the place where the problem is

2) Make sure your quotes are copied from MS Word...it uses different quotes. Just to be safe, open the file in a basic text editing (like notepad), then delete each quote and type it back in...just to make sure. it sounds silly, but a lot of problems are caused by this.

[PFMaBiSmAd]

Unless $id contained something with a single-quote in it, nothing you have posted so far would generate that error.

 

Does your code contain any other queries and what is the code that produces $id, both originally in your form or link and how is it processed before being put into the query? Show all your code to get the quickest solution.

[fenway]

Show all your code to get the quickest solution.

Maybe *all* isn't the best idea -- isolate the query first.

[Alicia]

thats all I have in my script with

$id ='1';

 

tried

$id ="1";

 

$id =1;

 

still showing the same error even i replaced * with column names and remove the where clause...

 

a simple query like select * from vrequest caused the same error too.. oh gosh, what happened to my computer,, is it computer prob or what

[rhodesa]

do other queries work? cus again, there is nothing semantically wrong with your code.

[fenway]

Start again -- new file, new script -- run a simple query, make sure it works.