Hi,
I'm trying to display the first 5 results, with the following code, but its only giving me the first.
$startRow = 1;
$endRow = 5;
$type = trim($entryType);
$query = mysql_query("SELECT * FROM $table WHERE type = '$type' ORDER BY date DESC LIMIT $startRow,$endRow");
$query2 = mysql_num_rows($query);
if($query2<=0)
{
return "&error=" . mysql_error();
} else {
while ($row = mysql_fetch_array($query)){
echo "&Field1=".$row[0];
echo "&Field2=".$row[1];
echo "&Field3=".$row[2];
echo "&Field4=".$row[3];
echo "&Field5=".$row[4];
echo "&Field6=".$row[5];
echo "&Field7=".$row[6];
echo "&Field8=".$row[7];
echo "&Field9=".$row[8];
echo "&Field10=".$row[9];
}
