I have entered the code for the above file but whenever I try to run it I get the following message

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 " at line 6

I have tried downloading the code from the website but I get the same message when I try and run the downloaded file.

Can anyone help?

Firstly you need to identify what is on your line 6?

Tips:
To be more efficient in solving the problem u need to Identify the exact Line with the error.

1st - Qoute the browser's Error Message
2nd - Qoute the Lines of codes involve in the Error Message (altho. sometimes you need to qoute the whole Chunk of codes)
3rd - If you are following the BOOK closely, please also state the Page No.

4th - Wait for reply from some helpful/resourceful reader.
5th - Dont forget to thank them if they solve your problems

If you dont qoute/pickout the problems what you Posted will be Jibberish and can't be help by others.

GoodLuck

Just my 2cents
-Slim, WebProgrammerWannabe

Hi bobg,

Please re-read page 124.

Step 2 states to save the file as movie_details.php and upload it to the web server... It does not state to open movie_details.php in a web browser.

Step 3 states to open table3.php in a web browser which will then call the movie_details.php file when a link is clicked.

I ran into the same problem because I did not read step 3...

I ran into the same error as Bobg. I found the error went away when I edited the table3.php around line 99. I did not notice that on page 118 the heredoc is changed from ENDHTML to ENDINFO (not sure if that matters, but it was not highlighted as a change in the book.

I also had tried to use the Tooltips code on page 119, but when using this I received the
"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 " at line 6" When I used the original code without the tooltip, everything worked. Hope this helps someone down the road.

$table .= <<<ENDINFO
<tr>
<td> <a href="movie_details.php?movie_id=$movie_id"> $movie_name </a> </td>

<td>$movie_year</td>
<td>$director</td>
<td>$leadactor</td>
<td>$movietype</td>
</tr>
ENDINFO;