Bruce,
Thanks for your reply!
1- Yes I've tested using MySQL GUI 1.7.4 with the same results
2 - Don't know, will have to find out
3 - I'll find and check that too
> Paul,
>
> Have you tried the SQL from mysql to see wht it does outside of PHP? IS
the MySQL server configured to log all queries? What do the logs say is
being sent to the server? These are the places I start from.
>
> Bruce Ferrell
>
>
> >
> > PLEASE if anyone can help!! We are past deadline
> >
> > Object: Retrieve rows from table D.
> >
> > GIVEN:
> > 1. MySQL ver 3.23.33 (but must run on 3.22.25!)
> > 2. Table D is connected to tables E,F,K through tables dE,dF,dK.
> > 3. Table D is connected to table L through tables dK then Lk.
> >
> > D - dE - E
> > D - dF - F
> > D - dK - K
> > D - dK - Lk - L
> >
> > 4. All query WHERE clauses use string fields (VAR or VARCHAR) in E, F,
K, L
> > 5. Each table E,F,K,L has less than 1000 rows.
> > 6. Each string field is indexed
> > 7. Each joiner field is indexed
> >
> > NEED:
> > 1. WHERE clause which checks exact matches for E,F and L tables and
> > substring match for words in K.
> > 2. Multiple words to limit results to intersection of returns
> > 3. Ordered by number of rows in dE,dF, then dK (both L and K)
> > 4. List only unique rows in D
> >
> > I have tryed several things to create various queries in PHP, some which
are
> > as large as 2500 characters!
> >
> > The only thing that I can think of now is Does each AND section of the
WHERE
> > clause have to have ALL unique table aliases? (down to the last common
one?)
> >
> > Paul
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
