Chapter 16, Message Board Header Problems

[markdean]

I have been attempting to implement the Comic Book Appreaction forum described in Chapter 16, however, i am getting the following error:
"Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at \\premfs17\sites\premium17\lsrl\webroot\MessageBoa rd\conn.php:26) in \\premfs17\sites\premium17\lsrl\webroot\MessageBoa rd\transact-user.php on line 19
Could not redirect; Headers already sent (output)."

I have read about these header problems in the book but I am new to php and I would be grateful for any assistance in resolving these issues.

[markdean]

I have now solved the above problem, had some blank spaces at the end of my conn.php file. However i now have another problem, my index.php page says:

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

Any ideas?? The full sql statement is as below:

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

[borg434]

Yer I have the same error.

I posted on a different section of these forums after some others had the same problem 2.

Not a clue what the problem vould be to be honest.

Any help would be apreciated

Cheers.

[Ebony]

:D

Code should read:

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

It should be 'mod' and not mod cos the latter is a reserved ...

Ebony

[sun]

i meant while implementing a header with my book Beginning PHP, Apache,
MySQL® Web Development,
am getting header already sent error message i.e
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\chapter6\commit.php:9) in C:\xampp\htdocs\chapter6\commit.php on line 137

[grstad]

The error message occurs due to some code you have implemented before the headerinfo (Html- and w3-info) in your script. It might be "session()" or anything else. Use of blank spaces will also cause problems. Read some of the first chapters in the book!

grstad