php mysql results into an array?

[hargi]

I think this should be simple but cant find the answer.
I have the following which returns some data.

<?php 
$result = mysql_query("SELECT col1, col2 FROM table WHERE col1 LIKE 'something%'");
if (!$result) {
    die("Error");
}

I need to use the output to create a table but I need to modify the data returned before putting this in the table.
i though echo $result['col1']; would print the value of col1 but this didn't work.

What I need to do is a table of results in the following format
|some string + value of col1 | col2/10 |

So how do i get back these values to manipulate

TIA

 

[unwashed potato!]

you'll want to do something like this:

while($displayArray = mysql_fetch_array( $result)) {
echo $displayArray ['col1'];
}

 

[hargi]

Thats the one
Thanks

 

[unknowndomain]

Interestingly unlike PGSQL, MySQL has no way of exporting the contents of a query to a 2d array like.... $array[row][col] , my understanding of PGSQL is that it will do this.

 

[Whitman]

It's easy enough to get data into a 2d array:

$result = mysql_query("SELECT ...");
$data = array();
while ($row = mysql_fetch_assoc($result) {
	$data[] = $row;
}
// $data is now a 2d array containing all of the results

Using the above it's easy to write a wrapper function to do this.