[Gllug] mySQL and PHP

[Jim Cheetham]

Harry, I strongly suggest that the application that's writing each 
successive log entry is trained to use some sort of markup, not to just 
dump stuff in.

If you want an easy hack, just drop <br /> in between entries.
If you want to be more interesting, drop in some simple XML markup and run 
it out through a stylesheet.
In the middle, you could just put some more interesting HTML markup in it.

Although I actually think that each loggable entry should have been in a 
separate table/row, and the full output constructed from a query, rather 
than just being grabbed out of a single field.

At 13:05 10/07/2001 +0100, you wrote:
>Hi
>
>         At the moment we are getting this.
>
>12 March 2001 13:40:32 jtaylor This is something for Group IT. 12 March 2001
>14:02:57 cmelhuish Please email Cath Melhuish for a screen dump of the
>problem. 16 March 2001 10:07:25 bpurba user trying to action "Update CSR &
>Business Data, overdue" task. Error message appears "Because this circuit is
>a revision you cannot update to live" customer order 100073795 Bearer
>circuit E5-000124 is live according to the user. Closer investigation shows
>its virtual therefore a change order was raised for this circuit in order
>for a workplan to be generated & to make E5 live. This will hopefully enable
>the "CSR & Business data" task to be closed. 20 April 2001 14:25:21 bpurba
>contacted GBrughmans, advised ticket can be closed. 01 May 2001 14:36:16
>AR_ESCALATOR Case 000000000033514 was automatically closed on 05/01/01
>14:36:16.
>
>
>
>When it should look like this, the problem that I see here is that there is
>nothing that you can see which would distinguish new lines.
>
>12 March 2001 13:40:32          jtaylor
>This is something for Group IT.
>
>
>12 March 2001 14:02:57          cmelhuish
>Please email Cath Melhuish for a screen dump of the problem.
>
>16 March 2001 10:07:25          bpurba
>user trying to action "Update CSR & Business Data, overdue" task. Error
>message appears "Because this circuit is a revision you cannot update to
>live"
>
>customer order 100073795
>Bearer circuit E5-000124  is live according to the user. Closer
>investigation shows its virtual therefore a change order was raised for this
>circuit in order for a workplan to be generated & to make E5 live.  This
>will hopefully enable the "CSR &  Business data" task to be closed.
>
>20 April 2001 14:25:21          bpurba
>contacted GBrughmans, advised ticket can be closed.
>
>
>01 May 2001 14:36:16            AR_ESCALATOR
>Case 000000000033514 was automatically closed on 05/01/01 14:36:16.
>
> >
>
>
>**********************************************************************
>COLT Telecommunications
>Registered in England No. 2452736
>Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
>Tel. 020 7390 3900
>
>This message is subject to and does not create or vary any contractual
>relationship between COLT Telecommunications, its subsidiaries or
>affiliates ("COLT") and you. Internet communications are not secure
>and therefore COLT does not accept legal responsibility for the
>contents of this message.  Any view or opinions expressed are those of
>the author. The message is intended for the addressee only and its
>contents and any attached files are strictly confidential. If you have
>received it in error, please telephone the number above. Thank you.
>
>
>**********************************************************************
>
>--
>Gllug mailing list  -  Gllug at linux.co.uk
>http://list.ftech.net/mailman/listinfo/gllug

Quick wafting zephyrs vex bold Jim
Jim Cheetham jim at gonzul.org


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug