I have 5 pictures stored in a folder and their links stored on the database.
I want to put them in a table of three columns on each row.
[code=php]
<body>
<center>
<table border=’1′>
<?php
$host=””;
$username=””;
$password=””;
$db_name=”fruits_db”;
$tbl_name=”fruits_tbl”;
$connection=mysqli_connect(“$host”,”$username”,”$password”,”$db_name”);
if (mysqli_connect_errno())
{
echo “The application has failed to connect to the mysql database server: ” .mysqli_connect_error();
}
$result = mysqli_query($connection, “SELECT * FROM fruits_tbl”)or die(“Error: ” . mysqli_error($connection));
$num_rows=mysqli_num_rows($result);
$rows = $num_rows/3;
for($i=1; $i<=$rows ; $i++)
{
echo “<tr>”;
for($j=1; $j<=3; $j++)
{
while($row = mysqli_fetch_array($result))
{
echo
(
“<td width=’180px’ height=’200px’>”
.”<div class = ‘fruit_image’>”
.”<img src='”
.$row[‘fruit_image’]
.”‘/>”
.”</div>”
.”<div class = ‘fruit_title’>”
.$row[‘fruit_name’]
.”</div>”
.”</td>”
);
}
}
echo “</tr>”;
}
mysqli_close($connection);
?>
</table>
</center>
</body>
The above code I created, contains two FOR loops. The script should count the number of rows in the table, and then divide by 3(the number of columns on each row in the HTML table).
I wonder where I’m going wrong with this code.?