Help! mysql_fetch_array

tomaskornegay

Hi Guy - this one is buring me up.

I have a webpage which runs repetitive queries agaist a database in order to extract one item at a time and then put the items in an HTML table. The reason for this is formatting, plus the page hits 4 databases.

Instead of running multiple queries pulling one item at a time...is there a way to pull out all the data, store it in an array, and then pull individual items from the array with php as I want to insert them in the table? So, example is...

table contents:

America 150
Europe 250
Japan 350

I need to display this data in a very different format than the above. Let say it needs to look like this:

America %Change Europe %Change Japan %Change
150 250 350

So, I end up running 3 queries (using "where country = [name]"). I want to run one query...pull everything...store it in an array...and then pull the items individually. So, if I want America numbers, I just want to reference the array item like

$array[0][0] (to pull value "150").

however, when I try to do this, I get really strange answers. I think mysql_fetch_array stores each character as an array item instead of the whole word?

So the above code returns "A" or "1" or something strange.

THANKS!!!!!

devinemke

just guessing here at your field names:

$result = mysql_query('SELECT * FROM countries') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$countries[$row['name']] = $row['change'];}

foreach ($countries as $key => $value)
{
	echo $key . ' = ' . $value . '<br>';
}