Arrays and Mysqlresults

[iantimmy123]

I'm quite new to PHP and have got stuck with an array with more than one row of data. I have a table with information such as below:

(column names) Username, ID, position.
iantimmy123, 169, 1.
adam123, 235, 2.

I'm stuck with first of all how to retrieve the array, should I still use $row = mysql_fetch_array($result,MYSQL_ASSOC); or should I use a different one (this is the only fetch array I have ever used.

But my main question is how can I refer to each result as a varialble to make the entry appear somewhere in a page. For instance, on a particular area on a page I want to echo the username (adam123) where the position=2. Really stuck would appreciate help. Thanks

[leatherback]

Hi Timmy,

you can quite easily do this. I am a bit confused as to why you use position, and not ID as a determinant to decide which to use, but I am sure you can work this out once you get the basics:

// a basic query
$query = "select * from table";
$result = mysql_query($query);
$data = array();
if($result)
  {
  while($row = mysql_fetch_array($result))
    { // Set each element in the array, as an array with all the required data from the database.
    $data[$row['position']] = array(
    "username"=>$row['Username'],
    "ID"=>$row['ID']);
    }

// Just for error spotting:
print_r($data);

// spit it out at $currentposition
echo $data[$current_position]['username'];