RE: SQL Sort/Order Search results

[kamal213]

Hi guys,

 

I have this SQL query which I use in my PHP search script

$query_for_result=mysql_query("SELECT * FROM customer WHERE c_name like '%".$query."%' OR c_telephone like '%".$query."%' OR c_address like '%".$query."%'");

 

It works fine, the only problem is now my database is bigger I would like to be able do SORT or ORDER BY id so that my search results are in order from asc to desc.

 

Is this possible? if so can you help me.

 

Thanks

[WebStyles]

you said it man:

 

ORDER BY id

 

is it not working for some reason?

[kamal213]

Thanks webSyles It works now!!!!!

 

I was doing:

$query_for_result=mysql_query("SELECT * FROM customer ORDER BY id WHERE c_name like '%".$query."%' OR c_telephone like '%".$query."%' OR c_address like '%".$query."%'");

 

Instead of

$query_for_result=mysql_query("SELECT * FROM customer WHERE c_name like '%".$query."%' OR c_telephone like '%".$query."%' OR c_address like '%".$query."%' ORDER BY id ");

 

MY MISTAKE thanks for you help webstyle!! Problem SOLVED!