PHP Arrays

[Moody Dude]

Hi,  I am pulling in 3 sets of data from a mysql database and echoing to the screen (the data is to be used to plot a graph); what I need to know is how do I store each set of values in 3 separate arrays for use later in the program. The current code is shown below. Thanks in advance MD

 

$query=mysql_query("SELECT * FROM report WHERE report.reportid=$value");

while ($row=mysql_fetch_array($query))

{

  for($x=1; $x<11; $x++)

{

echo $row[$x];

                        }

}

[Muddy_Funster]

$row[] is an array.... and why are you running a loop within a loop

[fugix]

mysql_fetch_array() is already placing your column values into an array, to draw a val out all you need to do is echo $row['column_name']

[Adam]

You can use a multi-dimensional array to keep them altogether, while in separate arrays:

 

$data = array();

while ($row=mysql_fetch_array($query))
{
    $data[] = $row;
}

 

The only small problem with this, is that you're using mysql_fetch_array, which returns the data indexed by both column name and number -- so your array would be twice the size it needs to be. To prevent this you should use either mysql_fetch_row (for numeric array) or mysql_fetch_assoc (for associative array).

[Moody Dude]

Hi

 

Thanks for the replies. The first loop was to select the correct rows within the table and the second loop was to echo the values of each field of the selected rows to the screen. Not sure if this is programmatically correct or not but as a novice it seemed logical!!

 

Will try and solve this over the weekend and report back.

 

Thanks again, MD