Is it possible for you to store the vehMdlCd array as a serialized field in your database? I'm not sure how your data is structured, but you would serialize() your data on the way into the db then unserialize() it when you select it. When it's unserialized, you'll get it back in the original array format and you can do with it whatever you please. Chek out serialize() and unserialize() in the PHP docs and see if that will work for you. Rich -----Original Message----- From: Ng Hwee Hwee [mailto:hhwee@xxxxxxxxxxx] Sent: Thursday, September 29, 2005 11:23 PM To: PHP DB List Subject: Convert String to Array Hi guys, this looks like a very simple problem but i really have no idea how to do it.. please help me! thanks! my MySQL database has a table of which 2 fields are as follow T100FieldNm T100Value ========== ========= vehMdlCd[0] MER vehMdlCd[1] LEX vehMdlCd[2] TOY and I need to echo out the value for $vehMdlCd[0]...[2]. but when I retrieve T100FieldNm from the database, PHP recognises it only as a string. Thus, in order to get the value of $vehMdlCd[0], I need to do the following. for($i=0; $i<$numOfRows; $i++) { $tmpVehMdlCd = "vehMdlCd[$i]"; $vehMdlCd[$i] = $$tmpVehMdlCd; } where $numOfRows has been calculated by doing a count of all T100FieldNm like "vehMdlCd%". Can someone enlighten me with a simpler way?! Potentially I can have a 100 over different T100FieldNm! =( I tried using settype and type-casting but still don't get the respective T100Value! *sob* Thanks sooo much! Best regards, Hwee Hwee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
