populating a multi dim array with mysql data

pahikua

K, here is the deal. I am trying to populate a multidimensional array, eventually with data from several queries. I can't give you the full perfected code because I'm still working on patchy code that doesn't work yet. Here is the idea though. This example just assumes we are using one query. The below example is sort of what I tried for multiple queries. I gotta get the two dimension working first.

$result = mysql_query($query);

$num_rows = mysql_num_rows($results);

$row = mysql_fetch_row($results);

$num_fields = sizeof($row);

$final = array();

for ($i = 0; $i < $num_rows; $i++){

 $final[$i] = $i;

 for ($ii = 0; $ii < $num_fields; $ii++){

      $final[$i][$ii] = $row[$ii];

 }

}

Okay that is an idea of what I am trying to do. I want to take to query results and stick the row number in the first dimension of the array. Then I want to take the actual field data and insert it into the second dimension of the array so that I can access the data by row and than fields. I'm just not sure what goes where. To me this also could be a possibility...

for ($i = 0; $i < $num_rows; $i++){

 for ($ii = 0; $ii < $num_fields; $ii++){

      $final[$i][$ii] = $row[$ii];

 }

}

I just don't know. And none of them seem to work. Eventually I plan to have an array of sql queries, not just one query to work with. So I would be adding another dimension as well. One where I could access the data first by which query it was to began with, then the row of that query and than the field of that row.

for ($i = 0; $i < $query_num; $i++){

$final[$i] = $i

 for ($ii = 0; $ii < $num_rows; $ii++){

 $final[$i][$ii] = $ii;

      for ($iii = 0; $iii < $num_fields; $iii++){

           $final[$i][$ii][$iii] = $row[$iii];

      }

    }

}

I hope I'm making some since. There could be an altogether better way to do this. Each query differs so I have to think of a way to do it where I don't have to hard code any field name etc.

Thanks for the help, if you need any more info let me know.

Pahikua

jmcneese

why not just use mysql_fetch_array()?

http://www.php.net/manual/en/function.mysql-fetch-array.php

pahikua

I guess I just couldn't figure out how to use it correctly. I attempted to use it but to no avail. Thanks for the link but that's sort of a frustration to me. For some reason the college I get my network connection from has php.net blocked. I get one of those you can't go here because it's a porn site. Lame eh, drives me nuts. If anyone can provide me an example I would appreciate it.

Pahikua

jowatkins

I have a similar problem. I want to populate an array from a query result. The code to build the array seems to work, but when I try to echo it back to check it I just get ArrayArrayArrayArrayArrayArrayArrayArray etc.

The code is:

$query = "SELECT * FROM trialbasic WHERE chassis='$chassis' AND trial='$trial'";
$result = mysql_query($query);
$records = mysql_num_rows($result);
$units = array();
for ($i=0; $i<$records; $i++)
{
$row=mysql_fetch_array($result);
$units[$i]=$row->unitno;
}

for ($j=0; $j<count($units); $j++)
{
echo "$units[$j]";
}

jmcneese

try this mirror:
http://php.nederland.net/manual/en/function.mysql-fetch-array.php

try this example:

$query = mysql_query("SELECT id,stuff,misc FROM table");

while ($things = mysql_fetch_array($query)) {
    print "$things['id'],$things['stuff'],$things['misc']\n";
}

pahikua

thanks for that mirror site. worked great. I'm gonna work on it and see what I can do.

Pahikua

Weedpacket

Originally posted by pahikua
For some reason the college I get my network connection from has php.net blocked.

Seeing that you can reach phpbuilder, you can use this link instead:

http://www.phpbuilder.com/manual/.

waygood

  $fetch = mysql_query($query);

  while ($row = mysql_fetch_array($fetch))  

  {  

    $result[] = $row;  

  }  

  mysql_free_result($fetch);

you now have an array with the position as the initial index and the database field names as the secondary index

so "SELECT one,two,three from table"
creates multidimensional array where you can :-

for($loop=0;$loop<=sizeof($result);$loop++)
{
   echo $result[$loop]['one'];
}

The single sql statement can be as complicated as you want as long as each field is uniquely named. i.e.

SELECT eve., gen.genre AS theGenre, club.club_night_name AS theClub, thumbs., large.image_name AS large_name, large.image_type AS large_type, large.image_size AS large_size, large.image_width AS large_width, large.image_height AS large_height FROM ffr_genres gen, ffr_club_night club, ffr_events eve LEFT JOIN ffr_images thumbs ON(eve.flyer_thumbnail = thumbs.id) LEFT JOIN ffr_images large ON(large.id = thumbs.large_image_id) WHERE eve.genre_id = gen.id AND eve.club_night_id = club.id AND club.on_events = 1 ORDER BY eve.start_time ASC, eve.id