Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
July 23, 2004, 9:36 pm
rate this thread
number of services offered. You want to be able to search the database for
each service offered separately.
Given the above requirements, is it better to group them in one field and do
a LIKE % query or have each a seprarte database field?
I think separate fields but want opinions as I am somewhat new to this.
Re: design question - several related variables - in one database field or separate fields
if it's a finite number then use seperate fields.
if the possibilities are YES or NO for each service then use binary
fields (1 or 0) - eg. INT(1), CHAR(1) or something like that - this
will speed up searches considerably (as long as you remember to index
all the fields you will be including in your 'WHERE' statement).
- » session var is setting ONLY AFTER I reload page, form var displays first page load
- — Previous thread in » PHP Scripting Forum