Results 1 to 2 of 2
Apr 23, 2005, 06:16 #1
- Join Date
- Aug 2003
- United Kingdom
- 0 Post(s)
- 0 Thread(s)
How do I echo only results beginning with a certain letter?
My php script is performing this query:
$query = "SELECT * FROM Race_Details WHERE Race_ID LIKE '%".$searchrace."%'";
What I would like to do is then echo results back where the column Points_ID begins with a certain letter. I have five points groupings, those beginning with Q, R, C, E and T. So, how do I filter the query results using php to only echo back records where the Points_ID begins with Q for example?
(Also, I would love to then also know how to sort these results by Points_ID - is it as simple as adding ORDER BY Points_ID to the query?)