lasha Posted March 19, 2014 Share Posted March 19, 2014 Hello this error is my problem. help me please $query = "SELECT * FROM car WHERE owner = ".$_POST['owner'].""; Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/ Share on other sites More sharing options...
gristoi Posted March 19, 2014 Share Posted March 19, 2014 try $query = "SELECT * FROM `car` WHERE `owner` = '{$_POST['owner']}' "; Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473079 Share on other sites More sharing options...
lasha Posted March 19, 2014 Author Share Posted March 19, 2014 Ou thank you Gristoi ! But i don't understent why it doesn not work becouse i have made something like this in the past and works well can you explain whats wrong with this code? Thanks again Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473092 Share on other sites More sharing options...
gristoi Posted March 19, 2014 Share Posted March 19, 2014 mysql parses from right to left. you did not he single quotes around your post variable so it broke the syntax Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473096 Share on other sites More sharing options...
mac_gyver Posted March 19, 2014 Share Posted March 19, 2014 the value being put into the query is literal string data and needs to be surrounded by single-quotes so that it is treated as a string of characters, rather than a mysql keyword or a column name. Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473100 Share on other sites More sharing options...
lasha Posted March 19, 2014 Author Share Posted March 19, 2014 Thank you very much! You helped me so much to out from this lane... Thanks Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473107 Share on other sites More sharing options...
jazzman1 Posted March 19, 2014 Share Posted March 19, 2014 Quote needs to be surrounded by single-quotes @mac, why only by single-quotes? The values of string type just need to be quoted. I've never use double quotes to quote the value with char/varchar or date/time type but the following should be worked as well. $query = 'SELECT * FROM car WHERE owner = "'.$_POST['owner'].'"'; Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473108 Share on other sites More sharing options...
mac_gyver Posted March 19, 2014 Share Posted March 19, 2014 because, double-quotes can be enabled (a sql standard) to be used the same as back-ticks (a mysql specific abomination) and used around database, table, and column names, thereby breaking any query using double-quotes around string data and making it difficult to migrate to other database types - Quote If the ANSI_QUOTES SQL mode is enabled, it is also allowable to quote identifiers within double quotes: Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473109 Share on other sites More sharing options...
jazzman1 Posted March 19, 2014 Share Posted March 19, 2014 I'm agree with you by speaking of identifiers. But the issue we have here is about constants of char type. Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473111 Share on other sites More sharing options...
mac_gyver Posted March 19, 2014 Share Posted March 19, 2014 did you look at the OP's problem? he's getting an unknown column error because his $_POST['owner'] value has no quotes around it at all, producing a query - SELECT * FROM car WHERE owner = some_owner_name and the some_owner_name value is being interpreted as a column name. Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473113 Share on other sites More sharing options...
jazzman1 Posted March 19, 2014 Share Posted March 19, 2014 Quote did you look at the OP's problem? Yes, I do! In that case "owner" is the identifier, its value it is a constant named "some_owner_name". So, in the cite you cited above we can allowable to quote identifiers within double quotes, like this: SELECT * FROM car WHERE "owner" = some_owner_name. Link to comment https://forums.phpfreaks.com/topic/287080-error-unknown-column-in-where-clause/#findComment-1473114 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.