arrays from database

i have a database call pulling 2 fields,
ID and Total, and a total of 3 rows :-

ID TOTAL
1 45
2 32
3 42

How can i write the results into an array that i can use in my php scripts ?

i have been creating a loop with appends to the last record so i have a string like :-

$string = "1 >= 45, 2 >= 32, 3 >=45";

but i cannot get this to be seen as an array
if i call any info from the error ie sizeof or maxval i just get ARRAY

any ideas ???

kane,

You're going to have to append the last record to an array, not a string, in order for it to be seen as, well, an array. Like so:

$array[] = $row["ID"] => $row["TOTAL"];

thanks works fine with the follwoing :-

$array[] = $row["TOTAL"];

if i try adding the ID as the index i get invalid function

how can i set up this or use the separator => ????

thanks

Oops,

Sorry about that, my code was wrong .. what you want is this:

$array[$row["ID"]] = $row["TOTAL"];