As a separate issue, I would consider seperating the address field into
it's individual parts
Street,area,city etc.. All different fields

-----Original Message-----
From: Shaun [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 23, 2003 2:03 PM
Subject: [PHP-DB] UPDATE part of a column


I have a column in my table called address. When users add an address
with a textarea they sometimes press return for a new line and this
seems to be putting line breaks into the database, so I have 2

1. How can I clean the table, so for example changing:
    Ashfield Business Centre<BR> The Idlewells Precinct<BR>
    Ashfield Business Centre, The Idlewells Precinct,

2, Is there a way to make sure the data is 'clean' before entering into
the table?

Thanks for your help

PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to