Fill an array from a mysql query

[johnhb]

I have the following code:

$query=mysql_query('SELECT pay, name FROM paychart, users

WHERE paychart.payee = users.id') or die();

which I want to put into an array so that I can 1) eliminate duplicate values of pay and then 2) find the lowest value of pay and have the payee's name to match that pay.

 

I have tried this:

while ($array = mysql_fetch_array($query, MYSQL_NUM))

{

  $data[] =$array[0];

  $data1[] =$array[1];

}

 

But I want the pay and name to be in the same array.

 

Hope someone can help me?

[Barand]

while ($array = mysql_fetch_row($query))

{

  $data[] =$array;

}

[johnhb]

Thank you very much - it's so simple when you know how.