accessing the rest of my record set...

[secretsquirrel]

i'm trying to retrieve a column out of a mysql table.

my problem is how to get past the first row of the result set.

at the moment, if i display the results of the function below i get...


Location: London

Location:

but i want it to look like...

Location: London

Location: Paris

----------------------------------------

function getLocations($username)
{
if(!($conn = db_connect()))
return false;

$result = mysql_query("SELECT location FROM myTable"

if(!$result)
return false;

$num_results = mysql_num_rows($result);

$row = mysql_fetch_array($result);

for($count = 0; $count < $num_results; $count++)
{
print &quot;<p>Location: $row[$count]&quot;;
}
}

----------------------------------------

can anyone point out where i'm going wrong, please?

thanks in advance,

ss...

 

[hos2]

   $num_results = mysql_num_rows($result);
    for($count = 0; $count < $num_results; $count++)
    {
    $row = mysql_fetch_array($result);
    $location=$row[&quot;location&quot;];
        print &quot;<p>Location: $location&quot;;
    }
}

 

[secretsquirrel]

thanks hos2,

i knew it would be something simple. i'm new to php and i'm still getting to grips with how to handle arrays.

ss...