amarkabove Posted April 9, 2010 Share Posted April 9, 2010 here is what i am trying to do and i want to know if it is possible or i should try something different. i have site that businesses can register for territories by postal code. they can have as many codes as they would like. those codes are stored in one field separated by commas. now when a customer registers they put in their code. when a business comes to their own password protected page i need to check through the businesses codes 1 by 1 compare them to the customers code in a different table and then display the customers info when the codes match up. i am using php and MySql 5 Link to comment https://forums.phpfreaks.com/topic/198134-sort-through-concat-fields/ Share on other sites More sharing options...
fenway Posted April 9, 2010 Share Posted April 9, 2010 Don't store comma-separate values. Link to comment https://forums.phpfreaks.com/topic/198134-sort-through-concat-fields/#findComment-1039594 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.