Can anyone help? I have a mysql table with the following information:
Quote:
ID Name Chapter Description
1 uniqueName1 Ch1 Name uniqueDescription1
2 uniqueName2 Ch1 Name uniqueDescription2
3 uniqueName3 Ch1 Name uniqueDescription3
4 uniqueName4 Ch2 Name uniqueDescription4
5 uniqueName5 Ch2 Name uniqueDescription5
6 uniqueName6 Ch3 Name uniqueDescription6
7 uniqueName7 Ch3 Name uniqueDescription7
|
I have some php loop code which echos the rows in the following format:
Quote:
1 - uniqueName1 - uniqueDescription1
2 - uniqueName2 - uniqueDescription2
3 - uniqueName3 - uniqueDescription3
4 - uniqueName4 - uniqueDescription4
5 - uniqueName5 - uniqueDescription5
6 - uniqueName6 - uniqueDescription6
7 - uniqueName7 - uniqueDescription7
|
What I would like to do is to get the Chapter Name above the lines with the same chapter. But not above every line. See below:
Quote:
Ch1 Name
1 - uniqueName1 - uniqueDescription1
2 - uniqueName2 - uniqueDescription2
3 - uniqueName3 - uniqueDescription3
Ch2 Name
4 - uniqueName4 - uniqueDescription4
5 - uniqueName5 - uniqueDescription5
Ch3 Name
6 - uniqueName6 - uniqueDescription6
7 - uniqueName7 - uniqueDescription7
|
Do you know how I could edit my loop below:
Quote:
$query = "SELECT * FROM tbl order by ID ASC";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
echo "<br />";
echo $row['id'];
echo " - ";
echo $row['Name'];
echo " - ";
echo $row['Description'];
echo "<br />";
}
|
31-08-2009, 10:56:04 PM
Similar Threads 
Linear Mode
