[RESOLVED] sql delete problem

[cashton2k]

why doesnt this work?

<?php
include "auth_admin.inc.php";
include "../conn.inc.php";

$quizselected = $_POST["selectedquiz"];
$qno = $_POST["QNO"];

$sqldelete = "DELETE * FROM $quizselected WHERE QNO = '$qno';";

$sql_result = mysql_query($sqldelete) or die("Couldn't delete from database, please contact your system administrator: $sqldelete - " . mysql_error()); 


?>

i get the following error

Couldn't delete from database, please contact your system administrator: DELETE * FROM privatequiz WHERE QNO = 2; - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM privatequiz WHERE QNO = 2' at line 1

cheers for any help

[chazzy]

it should just be:

DELETE FROM your_table WHERE where_conditions;

no *. You delete rows, you don't delete cells.

[cashton2k]

cheers mate