Jump to content

RE: SQL Sort/Order Search results


kamal213

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/248967-re-sql-sortorder-search-results/
Share on other sites

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!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.