Retrieving rows from mysql database

[Anon]

I have encountered a problem when retrieving rows from mysql database using loops but OK for typing many rows

Successful case:
<? while ($row=mysql_fetch_array($result)){ ?>
<tr>
<td><? echo $row[mysql_field_name($result,0)] ;?></td>
<!td><!? echo $row[mysql_field_name($result,1)] ;?><!/td>
<!td><!? echo $row[mysql_field_name($result,2)] ;?><!/td>
<!td><!? echo $row[mysql_field_name($result,3)] ;?><!/td>
<!td><!? echo $row[mysql_field_name($result,4)] ;?><!/td>

</tr>
<? } ?>
</table>

Fail case:
$j=0;

<? while ($row=mysql_fetch_array($result)){ ?>
<tr>
<td><? echo $row[mysql_field_name($result,$j)] ;?></td>
<? $j++; >
</tr>
<? } ?>
</table>

So would anyone tell me how can I use loops to retrieve rows.Thx

[Anon]

Well, think about it. If you only have 4 elements then you need a loop that has 4 iterations.

Your above code starts j off at 0 but after 15 fetches j is 15 and way out of bounds. It also only prints one feild per fetch which is different each time.

So nest another loop inside your while fetch loop.

[Anon]

I had problems using a fetch_array and a fiels_name function on the same result.
They don't seem to want to play nice.

Oh well.

Try this:

while ($row=mysql_fetch_array($result))
{
foreach($row AS $var)
{
$table .='
<tr>
<td>'.$var.'</td>
</tr>';
}
}

[Anon]

Man,

Your code looks more complicated than it should....

Let's say you have a table <b>Book</b> that has four columns
1. title
2. description
3. price
4. rating

you do query

$sql="select * from Book";
$result=mysql_query($sql, $conn); //$conn=connection to mysql
echo "<table>";
while($res=mysql_fetch_array($result))
{
echo "<tr><td>$res["title"]</td><td>$res["description"]</td><td>$res["price"]
<td>$res["rating"]</td></tr>";
}
echo "</table>";

function mysql_fetch_array() retrieves one element at a time and assigns them to variable $res, which is an array, that has indexes of the elements that are name of the columns in the database.

Hope that helps,

Di