elis Posted September 28, 2006 Share Posted September 28, 2006 Is there anyway to have multiple values in one field, and what would the seperator be?My Mysql table that I'm referencing is:ID - USERNAME - BLOCKEDwhat I need is to be able to store more than one value in the same field on the same row, but be able to call it indvidually. I'm not even sure if this is possiblecurrently this is my php code for the above table:[code]elseif ($userpenname ==''.$cresult[blocked].'') { $output.="<br><center><font color=red>.MESSAGE1.</center></font>";}[/code] Quote Link to comment Share on other sites More sharing options...
acdx Posted September 28, 2006 Share Posted September 28, 2006 You could store a serialize()d php array as a string in the database, but then you would have to do most of the work in PHP anyway. Heck, you could just as well store a pipe-separated string of values in the db and explode the string in php. 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.