Andrew Ballard wrote:
> On Thu, Apr 9, 2009 at 1:39 PM, PJ wrote:
> [snip]
>
>> Now the silly questions = often I am curious what effect the differences
>> in code will have on performance.
>> For instance, why are you using author.last_name LIKE '{$Auth}%' rather
>> than LEFT('$Auth') ? As I h
On Thu, Apr 9, 2009 at 1:39 PM, PJ wrote:
[snip]
> Now the silly questions = often I am curious what effect the differences
> in code will have on performance.
> For instance, why are you using author.last_name LIKE '{$Auth}%' rather
> than LEFT('$Auth') ? As I have mentioned, it is not important
OK, so I owe you a big one :-*
Your code works... now, I'm faced with a horrendous problem and that is
to make sense of it all :-)
What I seem to get from this exercise is that I don't need the ordinals
at all.
Uuuuh... that's interesting. I get it. So now, I can update my
bookInsert script t
Jim Lucas wrote:
> PJ wrote:
>> Hi Jim,
>> Sorry I could not gat back to you on your suggestion. I've been under
>> the weather for a couple of days but am almost over it.
>> Your suggestion does not work... yet.
>> I'll insert comments & questions below...
>>
>> Jim Lucas wrote:
>>> PJ wrote:
PJ wrote:
Gentlemen,
First, let me thank you all for responding and offering suggestions. I
appreciate it and I am learning things.
How about telling us/me what it did or did not do for you?
However, it looks like my message is not getting across:
The problem is not to retrieve only the auth
PJ wrote:
Hi Jim,
Sorry I could not gat back to you on your suggestion. I've been under
the weather for a couple of days but am almost over it.
Your suggestion does not work... yet.
I'll insert comments & questions below...
Jim Lucas wrote:
PJ wrote:
I've searched the web, the tutorials, etc.
2009/4/7 Bastien Koert :
> On Tue, Apr 7, 2009 at 1:10 PM, Michael A. Peters wrote:
>
>> PJ wrote:
>>
>>> Bob McConnell wrote:
>>>
From: PJ
> First, let me thank you all for responding and offering suggestions. I
> appreciate it and I am learning things.
> However, it looks l
Hi Jim,
Sorry I could not gat back to you on your suggestion. I've been under
the weather for a couple of days but am almost over it.
Your suggestion does not work... yet.
I'll insert comments & questions below...
Jim Lucas wrote:
> PJ wrote:
>> I've searched the web, the tutorials, etc. with no l
PJ wrote:
Gentlemen,
First, let me thank you all for responding and offering suggestions. I
appreciate it and I am learning things.
However, it looks like my message is not getting across:
The problem is not to retrieve only the authors whose last names begin
with A:
1) which books have a secon
On Tue, Apr 7, 2009 at 1:10 PM, Michael A. Peters wrote:
> PJ wrote:
>
>> Bob McConnell wrote:
>>
>>> From: PJ
>>>
First, let me thank you all for responding and offering suggestions. I
appreciate it and I am learning things.
However, it looks like my message is not getting across:
PJ wrote:
Bob McConnell wrote:
From: PJ
First, let me thank you all for responding and offering suggestions. I
appreciate it and I am learning things.
However, it looks like my message is not getting across:
The problem is not to retrieve only the authors whose last names begin
with A:
Actuall
Bob McConnell wrote:
> From: PJ
>> First, let me thank you all for responding and offering suggestions. I
>> appreciate it and I am learning things.
>> However, it looks like my message is not getting across:
>> The problem is not to retrieve only the authors whose last names begin
>> with A:
>
> A
From: PJ
> First, let me thank you all for responding and offering suggestions. I
> appreciate it and I am learning things.
> However, it looks like my message is not getting across:
> The problem is not to retrieve only the authors whose last names begin
> with A:
Actually, it appears you simply
PJ,
On Tue, Apr 7, 2009 at 11:37 AM, PJ wrote:
> $SQL = "SELECT b.*, c.publisher, a.first_name, a.last_name
>FROM book AS b
>LEFT JOIN book_publisher as bp ON b.id = bp.bookID
>LEFT JOIN publishers AS c ON bp.publishers_id = c.id
>LEFT JOIN book_author AS ba ON b.
Gentlemen,
First, let me thank you all for responding and offering suggestions. I
appreciate it and I am learning things.
However, it looks like my message is not getting across:
The problem is not to retrieve only the authors whose last names begin
with A:
1) which books have a second author?
2)
PJ wrote:
I've searched the web, the tutorials, etc. with no luck and have asked
on MySql list with no luck and have even posted here with no replies.
So, let's try again:
I am trying to limit the search for books to only those that start with
"A" (does not have to be case sensitive); but within
PJ wrote:
I've searched the web, the tutorials, etc. with no luck and have asked
on MySql list with no luck and have even posted here with no replies.
So, let's try again:
I am trying to limit the search for books to only those that start with
"A" (does not have to be case sensitive); but within
On Mon, Apr 6, 2009 at 2:05 PM, PJ wrote:
> My code already has selected the books whose authors last names start
> with A as well as the authors themselves.
> Within the results some books have 2 authors.
If you already have the book IDs where this happens, then for each bookID
(probably a for
Hi Lex,
Thanks for responding.
Indeed, it is a very difficult problem - for me, at least; I think it is
as difficult to formulate the problem in plain English as to figure out
how to solve it.
My code already has selected the books whose authors last names start
with A as well as the authors thems
PJ,
On Mon, Apr 6, 2009 at 12:32 PM, PJ wrote:
> I am trying to limit the search for books to only those that start with
> "A" (does not have to be case sensitive); but within that selection
> there may be a second author whose name may start with any letter of the
> alphabet.
>
First off, are y
Hi Bastien,
Thanks for the suggestion. But my code already does that.
I think it is as difficult to formulate the problem in plain English as
to figure out how to solve it:
The problem is:
Within the results some books have 2 authors:
1) is there a second author for any of the books in the resu
On Mon, Apr 6, 2009 at 12:32 PM, PJ wrote:
> I've searched the web, the tutorials, etc. with no luck and have asked
> on MySql list with no luck and have even posted here with no replies.
> So, let's try again:
>
> I am trying to limit the search for books to only those that start with
> "A" (doe
22 matches
Mail list logo
