Storing series of related strings.
Posted 06 April 2006 - 05:18 PM
If I knew there would be only one IP address, the situation would be simple; each row would contain a member's screenname, their miscellaneous information, and their IP address all bundled together nice and simple like. But since each member may need to store many IP addresses, I need something a bit more flexible.
MySQL doesn't seem to have any kind of array data type. The closest thing I could find was LONGTEXT, which I could then use to produce a series of IP addresses in CSV format, which I in turn could use a PHP function like explode() to break into an array to work with. It seems like there should be a better way to handle it though.
Any suggestions or information would be appreciated. Thanks in advance.
Posted 06 April 2006 - 05:34 PM
Posted 06 April 2006 - 05:40 PM
Posted 06 April 2006 - 09:30 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users