[SOLVED] Why can't I delete this database entry?

[vomitbomb]

For some reason I can print out these values, but I can't delete them, do I have the DELETE syntax wrong or something?

 

I am using basically the same code on another page using SELECT instead of DELETE and that works.

 

$search = $_GET['search'];
$searchl = $_GET['searchl'];

echo $search;
echo $searchl;

echo "<h3>Deleting order name: $search $searchl</h3><br>";

//create a query

$sql = "DELETE * FROM orders WHERE lname LIKE '$search' AND fname LIKE '$searchl'";
$result = mysql_query($sql, $conn);

[jonsjava]

change result to this:

$result = mysql_query($sql, $conn) or die("Query failed due to: ".mysql_error());

[beebum]

$sql = "DELETE FROM orders WHERE lname LIKE '$search' AND fname LIKE '$searchl'";

 

You don't specify columns with DELETE.

[vomitbomb]

thanks!

[jonsjava]

Wow. I'm blind.