now i want to filter/search the table for specific results so i did this
SELECT * FROM my_table WHERE name LIKE %$name% ORDER BY id DESC
thats all well and good, i can use anything as $name and it returns all the rows with $name in name..
now i want to filter them more so i try
SELECT * FROM my_table WHERE game_id = '1' OR game_id = '2' AND name LIKE %$name% ORDER BY id DESC
it gives me results where name is nothing like $name ?
any idea where im going wrong? or is there a better way to do what im trying to do?
if i havnt explained what im trying to do very well then please say so and ill try to explain a bit better [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /]
EDIT: forgot to say if i just do
SELECT * FROM my_table WHERE game_id = '1' AND name LIKE %$name% ORDER BY id DESC
but i want to be able to search for multiple game_ids...