Table formatting
Solved/Closed
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
-
Sep 30, 2021 at 07:50 AM
HelpiOS Posts 14444 Registration date Friday October 30, 2015 Status Moderator Last seen October 3, 2024 - Sep 30, 2021 at 11:00 AM
HelpiOS Posts 14444 Registration date Friday October 30, 2015 Status Moderator Last seen October 3, 2024 - Sep 30, 2021 at 11:00 AM
Related:
- Table formatting
- School time table software free download full version - Download - Organisation and teamwork
- Html table fit to screen - Guide
- How to delete a row in a table in word - Guide
- Ascii table c++ - Guide
- How to clear formatting in excel - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Updated on Sep 30, 2021 at 08:38 AM
Updated on Sep 30, 2021 at 08:38 AM
Wow - that was easy ... just changed the code a tiny bit to ...
I hope this helps someone else :^)
<?php
$result = mysqli_query($conn, "SELECT * FROM holiday_admin_bank_holiday
WHERE year=2021");
while($row = mysqli_fetch_array($result)) {
echo "<table id='open'>";
echo "<tr class='header'>";
echo "<th>Year</td>";
echo "<th>New Year</td>";
echo "<th>Easter</td></tr>";
echo "<td>".$row['year']."</td>";
echo "<td>".$row['new_year']."</td>";
echo "<td>".$row['easter']."</td></tr>";
echo "<th>Good Friday</td>";
echo "<th>May Day</td>";
echo "<th>Whitsun</td></tr>";
echo "<td>".$row['good_friday']."</td>";
echo "<td>".$row['may_day']."</td>";
echo "<td>".$row['whitsun']."</td></tr>";
echo "<th>August</td>";
echo "<th>Christmas</td>";
echo "<th>Boxing Day</td></tr>";
echo "<td>".$row['august']."</td>";
echo "<td>".$row['christmas_day']."</td>";
echo "<td>".$row['boxing_day']."</td>";
}
?>
I hope this helps someone else :^)
Sep 30, 2021 at 11:00 AM