[Gllug] mySQL and PHP

[Wulf Forrester-Barker]

Harry <HJackson at colt-telecom.com> wrote:

> The problem I have with trying to normalise the data
> is in the format that I get it. At the moment because this
> tool is just something I am playing with I am not allowed
> access to the production database that holds all the data.
> I have to use the GUI to drop the report out into a .csv
> and then work with that which seems to strip the "\n\r" 
> from the text which is a shame..... I suppose the next step
> is to get select privileges on their database.

Does it display properly in the GUI? If so, you might be able to copy and paste directly to a text file and then massage the contents a bit (or take a reasonable portion of your CSV and massage that into a better format). Maybe the best step is to find out how the original data is stored - at some point, your application will have to take that info, convert it into a format you like and then start asking questions of it.

Wulf




wulf.f-b at uhl.nhs.uk

**********************************************************************
DISCLAIMER:

Any opinions expressed in this email are those of the individual and
not necessarily the Trust. This email and any files transmitted with
it are confidential and intended solely for the use of the individual
or entity to whom they are addressed. Any unauthorised disclosure of
the information contained in this e-mail is strictly prohibited.

The contents of this email may contain software viruses which could
damage your own computer system. Whilst we have taken every
reasonable precaution to minimise this risk, we cannot accept liability
for any damage which you sustain as a result of software viruses.
You should therefore carry out your own virus checks before opening
the attachment.

If you have received this email in error please notify the sender or
postmaster at uhl.nhs.uk. Please then delete this email.

University Hospital Lewisham
Tel: 020 8333 3000
Web: www.uhl.ac.uk
**********************************************************************

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