query and loop

[Anon]

hi
this query

select name, lcount, ecount, total from tstats WHERE total >= '14' AND type = '2'

when tested in mysql returns what i expect.

my php page script however, returns the first record only and repeats it which is practically useless.

can anyone tell me why, and offer a solution that reurns the correct results

tia if you can

//the code
$qry2="select name, lcount, ecount, total from tstats WHERE total >= '14' AND type = '2' ";
$rst2= mysql_query ($qry2);
$row = mysql_fetch_array ($rst2);
$num_results = mysql_num_rows($rst2);

for ($i=0; $i <$num_results; $i++) {start of loop

echo"<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"375\">

<tr>
<td>
//lots more html and returned variables
</td>
</tr>
</table>";
}// end of loop

[Anon]

I haven't seen any error in your query as far as your database has response to such type of request.

There is a problem with the loop. According to your script, if you get 10 records, the table will be created 10 times since you put it in the loop.

So:
$qry2="select name, lcount, ecount, total from tstats WHERE total >= '14' AND type = '2' ";
$rst2= mysql_query ($qry2);
echo"<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"375\">
while($row=mysql_fetch_object($rst2)){
echo "<tr><td> $row->name </td><td>$row->lcount</td><td>$row->ecount</td><td>$row->total</td></tr>";
}// end of loop

echo "</table>";

[gettingold]

thanks soloman

$qry2="select name, lcount, ecount, total from tstats WHERE total >= '14' AND type = '2' ";
$rst2= mysql_query ($qry2);

while($row=mysql_fetch_array($rst2)){

html etc

}

now works fine