|
|
Posted by elyob on 09/20/05 20:40
Hi,
I'm looking at storing snippets of details in MySQL about what credit cards
a business excepts. Rather than have a whole column for Visa, another for
Amex etc ... I am looking at having a column called payment types and
inserting multiple codes ... e.g. ViAmBcCa
Is this a good way of doing things? To me it'd be a lot cleaner and limit
amount of Db work to be done. Is this a sensible way in your opinion? What's
the best way of getting the info back out via PHP? Put in a delimiter e.g.
Vi-Am-Bc-Ca- or keep codes to two digits and split by that length?
Suggestions appreciated!
Nick
Navigation:
[Reply to this message]
|