embtech wrote:Yes I have stared at line 1. I am assuming that line 1 would be the first query request. I have focused on the line with the query in the fact that anytime I make a change there, the error is associated with that line. Keep in mind, something that I did not mention in the OP, I am very new to php/mysql and am trying to learn how to crawl here. And the fact that the learning tool I am using, the syntax from that book does not work with my versions of php/mysql. So along with each step of the learning process, I have to try to figure out what the correct sytax is for my versions on the server. Which in the end will only make me a better programmer. The error script that is presented is somewhat cryptic to me. I am sorry if you are getting frustrated with me. I feel that frustration myself.
OK, then let me try to give you some tips about programming with PHP and MySQL. When you receive an error message, the line number refers to the numbered line in the then-executing script; the line number that appears in most editors. This can get a little more complicated if you have "include files". Since an error occurs when the parser fails to understand your code, the place it tells you to look is always AFTER where your mistake is. But the content of the error message is SUPER critical to determining what's going wrong, so any time you post a question in a forum, related to an error message you have received, always BEGIN by stating the FULL text of the error message and then show your code just before the line number it mentions. Learn to read and understand the error messages, they are your best friends.
Try to avoid "code thrashing". By that I mean when something isn't working, just trying something else (like parentheses or quotes), because you're more likely to make it
worse. Instead, LOOK UP THE PROPER SYNTAX, either in a book or by using Google to search.
Learn the correct way, don't learn all the wrong ways! There are some great reference and tutorial web sites. As a beginner, take advantage of them! One of the best is
http://w3schools.com and others include
http://www.php.net/manual/en/getting-started.php and
http://dev.mysql.com/tech-resources/art ... intro.html.