Re: Only showing 20 lines per page...

Thanks Rik. Thats been a big help.

So in my example I could just do this..

$conn = //db connection stuff
$sql = "select VALUES from TABLE LIMIT X,X";
$sql1 = "mysql_query($sql,$conn) or die(mysql_error());

while ($results = mysql_fetch_array($sql1)) {
echo $results['value1'];
echo $results['value2'];
}

...and if the LIMIT was set to 0,20 I would see 20 sets of both value1
and value2.

Many Thanks

Mike

.

Relevant Pages