Strange SQL response

Hi,

Strange thing is happening. A SQL statement that worked before is providing a 'true' response irrespective now. Weird.

SQL = SELECT * FROM student WHERE sname='Surname' AND fname='First Name' AND email='email@email.com'

Language: PHP
$SQL="SELECT * FROM student WHERE sname=';".$form_value[1]."'; AND fname=';".$form_value[3]."'; AND email=';".$form_value[14]."';";
 
		$result=mysql_query($SQL)
			or die(mysql_error());
 
		if($result)
                {//student exists
                }
                else
                {//new student
                }

So the code above returns true no matter if the values exist or not.

I even deleted the 'student' table and reloaded it incase it became corrupt. Did not work.

Any ideas from your side would be very helpful.

Thanks
Ian

IN a rush here... add a num_rows line and echo it out. If it is empty but there is rows, then check the db field types.

they to echo $form_value[1] , $form_value[3], $form_value[14] and see what you get

agh its a Friday - I meant try to echo...

Hi there,

I followed everyone's suggestions but still could not find the problem.

So instead I will work around the issue and do what Mac suggested, i.e. use numrows as a search criteria.

Thanks again.

Ian

echo statement was not supposed to solve a problem, but it just shows what values ou are sending to your SQL statement. if you are getting bad values or no values, than you know where your problem is...