Create break in html table

[Rob (SA)]

Re: Create break in html table

Hi George,

Looking much better thank you.

Page is www.gnjgf.co.za/testconcat.php

It looks good except the > shows in places - dont know why but will try and try

[navaldesign]

Re: Create break in html table

Page is www.gnjgf.co.za/testconcat.php

It looks good except the > shows in places

Not sure what you mean, where does it show ??

[Rob (SA)]

Re: Create break in html table

hi George,

I have sorted it out

The headings were having a > at the begining of each title and I think it was because of this

$quey1="select * from _Form_Nr_3 ORDER BY `i_wish_to_play` ASC, `surname` ASC ";
$result=mysql_query($quey1) or die(mysql_error());
?>
<!------------------------------------------------------------------->
<! THIS SECTION CHANGES WHAT THE TABLE LOOKS LIKE >
<!------------------------------------------------------------------->
<table border=3 width="85%" style="font-size:11px" cellspacing=0>
<!------------------------------------------------------------------->
<! THIS SECTION CHANGES THE MAIN HEADING >
<!------------------------------------------------------------------->
<caption><b><font style="font-size:16px" color="#00008B" face="Arial">
TOURNAMENT ENTRIES</font><b><caption>
<!------------------------------------------------------------------->
<!------------------------------------------------------------------->
<! THIS SECTION FETCHES THE INFORMATION FROM THE TABLE >
<!------------------------------------------------------------------->
<?php
while($row=mysql_fetch_array($result)){
//----------------------------------------------------------------------------------------------------
// THIS SECTION ADDS 3 EMPTY LINES IF THERE IS A SPLIT BUT ONLY AFTER SOME RECORDS HAVE BEEN DISPLAYED
//----------------------------------------------------------------------------------------------------
if($i > 0 AND $row['i_wish_to_play'] != $last_wish_to_play){
echo '<tr>
<td colspan="3">&nbsp;</td>
</tr>';
}
//----------------------------------------------------------------------------------------------------
// THIS SECTION ADDS HEADINGS
//----------------------------------------------------------------------------------------------------
if ($row['i_wish_to_play'] != $last_wish_to_play) {
echo '<tr>
<td align="center" bgcolor="#FFFFFF">><font style="font-size:11px" color="#00008B" face="Arial"><b>FULL NAME</b></font></td>
<td align="center" bgcolor="#FFFFFF">><font style="font-size:11px" color="#00008B" face="Arial"><b>HANDICAP</b></font></td>
<td align="center" bgcolor="#FFFFFF">><font style="font-size:11px" color="#00008B" face="Arial"><b>'.$row['i_wish_to_play'].'</b></font></td>
</tr>';


Shown in red above - so I deleted it and it seems to have had the desired effect.

[navaldesign]

Re: Create break in html table

Yes, my mistake

[Rob (SA)]

Re: Create break in html table

hi George,

No problem at all.

I am only glad that I am learning and getting to see how to fix things a little by little with your guidance.

You will see I am playing a bit now to get the tournament to be as it is at the top and then the headings - name, handicap etc just below that.

It seems I have to play a bit with the order of things to get this to happen by manipulation of the <tr> command.

I am glad we have got it to where we are because it helps me to relaise how powerful the datbase manipulation can be in achieving the lower administration requirements we need on this website.

your support is truly appreciated