[PHP-DB] Re: Slow Query

2005-01-12 Thread Manuel Lemos
Hello, on 01/12/2005 08:48 PM Wendell Frohwein said the following: I was hoping on the based on the operation of the script, someone would suggest a better and faster way to search zip code radius, while matching the results to agents within the system. I assume you are using a script like this tha

RE: [PHP-DB] Slow Query

2005-01-12 Thread Bastien Koert
are there indeces on the tables columns? Also does your query use the IN (zip1, zip2, zipN) format or or do you query for each zip individually? The second is absolute killer on the db bastien From: "Wendell Frohwein" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] Slow Query Date: Wed, 12 Jan 2005

RE: [PHP-DB] reorder records with phpMyadmin ?

2005-01-12 Thread Bastien Koert
since its all sql sorts, you get ascending on a column or descending on a column...you don't really give your users access to phpmyadmin do you? sounds awefully risky to me bastien From: Graham Anderson <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] reorder records with phpMyadmi

Re: [PHP-DB] Slow Query

2005-01-12 Thread Jochem Maas
Wendell Frohwein wrote: So I rewrote my script to do the follow: The client submits a property for an appraisal. Based on the appraisal type and property zip code, It does a radius search of 2 miles from the property zip. If no matches are found, it does a 5 mile radius search. For every zip code

[PHP-DB] reorder records with phpMyadmin ?

2005-01-12 Thread Graham Anderson
is there a button/feature in phpmyadmin that lets you reorder records in a found set I have an playlist_order field I want to do an UPDATE to let users order their own playlist... If phpmyadmin does not have the feature, is there another opensource php-based mysql editor that does ? many thanks

[PHP-DB] Slow Query

2005-01-12 Thread Wendell Frohwein
First of all I would like to thank anyone who lends a hand in this matter. Here is what im working with. Redhat 9, PHP 5.0.2, Apache/2.0.50, MySQL 4.1.8-standard Binary Installation for pc-linux-i686, OpenSSL 0.9.7d, gcc version 3.2.2. PHP compiled with mysql, and mysqli capability. This is how t

Re: [PHP-DB] LEFT joins

2005-01-12 Thread Han
Hmm, still no luck. Thanks for the help. I think I'll have to break the select up into 2 selects and throw the results of the first into arrays. Didn't want to do it like that, but it's gonna be quicker now. Han. - Original Message - From: "Jochem Maas" <[EMAIL PROTECTED]> To: "Han" <[EM

Re: [PHP-DB] LEFT joins

2005-01-12 Thread Jochem Maas
Han wrote: Hmm, still no luck. Thanks for the help. I think I'll have to break the you mean that it still times out? crashes mysql? maybe the table (tc_countries) is corrupt? try doing a repair. select up into 2 selects and throw the results of the first into arrays. Didn't want to do it like that

Re: [PHP-DB] LEFT joins

2005-01-12 Thread Jochem Maas
Han wrote: Oh yes, sorry, not used to the "reply-all". most of us get hammered by that one once in a while! read on the the interesting bit... I've pasted it directly into the MYSQL console as just sql and this is where I discovered my problem. My code is : -- SELECT b.fldName, b.fldEmail, b.fldC

Re: [PHP-DB] LEFT joins

2005-01-12 Thread Jochem Maas
BTW: Hans please use 'reply to all' so that the rest of the list can see your replies (+ it makes me feel less like you personal help-desk ;-). ...on to the reply proper: Han wrote: Hi, thanx for replying. It still times out when I use either of those alternatives. can you tell what exactly the s

Re: [PHP-DB] LEFT joins

2005-01-12 Thread Han
Oh yes, sorry, not used to the "reply-all". I've pasted it directly into the MYSQL console as just sql and this is where I discovered my problem. My code is : -- SELECT b.fldName, b.fldEmail, b.fldCountryCode, b.fldMobile, a.fldTime as Time, c.fldUsername FROM tblSubscribersChoices a INNER JOIN

Re: [PHP-DB] LEFT joins

2005-01-12 Thread Jochem Maas
Han wrote: Hi, I'm having a problem with some joins. My code is : -- SELECT b.fldName, b.fldEmail, b.fldCountryCode, b.fldMobile, a.fldTime as Time, c.fldUsername FROM tblSubscribersChoices a INNER JOIN tblUser c on a.fldChoice=c.fldClientID LEFT JOIN tblSubscribers b on a.fldClientID = b.fldID

[PHP-DB] unsuscribe

2005-01-12 Thread Billy Jack Simpson
[PHP-DB] unsuscribe __ Do you Yahoo!? Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] LEFT joins

2005-01-12 Thread Han
Hi, I'm having a problem with some joins. My code is : -- SELECT b.fldName, b.fldEmail, b.fldCountryCode, b.fldMobile, a.fldTime as Time, c.fldUsername FROM tblSubscribersChoices a INNER JOIN tblUser c on a.fldChoice=c.fldClientID LEFT JOIN tblSubscribers b on a.fldClientID = b.fldID ORDER BY

[PHP-DB] unsuscribe

2005-01-12 Thread RENAULT , François
Unsuscribe - Le present message (y compris tous les elements attaches) est confidentiel et est destine a ses seuls destinataires. Si vous l'avez recu par erreur, merci de l'indiquer a son expediteur par retour et de proceder a sa destruction dans vos systeme