Mike Blezien wrote:
Chris,
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
The math in the link I gave you will still work for the distance
calculations, however if you want what that site does you will need
Chris,
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
Mike
- Original Message -
From: "Chris W" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MYSQL General List"
Sent: Sunday, August
Mike Blezien wrote:
Hello,
we are working on a small project which needs to calculate the closest
distances
from an address and/or zipcode entered into a search box. It will read
from a
MySQL database of companies, which store their address and zipcodes.
looking for the best way to approach
[snip]
we are working on a small project which needs to calculate the closest
distances from an address and/or zipcode entered into a search box. It
will read from a MySQL database of companies, which store their address
and zipcodes.
looking for the best way to approach this. I've seen some zipco
On Mon, 2006-08-21 at 07:39 +1000, Chris wrote:
> Ow Mun Heng wrote:
> > On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
> >> On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> >>> I'm have a query like so
> >>>
> >>> select
> >>> A,
> >>> index_A
> >>> from
> >>> tableA
> >>> join tableB
>
Hello,
we are working on a small project which needs to calculate the closest distances
from an address and/or zipcode entered into a search box. It will read from a
MySQL database of companies, which store their address and zipcodes.
looking for the best way to approach this. I've seen some zip
[ always cc the list so others can share the fix or make appropriate
comments ]
Nicholas Wyatt wrote:
hi chris,
thanks for answering! however, i do already have indexes on those
columns. all my tables use the myisam storage engine. what are the
differences you mentioned between these engines w
select userid,count(text) from blah group by userid;
--On August 20, 2006 7:22:59 PM +0100 Peter Van Dijck
<[EMAIL PROTECTED]> wrote:
I have a table with userid and text. Users write text. I want to find
the top 5 users who have the most rows in this table.
I can't seem to figure out the que
VenuGopal Papasani wrote:
Dear all,
I have a table with the following structure.
ield Type CollationNullKey Default
Extra Privileges Comment
--- -- -- ---
-
Nicholas Wyatt wrote:
Hello to all!
has anybody got any ideas how i can speed up the following query?
it's so awfully slow (about 1 second).
the "test_item" table is the main problem. currently, it has
about 108.000 entries.
is it normal that it takes so long? and if it isn't, how can i
optimi
Ow Mun Heng wrote:
On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
wh
look in /var/lib/mysql for the error file. make sure /var/lib/mysql is
owned by mysql
Karl Larsen wrote:
I am trying to get mysql 5 to run on my Fedora Core 4 linux. I
installed both server and client RPM files. The info is good and using that
I am trying to do the post-install. I ran
I am trying to get mysql 5 to run on my Fedora Core 4 linux. I
installed both server and client RPM files. The info is good and using that
I am trying to do the post-install. I ran mysql_install_db as a user and it
failed. Then I tried as root and it seemed to work. But one thing it says t
brilliant, that works! Thanks!
On 8/20/06, Chris W <[EMAIL PROTECTED]> wrote:
Peter Van Dijck wrote:
> I have a table with userid and text. Users write text. I want to find
> the top 5 users who have the most rows in this table.
>
> I can't seem to figure out the query.. is there a query poss
Peter Van Dijck wrote:
I have a table with userid and text. Users write text. I want to find
the top 5 users who have the most rows in this table.
I can't seem to figure out the query.. is there a query possible to do
this?
Thanks!
Peter
SELECT Count(*) as Count, UserID
FROM table
GROUP BY
I have a table with userid and text. Users write text. I want to find
the top 5 users who have the most rows in this table.
I can't seem to figure out the query.. is there a query possible to do this?
Thanks!
Peter
--
find videoblogs: http://mefeedia.com
my blog: http://poorbuthappy.com/ease/
m
On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
> On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > I'm have a query like so
> >
> > select
> > A,
> > index_A
> > from
> > tableA
> > join tableB
> > on tableB.indexA = tableA.indexA
> >
> >
> > select
> > A,
> > index_A
> > from
> > table
Hello to all!
has anybody got any ideas how i can speed up the following query?
it's so awfully slow (about 1 second).
the "test_item" table is the main problem. currently, it has
about 108.000 entries.
is it normal that it takes so long? and if it isn't, how can i
optimize the query? i've got
Здравствуйте!
Интересует такой момент. Мой сайт хостится у местного провайдера. Они создали
базу mySQL где у меня и лежат таблицы для моего портала. Возникла необходимость
перенести модули (гостевая книга и фотогалерея) на новый хост. Файлы модулей я
скопировал, проблем с этим не возник
On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
whcih would be more efficient? using the where clause which uses the
index or
20 matches
Mail list logo
