Select st using where clause

[chinni_77]

Hello everybody,

I want to display the article name based on the article category.I'm writing a search script and when the user types the article category keyword(Ex: Analog, Digital and so on..), I have to show the article names which belong to the keywords.

SELECT * FROM [tablename] WHERE Article_Category LIKE $trimmed ORDER BY article_id ASC;

$trimmed is nothing but, to trim the white space and q is the name of my text box.

$var = @$_GET['q'] ;
//trim whitespace from the stored variable

$trimmed = trim($var);

COuld somebody please tell me whats wrong in my sql statement.

Thanks everybody

[xblue]

anything that is non-numeric must go in quotes or it is mistaken as column name.

SELECT * FROM [tablename] WHERE Article_Category LIKE '$trimmed' ORDER BY article_id ASC;

btw, is the keyword contained in that Article_Category field or is it exactly matching?

if the first, you would need wildcards (LIKE '%$trimmed%'). if you don't need wildcards you should be able to use = instead of LIKE just as well.

[ir4z0r]

what happens then?

either use
WHERE Article_Category = '$trimmed'

or
WHERE Article_Category LIKE '%" . $trimmed . "%' ...