Thanks guys now I need to figure out the PHP code on this. It's a real pain when you use a text book as an example and there are unexplained bugs. I will report this to Wiley Press.
----- Original Message -----
From: Pete
To: php-objects@xxxxxxxxxxxxxxx
Sent: Monday, August 10, 2009 5:12 PM
Subject: Re: mysql problem in a php book
In message <A26BE5D4-B399-432F-8462-B9F2B24175A0@xxxxxxxxxxxxxxxxxx>,
Joe Forsythe <jforsythe@xxxxxxxxxxxxxxxxxx> writes
>What is your question/what problem are you having?
>--
>Joe
Hey, Joe, as I read the original, I thought, great, we have all the
details we need for once... <G>
He did say
>> Message d'erreur : Unknown column 'a.type_id' in 'on clause'
1) You have create_date rather than creation_date
2) The tables are in the wrong order for a JOIN - in the FROM section, I
have swapped a c for c a
SELECT
a.name,
a.type_id,
b.title,
b.description,
b.content_date,
b.creation_date,
b.created_by,
b.last_upd_date,
b.last_upd_by,
c.name as dept_name,
content_id
FROM Department c,
Content_Type a
LEFT OUTER JOIN Content b
on a.type_id = b.content_type
and a.type_id = b.content_type
and b.dept_id = 3
and b.content_type = 4
WHERE c.dept_id = 3
ORDER BY content_date DESC
And I get 4 records returned.
They may not be the right ones, but...
--
Pete Clark
Hot Costa - Local Spain
http://www.hotcosta.com
[Non-text portions of this message have been removed]
