Re: [PHP] formulate nested select

2009-04-02 Thread Ian
On 31 Mar 2009 at 18:15, PJ wrote: snip But I see that I may be trying to do too much - I thought of showing how many books were listed under each letter of the alphabet but I don't see how it can be done in any simiple way as it would mean that I would have to do the select once with

Re: [PHP] formulate nested select

2009-03-31 Thread PJ
Jim Lucas wrote: Chris wrote: PJ wrote: I cannot find anything on google or the manuals/tutorials that gives some kin of clear explanation of how to so nested selects with where or whatever. I have three tables: books, authors and book-authors. I need to retrieve only those books whose

Re: [PHP] formulate nested select

2009-03-31 Thread PJ
I must be doing something wrong. Can't figure it out even though I've been searching the manuals tutorials, it still does not work. Here is the exact code that I have tried; the first version is commented out and obviously does not work either (the spelling, the table names and column names are

Re: [PHP] formulate nested select

2009-03-31 Thread Ian
On 31 Mar 2009 at 9:08, PJ wrote: I must be doing something wrong. Can't figure it out even though I've been searching the manuals tutorials, it still does not work. Here is the exact code that I have tried; the first version is commented out and obviously does not work either (the spelling,

Re: [PHP] formulate nested select

2009-03-31 Thread PJ
Ian wrote: On 31 Mar 2009 at 9:08, PJ wrote: I must be doing something wrong. Can't figure it out even though I've been searching the manuals tutorials, it still does not work. Here is the exact code that I have tried; the first version is commented out and obviously does not work

Re: [PHP] formulate nested select

2009-03-31 Thread PJ
Gentlemen all others, The problem was partly fixed with ' ' around $Auth... but... somehow, I see that the results do not work with the rest of the script. The results give a an array within an array - so this mucks up all the rest which is set up to deal with only the book table. The count() is

RE: [PHP] formulate nested select

2009-03-31 Thread kyle.smith
] Sent: Tuesday, March 31, 2009 2:06 PM To: Jim Lucas Cc: Chris; php-general@lists.php.net Subject: Re: [PHP] formulate nested select Gentlemen all others, The problem was partly fixed with ' ' around $Auth... but... somehow, I see that the results do not work with the rest of the script

Re: [PHP] formulate nested select

2009-03-31 Thread PJ
? -Original Message- From: PJ [mailto:af.gour...@videotron.ca] Sent: Tuesday, March 31, 2009 2:06 PM To: Jim Lucas Cc: Chris; php-general@lists.php.net Subject: Re: [PHP] formulate nested select Gentlemen all others, The problem was partly fixed with ' ' around $Auth

Re: [PHP] formulate nested select

2009-03-31 Thread haliphax
with ORDER BY title as that does not require another effort. Any thoughts or suggestions? -Original Message- From: PJ [mailto:af.gour...@videotron.ca] Sent: Tuesday, March 31, 2009 2:06 PM To: Jim Lucas Cc: Chris; php-general@lists.php.net Subject: Re: [PHP] formulate nested select

Re: [PHP] formulate nested select

2009-03-31 Thread Chris
PJ wrote: Ian wrote: On 31 Mar 2009 at 9:08, PJ wrote: I must be doing something wrong. Can't figure it out even though I've been searching the manuals tutorials, it still does not work. Here is the exact code that I have tried; the first version is commented out and obviously does not

Re: [PHP] formulate nested select

2009-03-31 Thread PJ
: [PHP] formulate nested select Gentlemen all others, The problem was partly fixed with ' ' around $Auth... but... somehow, I see that the results do not work with the rest of the script. The results give a an array within an array - so this mucks up all the rest which is set up to deal

Re: [PHP] formulate nested select

2009-03-30 Thread Chris
PJ wrote: I cannot find anything on google or the manuals/tutorials that gives some kin of clear explanation of how to so nested selects with where or whatever. I have three tables: books, authors and book-authors. I need to retrieve only those books whose author's names begin with A. I have

Re: [PHP] formulate nested select

2009-03-30 Thread Jim Lucas
Chris wrote: PJ wrote: I cannot find anything on google or the manuals/tutorials that gives some kin of clear explanation of how to so nested selects with where or whatever. I have three tables: books, authors and book-authors. I need to retrieve only those books whose author's names begin with

Re: [PHP] formulate nested select

2009-03-30 Thread Chris
Jim Lucas wrote: Chris wrote: PJ wrote: I cannot find anything on google or the manuals/tutorials that gives some kin of clear explanation of how to so nested selects with where or whatever. I have three tables: books, authors and book-authors. I need to retrieve only those books whose