need help with code plz - unkown error

[jas_singh]

<?php
$username ="ictcranfor";
$password="s29698";
$database ="ictcranfor";

mysql_connect ('mysql4.streamline.net',$username, $password) or die ("Unable to connect".mysql_error());
mysql_select_db ($database);

$licencenumber_submitted=$_POST['licencenumber'];
$title_submitted=$_POST['title'];
$firstname_submitted=$_POST['firstname'];
$surname_submitted=$_POST['surname'];
$age_submitted=$_POST['age'];
$gender_submitted=$_POST['gender'];
$address_submitted=$_POST['address'];
$postcode_submitted=$_POST['postcode'];
$telephonenumber_submitted=$_POST['telephonenumber'];
$email_submitted=$_POST['email'];
$registrationdate_submitted=$_POST['registrationdate'];
$criminalrecord_submitted=$_POST['criminalrecord'];
$username_submitted=$_POST['username'];
$password_submitted=$_POST['password'];
$confirmpassword_submitted=$_POST['confirmpassword'];

$query="SELECT licencenumber, title, firstname, surname, age, gender, address, postcode, telephonenumber, email, registrationdate, criminalrecord, username, password, confirmpassword FROM jsi_registration";
$result = mysql_query($query) or die ("error in query".mysql_error());

echo "<TABLE BORDER=1>";
echo "<TR><TH>LicenceNumber</TH><TH>Title</TH><TH>Firstname</TH><TH>Surname</TH><TH>Age</TH><TH>Gender</TH><TH>Address</TH><TH>Postcode</TH><TH>Telephone Number</TH><TH>Email</TH><TH>Registration Date</TH><TH>Criminal Record</TH><TH>Username</TH><TH>Password</TH><TH>Confirm Password</TH><TH>Reject</TH></TR>";
while ($row = mysql_fetch_array($result))
{
$licencenumber = $row["licencenumber"];
$title = $row["title"];
$firstname = $row["firstname"];
$surname = $row["surname"];
$age = $row["age"];
$gender = $row["gender"];
$address = $row["address"];
$postcode = $row["postcode"];
$telephonenumber = $row["telephonenumber"];
$email = $row["email"];
$registrationdate = $row["registrationdate"];
$criminalrecord = $row["criminalrecord"];
$username = $row["username"];
$password = $row["password"];
$confirmpassword = $row["confirmpassword"];
echo "<TR><TD>$licencenumber</TD><TD>$title</TD><TD>$firstname</TD><TD>$surname</TD><TD>$age</TD><TD>$gender</TD><TD>$address</TD><TD>$postcode</TD><TD>$telephonenumber</TD><TD>$email</TD><TD>$registrationdate</TD><TD>$criminalrecord</TD><TD>$username</TD><TD>$password</TD><TD>$confirmpassword</TD><TD><p><form action='new_applications.php'><input type='radio' name=reject><input type=hidden value=$licencenumber name=hidden></p></TD></TR>";
}
echo "<tr><td colspan=16 align=right><input type='submit' name='Submit' value='Submit'></td></tr>";
echo "</TABLE>";

if ($licencenumber == $hidden)
{
$query ="DELETE * FROM jsi_registration where licencenumber = '$hidden'";
$me = mysql_query($query) or die ("error in query".mysql_error());
};

mysql_close();
?>


error in queryYou 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 jsi_registration where licencenumber = '23'' at line 1


ANY IDEAS WELCOME. THNX::thumbsup:

[vinyl-junkie]

Try this:

$query ="DELETE * FROM jsi_registration where licencenumber = '".$hidden."'";
If that doesn't work, try this:

$query ="DELETE * FROM jsi_registration where licencenumber = $hidden";