bossman Posted July 9, 2010 Share Posted July 9, 2010 hello all, haven't been in here in a while, took a break from developing but now im back at it and a bit rusty :/ i'm trying to write a query so that when a user clicks a link that says "A" , it will grab all the names in the database that start with an "A". I wanna do the same thing with the whole alphabet. Anyone have any suggestions on a query? something like "Select id, name, contact_name, street_address, city, state, zipcode, country, phone_number, email, website FROM hair_loss_clients ORDER BY name ASC ----- ??? " what would go at the end there to make it select only titles that start with "A"? THANK YOU IN ADVANCE! Link to comment https://forums.phpfreaks.com/topic/207279-simple-question-and-solution-about-a-query-string/ Share on other sites More sharing options...
Alex Posted July 9, 2010 Share Posted July 9, 2010 Select id, name, contact_name, street_address, city, state, zipcode, country, phone_number, email, website FROM hair_loss_clients WHERE name LIKE 'A%' ORDER BY name ASC Link to comment https://forums.phpfreaks.com/topic/207279-simple-question-and-solution-about-a-query-string/#findComment-1083766 Share on other sites More sharing options...
bossman Posted July 9, 2010 Author Share Posted July 9, 2010 thank you very much!!!! that helped alot! Link to comment https://forums.phpfreaks.com/topic/207279-simple-question-and-solution-about-a-query-string/#findComment-1083828 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.