heeeelppp!! repeating rows

seanpaulcail

I know this should be easy to figure out but I can't do it alone.

I have the following query:

$query = "SELECT * FROM 30yrFixedConforming";

$result=mysql_query($query);

$row = mysql_fetch_array ($result);

for ($m=0; $m<4; $m++)
{
for ($i=0; $i<4; $i++)
{
echo htmlspecialchars (stripslashes($row[$i]));
echo "&nbsp; &nbsp; &nbsp; &nbsp;";
}
echo "<br>";
$i++;
}

?>/PHP] 


Which gives me repeating rows.
PHP]5.875%       $887       2.375       $3,562       

5.875%       $887       2.375       $3,562       

5.875%       $887       2.375       $3,562       

5.875%       $887       2.375       $3,562

I can see my error, but I can't figure out how to fix it. How do I make the code choose the second, then third, then fourth row?

Thanks

ultraslacker

Remove the outer FOR loop.

seanpaulcail

I originally had it without the outer for loop.

But that only gives me one row.

I need code to display a table of four rows and 5 columns.

Can you help?

Thanks

ultraslacker

Read over the mysql-fetch-array page to see your errors.

seanpaulcail

here's the solution:

mysql_select_db("a0022423");



$result = mysql_query("SELECT rate, payment, Points, Amount, APR FROM 30yrFixedConforming");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf ("Rate: %s  Payment: %s Points: %s Amount: %s APR: %s", $row[0], $row[1], $row[2], $row[3], $row[4] );  
}

mysql_free_result($result);
?>