Page 1 of 1

Unknown Column in Field List

Posted: Tue Jul 13, 2010 10:28 am
by Skiddles2010
The error:
Unknown column 'item' in 'field list'
The relevant code:

Code: Select all

$result = mysql_query("SELECT $add_type " . "_name FROM t_" . "$add_type WHERE $obj_name = $add_type" . "_name") or die(mysql_error());
Basically I'm trying to append "_name" to the $add_type string, so that it works something like this:

$add_type = "school";
SELECT school_name FROM t_school ...

I need to be able to append the _name and pre-pend(?) t_ so that this code can dynamically process inputs from a number of different types of forms.

Re: Unknown Column in Field List

Posted: Tue Jul 13, 2010 10:36 am
by AbraCadaver
I assume that $add_type = item in this case? It is probably the extra space you have after the first $add_type in the query.

Re: Unknown Column in Field List

Posted: Tue Jul 13, 2010 10:41 am
by Skiddles2010
Ahh, thanks. Works.

Re: Unknown Column in Field List

Posted: Tue Jul 13, 2010 10:42 am
by Weirdan
It's easier to use curly braces in such cases (assuming the add_type and obj_name variables are properly filtered/encoded):

Code: Select all

$result = mysql_query("
       SELECT {$add_type}_name 
       FROM t_{$add_type} 
       WHERE {$obj_name} = {$add_type}_name
") or die(mysql_error());

Re: Unknown Column in Field List

Posted: Thu Jul 15, 2010 7:29 am
by Skiddles2010
Nice one Weirdan.