Chapter 16 forum - SQL error

[petefernando]

 Hi

I've got a copy of Beginning PHP5, Apache, and MySQL Web Development.

I've been working through Chapter 16 and get this error when loading the index page:

--------begin cut---------
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod FROM forum_forum f LEFT JOIN forum_posts p ON f.id = p.forum_id AND ' at line 3
-------end cut--------

Here is the offending bit of code:


-------Begin cut--------
$sql = <<<EOS
  SELECT f.id as id, f.forum_name as forum,
    f.forum_desc as description,
    count(forum_id) as threads, u.name as mod
  FROM forum_forum f
  LEFT JOIN forum_posts p
  ON f.id = p.forum_id
  AND p.topic_id=0
  LEFT JOIN forum_users u
  ON f.forum_moderator = u.id
  GROUP BY f.id,
EOS;
--------end cut----------

Somone on another forum suggested I added "f.forum_name, f.forum_desc, u.name" on the end of the group by statement. I've tried this and it doesn't work.

Can anyone help????

Cheers
Pete Fernando

[richard.york]

Try asking in the book's forum located here,
http://p2p.wrox.com/forum.asp?FORUM_ID=157

Regards,
Rich

--
Author,
Beginning CSS: Cascading Style Sheets For Web Design
CSS Instant Results

http://www.catb.org/~esr/faqs/smart-questions.html

[ambo]

me also got the same problem.

The error is something like this

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod FROM forum_forum f LEFT JOIN forum_posts p ON f.id = p.forum_id AND ' at line 3

can anyone outthere help us

Thank u


aaaa

[linusarul]

HI,

Please make a correction on the 3rd line of your sql string in the index.php. we should not use the special word "mod" . you should change this to something else such as "jod" or some other meaningful word. Following is the corrected sql string which I used.

------
$sql = <<<EOS
  SELECT f.id as id, f.forum_name as forum,
    f.forum_desc as description,
    count(forum_id) as threads, u.name as jod
  FROM forum_forum f
  LEFT JOIN forum_posts p
  ON f.id = p.forum_id
  AND p.topic_id=0
  LEFT JOIN forum_users u
  ON f.forum_moderator = u.id
  GROUP BY f.id
EOS;

--------

Hope this will help to everyone who get this same error..

Linus

quote:Originally posted by ambo
 me also got the same problem.

The error is something like this

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod FROM forum_forum f LEFT JOIN forum_posts p ON f.id = p.forum_id AND ' at line 3

can anyone outthere help us

Thank u


aaaa