PROS! Grouping data...easy?

[brianb]

Hello pros,

I think I have an easily explainable situation.

Basically, I have tons of records inside of my MySQL database, inside of one table.

Now, some enteries have the same TITLE as other enteries, but within the data is different...even though the title is the same.

Now, on my page, I am calling the data. But I get a result for each entry in the database...

What looking to do is for the TITLES that are exactly the same, print out the TITLE once then list the data underneath for each entry.

Then...move onto the next TITLE etc etc.

Make sense?

Any code example are appreciated.

[viper21634]

What you are looking to do is called cell merging, very easy to do in VB6, I will have to look into PHP to see what you can do, I will post back when I know more.

[brianb]

Thanks. Any ideas are appreciated.

Thanks.

[IWS]

Simple-

$title='';
$res=mysql_query('SELECT * FROM table ORDER BY title',$db);
while ($row=mysql_fetch_row($res)) {
if ($row[TITLE]!=$title) {
echo $row[TITLE]."<br>";
$title=$row[TITLE];
}
echo $row[AUTHOR].' '.$row[SUBJECT].' '.$row[NUMPAGES];
}

TITLE, AUTHOR, SUBJECT, NUMPAGES need to be replaced with column offsets, or put a line at the top that looks like this:

define('TITLE',0);