[PHP-DB] UPDATE part of a column

Hi, 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 questions: 1. How can I clean the table, so for example changing: Ashfield Business

Re: [PHP-DB] UPDATE part of a column

on 23/9/03 1:03 pm, Shaun at [EMAIL PROTECTED] wrote: 1. How can I clean the table, so for example changing: Ashfield Business CentreBR The Idlewells PrecinctBR Sutton-in-AshfieldBR to: Ashfield Business Centre, The Idlewells Precinct, Sutton-in-Ashfield, 2, Is there a way to make

RE: [PHP-DB] UPDATE part of a column

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 To: [EMAIL PROTECTED] Subject: [PHP-DB] UPDATE

RE: [PHP-DB] Re: UPDATE part of a column

The best way to do this is a text field, NOT a textarea, and if need be, use multiple fields. A textarea, by look and definition is inviting carriage returns to be used. Limit the users to the input you want, and remember, GIGO (garbage in, garbage out) Gary Every Sr. UNIX Administrator Ingram

[PHP-DB] mysql field not resolving comaparison condition for zip code locator

I am having trouble implementing a zip code locator program. All of the functions work correctly but the $sql variable. The problem occurs by using the latitude argument as a comparison. The first latitude argument works but when the second latitude argument is added the query returns no data.

Re: [PHP-DB] mysql field not resolving comaparison condition for zip code locator

On Tue, 23 Sep 2003, AdminHMO wrote: I am having trouble implementing a zip code locator program. All of the functions work correctly but the $sql variable. Try putting the SQL in quotes: $sql = SELECT City FROM ZIPCodes WHERE Latitude = 122.02671343318 AND Latitude = 121.96888656682 AND

Re: [PHP-DB] mysql field not resolving comaparison condition for zip code locator

Thanks for the suggestion but the quotes didn't make a difference I submitted the sql though php myadmin that takes care of the quote syntax Peter Beckman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Tue, 23 Sep 2003, AdminHMO wrote: I am having trouble implementing a zip code

RE: [PHP-DB] mysql field not resolving comaparison condition for zip code locator

I am having trouble implementing a zip code locator program. All of the functions work correctly but the $sql variable. The problem occurs by using the latitude argument as a comparison. The first latitude argument works but when the second latitude argument is added the query returns no

Re: [PHP-DB] mysql field not resolving comaparison condition for zip code locator

Thanks Jennifer, I got the query and the zipcode longitude and latitude from the developer of the zipcode locator. When I contacted them about this issue they had me run this query in the phpMyAdmin against the zipcode date and I still got no data returned. Jennifer Goodie [EMAIL PROTECTED]

Re: [PHP-DB] mysql field not resolving comaparison condition for zip code locator

Jennifer is correct, the query that you have below will never return anything. The last two AND statements exclude each other. You need to change the greater than and less than signs on them and try it again. For now, don t take what the developer is telling you as the gospel, go with what the

[PHP-DB] Cyrillic sorting in MySQL

Hi, I have the MySQL table with cyrillic values. I'm trying to sort this data in query. Rows with english characters are sorted in right way, but cyrillic data is not properly sorted. And how can I solve this problem? May be it's necessary to set the used charset somewhere (and where can I do