$result = mysql_query("SELECT * FROM cycles WHERE Upper(brand) LIKE '%$brandC%' AND type LIKE '%$typeC%'");

Above code is not working, pls help.

$result = mysql_query("SELECT * FROM cycles WHERE Upper(brand) LIKE '%$brandC%' AND type LIKE '%$typeC%'");

Above code is not working, pls help.

the syntax of your query is ok. Something else is going on here. Can you post more code or any MySQL errors you are getting?

managed to solve myself. Thank you very much for your reply.