Posted by Margaret on 07/09/05 15:00

I am sorry if this is OT and please tell me to go away if it is.

I have a PHP script written by my Nephew (now in the USA working in a
summer camp so unavailable) which gets information from a database. I
can add all the stuff I need to the database and in the "longtext" field
can add html tags and so on and all works fine. But when I try to get a
table into it I works OK but a heap of <br> are added in before the
table shows meaning that I have to scroll right down the page to be able
to see anything.

I've pasted the table into the database at the bottom of the page it
should be in.

http://www.hampsteadparishchurch.org.uk/
to see the whole effect please click on "Parish Magazine", July - Summer
Fair. and scroll down.

I can't see what might be putting all the <br>'s in - it doesn't do it
on anything except tables.

Below my sig is what I pasted in and you can see that it works (I know
it needs tidying!!)

Any help gratefully received.
Margaret

remove giggling if replying by email

<table>
<table width="37%" cellpadding="6" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td class="table1column1" width="38%" valign="top"><p>Bakery </p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;839.20</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Books</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;391.19</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Children's corner</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;142.69</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Donations</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound; 71.60</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Drinks</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;400.97</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Egg cups</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&#160;&pound;
30.10</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Entrance</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;510.10</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Fabrics</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound; 45.34</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Games</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;34.20</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Gifts</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;317.77</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Granny's Attic</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;259.01</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Ice Cream</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound; 30.90</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Children's Clothes</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;102.50</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Holiday Bargains</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;200.18</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Men's Clothes</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;79.11</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Tip Top Shop</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;272.90</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Clothes</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;654.69</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Lucky Dip</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound; 18.59</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Lunches</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;560.050</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Raffle</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;1,936.40</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Tombola</p>
</td>
<td class="table1column2" width="62%"
valign="top"><p>&pound;454.40<span>&#160;</span></p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>White Elephant</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&pound;1,037.71</p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>Total</p>
</td>
<td width="62%" valign="top" bgcolor="#FFFFFF"
class="table1column2"><p><span style="font-weight:
bold">&pound;7,735.36</span></p>
</td>
</tr>
<tr>
<td class="table1column1" width="38%" valign="top"><p>&#160;</p>
</td>
<td class="table1column2" width="62%" valign="top"><p>&#160;</p>
</td>
</tr>
</table>

• Next in forum: Re: Table in MySql database
• Prev in forum: Anonymous connecting via PHP to a LDAP server
• Thread view: Table in MySql database

[Reply to this message]