[SOLVED] "Or" and "sequence" mysql query

[sungpeng]

$sql = "SELECT * FROM users WHERE specialise1 LIKE '%$specialise1%' or specialise2 LIKE '%$specialise1%' or specialise3 LIKE '%$specialise3%' ORDER BY listdate LIMIT $offset, $rowsperpage";   

 

First I would like to check whether the sequence for WHERE, ORDER, LIMIT is correct.

Second I see the 'or' seen not working. pls help

 

 

[rashmi_k28]

specialise1,specialise2,specialise3 should be a field name 

[sungpeng]

yes it is a field name. The "OR" is not working. Is there another "OR" symbol for php. || I try cannot work??

[Mchl]

The query looks fine. Do you get any errors running it?

[fenway]

Also, you should normalize your table.

[sungpeng]

must use "OR" instead of "or". Thank 

[Mchl]

Nope. MySQL keywords are not case sensitive.