problem with counting records
Posted: Wed Feb 18, 2004 10:52 am
I am trying to count the records in a MySQL table to see if a record already exists.
A problem occurs when there is no duplicate. The line that causes me trouble is highlighted in bold. It causes the die statement to execute.
Please help!
Thanks
Hannah
This is my code:
$sql = "SELECT COUNT(verb_name) FROM verb WHERE verb_name = '$verbname'";
$res = mysql_query($sql) or die(mysql_error());
$numrecs = mysql_result($res,0) or die("problem");
if($numrecs>0) {
$display_block = displayWarning("That record has already been entered into the database.");
}
else {
$sql = "INSERT INTO verb VALUES('', '$verbname', '$verbtype', '$changesstem')";
mysql_query($sql) or die(mysql_error());
$display_block = displayConfirmation("The verb <i>$verbname</i> has been successfully added");
}
}
A problem occurs when there is no duplicate. The line that causes me trouble is highlighted in bold. It causes the die statement to execute.
Please help!
Thanks
Hannah
This is my code:
$sql = "SELECT COUNT(verb_name) FROM verb WHERE verb_name = '$verbname'";
$res = mysql_query($sql) or die(mysql_error());
$numrecs = mysql_result($res,0) or die("problem");
if($numrecs>0) {
$display_block = displayWarning("That record has already been entered into the database.");
}
else {
$sql = "INSERT INTO verb VALUES('', '$verbname', '$verbtype', '$changesstem')";
mysql_query($sql) or die(mysql_error());
$display_block = displayConfirmation("The verb <i>$verbname</i> has been successfully added");
}
}