Re: [PHP] formulate nested select

2009-04-02 Thread Ian
On 31 Mar 2009 at 18:15, PJ wrote: > >> 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

Re: [PHP] formulate nested select

2009-03-31 Thread PJ
n things. >> I suppose I could live with ORDER BY "title" as that does not require >> another effort. >> Any thoughts or suggestions? >>> >>> >>> >>> >>> -Original Message- >>> From: PJ [mailto:af.gour..

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 wo

Re: [PHP] formulate nested select

2009-03-31 Thread haliphax
; >> >> >> >> >> -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 >> &g

Re: [PHP] formulate nested select

2009-03-31 Thread PJ
DER 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.n

RE: [PHP] formulate nested select

2009-03-31 Thread kyle.smith
: 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... but... somehow, I see that the results do not wor

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 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

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 spell

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 c

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

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 author's

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
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 trie