how to make or query in my sql ?

how can i do this query
select * from table where a=1 or b=2

because i get this error when i try "OR" query

 

Use <> if I remember correctly.

 

thank you for your answer but i need an example

 

I just tried the following:

select * from user where id=1 or id=2

and it works fine.

The example I gave you above was from visual basic so sorry about that.

 

when i try it i get

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result

 

That means something is wrong in your query, paste the whole thing here and make sure you have referenced the correct tables etc in the query.

 

SELECT * FROM `ids` WHERE `name` = '?' OR `age` = '?' LIMIT 1

 

Did you use mysql_error() to know the exact error?

 

you can use the below mysql query :

select * from table where fieldname=1 or fieldname=2;

I hope this is sufficient .