newbie data looping

[stvchez]

I'm trying to loop data results and alittle stuck.


    $query = "SELECT * FROM  aeWorkoutRuns where username='$username'";
    $result = mysql_query($query, $link);
// get number of rows
$num=mysql_numrows($result);

// set variables
$run_title=mysql_result($result,$i,"run_title");
$route_url=mysql_result($result,$i,"route_url");

// Write the Name and Age inserted into Mysql Database
echo "<table width=400><tr><td>Run Title</td><td>Route URL</td></tr>";
$i=0;
while ($i < $num) {
echo "<tr><td>";
echo "$run_title </td><td>";
echo "$route_url </td></tr>";

$i++;
}

echo "</table>";
?>


///////////////

this is what I get:

Run Title Route URL
Los Altos Loop #5 gmap.loop.number5
Los Altos Loop #5 gmap.loop.number5


These should be unique.  thanks.

[Tandem]

You need to set the variables inside the loop.

[paul2463]

[code]
<?php
$num=mysql_num_rows($result); //this will get a better answer for number of rows than yours
?>
[/code]

[stvchez]

re: putting the variable inside the loop, isn't this correct:

while ($i < $num) {
echo "<tr><td>";
echo "$run_title </td><td>";
echo "$route_url </td></tr>";

$i++;
}


if not, would it be possible to post an example.  thx

[paul2463]

[code]
<?php
while ($i < $num) {
$run_title=mysql_result($result,$i,"run_title");
$route_url=mysql_result($result,$i,"route_url");
echo "<tr><td>";
echo "$run_title </td><td>";
echo "$route_url </td></tr>";
$i++;
}
?>
[/code]