Hi all, I hope you can help me with this error: Query Error:Unknown column 'x' in 'where clause' this happens when i click on search function on site, the code using this is: $node->where .= " and (`ExpireDate` > NOW())"; } if($post['q_text'] != ""){ if($post['search_both'] != ""){ $node->select .= ", MATCH(`Title`, `Description`) AGAINST ('".addslashes($post['q_text'])."' IN BOOLEAN MODE) AS `SScore`"; $node->where .= " and MATCH(`Title`,`Description`) AGAINST ('".addslashes($post['q_text'])."' IN BOOLEAN MODE) "; $post['sortCol'] = "SScore"; $post['sortBy'] = "DESC"; } else{ $node->where .= " and MATCH(Title) AGAINST ('".addslashes($post['q_text'])."') "; } } return "(".$mysql->selectSql($node).")"; } PHP:
that mean the column 'x' is not exists in the table but you did not use a column called 'x' , put the file !
What the error basically says is that your script is trying to access an SQL column named 'x' - but it does not exist in the database. We can't fix the error from what you've posted here - you might want to tell us more about your code, or if you are using some well-known software.