Hi guys i would appreciate some help here
this is what i want to be able to do
i would like to split my table depending on results shown in row citizenship so that all grouped citizenship seperated into tables instead of showing them in 1 big table
here is my code
[php]
<?php $con=mysqli_connect("localhost","dbuser","password","dbname"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM `data` ORDER BY citizenship ASC"); $num_rows = mysqli_num_rows($result); global $vbulletin; echo "CitizenID | Citizen Name | Citizenship |
---|---|---|
".$row['citid']." | "; echo "" . $row['citname'] . " | "; echo "" . $row['citizenship'] . " | "; echo "