Re: Convert String to Array

At 12:22 AM 9/30/2005, Ng Hwee Hwee wrote:

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

Look to your data - why are you storing an array element name matched with a vehicle line? The T100Value appears to be the key field, retrieve it and build your array within your script. Think hard about why we have relational databases -- you are tying a value to a position with this structure. If ever something has to be inserted in the middle everything that follows will be broken, or you will be driven into v. peculiar constructs to solve a problem which could have been avoided up front. On the other hand, I know nothing about your data or your application, o maybe I'm blowing smoke. Regards - Miles Thompson