mysql_fetch_array with multidimensional arrays

[james6848]

I'm familiar with using 'while' to extract data from a MySQL derived array using a $row[] variable, but if I want to extract from a multidimensional array do I just use the construction $row[0][1] (for example)?

Thanks.

 

[DRJ478]

To quote sleipnir214: Not enough information for a menaingful answer.

General suggestion:
Look at the foreach() construct. It iterates arrays.

http://www.php.net/foreach

 

[james6848]

OK! Sorry.
I want to put my CV on the 'net. For each previous job I need a single array, something like this:

Job1 (task1 => details, task2 =>details, task3 => details)
Job2 (task1 => details, task2 =>details, task3 => details)
etc...

Then I want this to exist in a multdimensional array called 'experience':

Experience (0 => Job1, 1=> Job2, etc...)

My two problems are:
1-Getting this info into a multidimensional array from a MySQL database. Can I construct this with the mysql_query() function, assuming there is a separate table for each job?
2-Echoing each element of the md array on the page. Can the mysql_fetch_array() function deal with multidimensional arrays?

Hope that's a bit clearer.

 

[predamarcel]

you have to do like:

$res = mysql_query($selec_str);
$experience = array();
while ($row = mysql_fetch_array($res))
{
    array_push($experience, $row);
};

//look at $experience;

___

http://marcel.4x4.ro/

____

 

[james6848]

OK, thanks. I'll give it a go.

Cheers.