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
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
[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
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
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
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
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,
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
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 [EMAIL
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
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
Wendell Frohwein wrote:
snip
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
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 phpMyadmin
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: php-db@lists.php.net
Subject: [PHP-DB] Slow Query
Date:
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
15 matches
Mail list logo