Trying to get values in an array but ...

TomatoLover

I have 13 tables that are linked with the field called "AppId".

There are more than 40 fields that I want to retrieve from these tables at once.
I have no problem retrieving necessary data, but here is the problem.

$query = "SELECT * FROM table1, table2, ....WHERE table1.AppId = table2.AppId AND .....";
$result = mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);

After this, I want to display the value of the $row.
Usually, I do

echo $row[0]

echo $row['fieldname']

But there are over 40 fields retrieved and I want to display in certain order that I specify. (not the array order)
Therefore, it doesn't make sense to use number to specify which array members to be displayed.

But also, if I use fieldname, it doesn't work since I need to use qualifier.
I tried

$row['fieldname']

and

$row['tablename.fieldname']

But neither worked.

Does anybody know how to display array members, which belong to multiple tables?

steadyguy

Have you tried using extract()??

TomatoLover

No, I have never tried it before.
Actually, I didn't know how to use it. So, I looked up PHP mannual but still not clear... I'm not sure how I can use it for my purpose. I guess I just have to play around and see what works.

Thanks, anyway.

superwormy

Use print_r ($row) to print the resulting row and see what the array keys are set to. Sometimes the MySQL function sets the resulting keys to wierd names, it never comes out to tablename.fieldname because you can't have . in array keys.

TomatoLover

I've tried print_r($row) already, and it displayed all fields.
Because the number of fields are quite large number, I thought there was a better way to do it. I guess I have to use element number according to the result of print_r.

steadyguy

extract() is easy to use ... just supply an associative array as an argument, and it will create variables named after each of the keys in the array. For example:

$sampleArray = array('nickname=> 'steadyguy', 'location'=>'Brazil');
extract($sampleArray);

Now I have local variables $nickname and $location, whose values are set to steadyguy and Brazil respectively. Make sense?