[RESOLVED] Another logic problem

182x

Hey guys I am using the folloiwng code in order to delete a user and then delete data from another table which is related by the username field.

<?php
$q = "select Username from `table` where UserID = '$_POST['userid'];
$result = mysql_query($q) or die(mysql_error());
if(mysql_num_rows($result)){
$row = mysql_fetch_array($result);
$q2 = "Delete from `table2` WHERE Username = {$row['username']}";
$result2 = mysql_query($q2) or die(mysql_error());
?>

But then I get the the following error where jess is an actual username. Anyi deas why this is happening?

Unknown column 'jess' in 'where clause'

NogDog

You need to put single quotes around the literal values in SQL if they are not numeric:

$q2 = "Delete from `table2` WHERE Username = '{$row['username']}'";

182x

Thank you very much.

182x

If the value is numeric does it still require the single quotes?

And by numeric do you mean that the datatype could be for example varchar and if a number is entered into a varchar colum its still classed as numeric?

laserlight

If the value is numeric does it still require the single quotes?

No, and in fact it may even be incorrect to have the single quotes.

And by numeric do you mean that the datatype could be for example varchar and if a number is entered into a varchar colum its still classed as numeric?

No, the datatype of the column should be numeric. That said, I think SQLite is an exception here due to its manifest typing and column affinity system.