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