Date: Mon, 21 Feb 2005 16:14:05 +0000 To: mysql@lists.mysql.com mysql@lists.mysql.com mysql@lists.mysql.com From: Peter O'Brien mysql@surreyfilms.co.uk Subject: Postcode Proximity Search? Message-Id: c429bcca97d9448795dc0ff9a62ae801@surreyfi

2005-02-21 Thread Brandon Carter
Date: Mon, 21 Feb 2005 16:14:05 + To: mysql@lists.mysql.com mysql@lists.mysql.com mysql@lists.mysql.com From: Peter O'Brien [EMAIL PROTECTED] Subject: Postcode Proximity Search? Message-Id: [EMAIL PROTECTED] Hi I'm just starting out with PHP and MySQL My database has a postcode column and I

Postcode Proximity Search

2005-02-21 Thread Brandon Carter
I wrote to the list explaining about the Great Circle formula for doing the desired calculations. I also stated that places.zip was the file to be used for these calculations--I misspoke. The correct file is http://www.census.gov/tiger/tms/gazetteer/zcta5.zip;. Sorry for the error! --Brandon

User Authentication

2004-10-06 Thread Brandon Carter
I have never set up a web site running a mysql server, so I am little fuzzy on details concerning user authentication. Let's say I am creating a page where the user will enter his/her information. I write a PHP script to update the mysql table when they click 'submit'. Do I have to grant

fulltext indices

2004-03-25 Thread Brandon Carter
Is it possible to fit an entire article (say, a newspaper article) into one cell of a MySQL database? When I tried load data local infile the file was imported into several rows! Perhaps I just don't understand the use of a fulltext index. --bhcesl Do you Yahoo!? Yahoo! Finance Tax Center -