I’m please asking for help with this mysql_query error I keep getting.
I’ve coded an online examination where if a person enters text resembling the statements stored in the database, points will be added. Following is the main part of this code:
$sql1 = mysql_query("SELECT * FROM formone_ex1_secthreesr WHERE MATCH (q1) AGAINST ($uno)");
$result1 = MySQL_query($sql1) or die(mysql_error());
//if results have been found add two points!
while($r1=mysql_fetch_array($result1))
{
$q1=$r1["q1"];
$a = 2;
}
//if no results have been found this function adds zero points!
if (!$q1)
{
$a = 0;
}
//end
$sql2 = mysql_query("SELECT * FROM formone_ex1_secthreesr WHERE MATCH (q1) AGAINST ($dos)");
$result2 = MySQL_query($sql2) or die(mysql_error());
//if results have been found add two points!
while($r2=mysql_fetch_array($result2))
{
$q2=$r2["q1"];
$b = 2;
}
//if no results have been found this function adds zero points!
if (!$q2)
{
$b = 0;
}
Yet when I use this code, I get the error “Query was empty”.
I know this means my query is failing, but where?!
I really can’t see why it is, it looks fine to me…