Davidqwas Posted September 17, 2008 Share Posted September 17, 2008 I have a php project that includes MySql. And one part of it lists everything that's in a database ina certain order, How would I limit this so that it only shows the things that start with a certain letter? Like It has a couple fields, ID, then information, how would I make it so that it only shows the information for the tables who's ID name starts with a certain letter? Link to comment https://forums.phpfreaks.com/topic/124721-phpmysql/ Share on other sites More sharing options...
BlueSkyIS Posted September 17, 2008 Share Posted September 17, 2008 can you show us the code you have so far, just connecting to mysql and selecting the data? Link to comment https://forums.phpfreaks.com/topic/124721-phpmysql/#findComment-644251 Share on other sites More sharing options...
elgoog Posted September 17, 2008 Share Posted September 17, 2008 Example The following clause would return all rows starting with letter M for the field IDname WHERE IDname LIKE 'M%' Link to comment https://forums.phpfreaks.com/topic/124721-phpmysql/#findComment-644255 Share on other sites More sharing options...
Davidqwas Posted September 17, 2008 Author Share Posted September 17, 2008 It's pretty complicated, it gets all the information and posts it in tables. I just need to know how to code it, if anyone really wants to help you can add me @ [email protected] I'd really appreciate it. Link to comment https://forums.phpfreaks.com/topic/124721-phpmysql/#findComment-644262 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.