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 Quote Link to comment Share on other sites More sharing options...
fenway Posted April 9, 2010 Share Posted April 9, 2010 Don't store comma-separate values. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.