Query not working?

[rfigley]

Can anyone tell me what the problem, is with this?

Here is my output for:

tenant for Deletion: 1
Tenant ID: 00054

tenant for Deletion: 2 Tenant ID: 00054
(with the error)

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 '00054'' at line 1

for this code:
include('dbconnect.php');
echo "tenant for Deletion: 1" . $tenant_name . "<BR>Tenant ID: " . $tenant_ID . "<BR><BR>";

	     $query = ("SELECT * FROM `tenant_profile` WHERE `tenant_ID` = `$tenant_ID`");
	 echo "tenant for Deletion:  2 " .  $tenant_name . "Tenant ID: " .  $tenant_ID . "<BR><BR>";

$result = mysql_query($query) or die (mysql_error());

[Drakla]

take the last set of backticks away from $tenant_ID - hopefully your preceeding zeroes won't end up making the value get parsed as octal, deleting not member 54, but 44