[SOLVED] Problem with simple mysql select query

[robs99]

Hello,

i have a problem with a mysql query. this is my query:

 

SELECT * FROM `posts`
WHERE `bandname` LIKE '%something%' OR `title` LIKE '%something%'
AND `deleted` = ''
AND `approved_by` != ''
ORDER BY `date` DESC , `id` DESC LIMIT 0 , 30

 

im trying to perform a search (my search parameter is 'something'). the results show up properly, but it ignores the rest of the query. deleted and unapproved posts still show up for some reason...any ideas?

 

thanks in advance

[aschk]

What does your data actually look like? Surely 'deleted' should be a boolean field, and 'approved_by' a varchar?

[robs99]

What does your data actually look like? Surely 'deleted' should be a boolean field, and 'approved_by' a varchar?

both fields are varchars (deleted contains the name of the user who deleted it)

[aschk]

In which case it's to do with the order of precedence of the operators you're using.

Try:

SELECT * FROM `posts`
WHERE (`bandname` LIKE '%something%' OR `title` LIKE '%something%')
AND `deleted` = ''
AND `approved_by` != ''
ORDER BY `date` DESC , `id` DESC LIMIT 0 , 30

[robs99]

thanks that solved it