[SOLVED] Error in Code? Can anyone be my Hero and Spot it?

[jeaker]

I have a little problem. I have the below code that gives a list box...

 

<?php
  // Query the teacher table and load all of the records
  // into an array.
  $sql = 'SELECT * FROM teacher';
  $res = mysql_query($sql) or die(mysql_error());
  while ($rec = mysql_fetch_assoc($res)) $fname[] = $rec;
  echo '<SELECT name="fname">';
echo "<option></option>\n";
  foreach ($fname as $f)
    echo "<OPTION>{$f['fname']}  </OPTION>\n";
  echo '</SELECT>';
  ?>

 

It list the First name of some teachers. The user is supposed to be able to click DELETE and run the code below....

 

<?php
include 'library/config.php';
include 'library/opendb.php';


$fname=$_POST['fname'];

$sql = "DELETE FROM teacher WHERE fname = '$fname'";

	mysql_query($query) or die('Error, query failed');					


	echo "<br>Teacher $fname deleted<br>";
?>

 

That code is supposed to delete the entire record wherever it finds that first name in the the table 'teacher'. However I continue to get the error "Error, query failed". I know it is probably an error in my sql statement somewhere, but I have been trying for the past 3 hours to get something to work and I have nothing. If anyone has any advice it would be greatly appreciated.

Thanks so much!!!

[btherl]

Can you show us the output of "echo $sql;" just after you set $sql for your delete statement?

[btherl]

Oh, I didn't look properly.  You should use mysql_query($sql), not mysql_query($query)

[jeaker]

WOW, Thanks btherl for the fresh set of eyes. Been looking at code way too long today.