Split of information in Html

[Rob (SA)]

Hi Folks,

I have an html which is populated from MySql and to theis end I have managed to sort Alphbetically.

The next trick I would like to do is have the from displayed into the tournaments. That is still sort alphabetically but on the same page show the tounaments in seprate frames below each other.

If there is also a method in which to do a count of entries and show that value for each tournament on the same page.

I hope this is not to major an ask for those of you that know how.

My page I refer to is to be found at www.gnjgf.co.za/entryformmysql.php

[gpigate]

I had a hard time understanding what you were really trying to do.

Is it this?

You have 1 table that contains the information on your page. You have another table that contains tournament specific information.

You would like a title row, as you see them now, then with a row under and possibly indented that has the tournament specific information?

Can you paste the code you are using now?

[Rob (SA)]

Hi gpigate,

Thanks for the propmt reply.

I am busy fiddling a bit with it at the moment as you will see but it currently is as follows and better veiwed at www.gnjgf.co.za/testconcat.php

Where the first column uses CONCAT to join the surname ,name

The second column reflects the players handicap

The last column reflects the tounamnet and some info pertaining to the event.

What I would like it to do is first,

Leave the order exactly the same pertaining to the columns but split the table that can be veiwed into tables on the same page grouping them according to tournament.

In this example it should relate to about 6 tounaments.

I hope this helps

[Rob (SA)]

Sorry I forgot a little detail for you,

<!------------------------------------------------------------------->
<!       THIS SECTION FETCHES THE INFORMATION FROM THE TABLE         >
<!------------------------------------------------------------------->
 
<?php
 
while($row=mysql_fetch_array($result)){
 
echo "</tr><td>";
 
echo '<option value="'.$row['surname'].', '.$row['name'].'">'.$row['surname'].', '.$row['name'].'</option>';
 
echo "</td><td>";
 
echo $row['my_handicap_is'];
 
echo "</td><td>";
 
echo $row['i_wish_to_play'];
 
echo "</td></tr>";
 
}
 
echo "</table>";
 
?>

[jolinuer]

Hi Folks,

I have generated a table using information from MySQL and it can be veiwed at my website w w w gnjgf dot co dot za / testconcat dot php

In doing this I would like to split the page seen into the various tournament and in this instance it is 6 but could vary pending the information found in the MySQL table.

At the same time it would be good if the rows with the same tounament information be counted and the total posted in a box on the same page?

Any help in this regard would be most appreciated.

Regards
Rob