Some people may have experienced an error in createmovie.php on page 96 because of a line of deprecated code. While this doesn't always cause an error, if you do get a fatal error, you can try this fix:

INSTEAD OF
mysql_create_db("wiley");

USE
$query = mysql_query("CREATE DATABASE wiley")
or die(mysql_error());

-Elizabeth

Thanks, Elizabeth. You are a true lifesaver. :D

Ahem, Standard Phrase #427, Buzz ;)

Elizabeth:

 Where can I get a list of the Standard Phrases? :)

BTW Great BOOK!!!!!!!!!!!! So far it is better than the others I have bought on the subject(s)...

Gary

Hmmm.. not sure I can divulge that; it's a very thorough list. ;). I can however tell you that Standard Phrase #427 is "Bite me, Buzz."

Thank you Elizabeth, at least now I am getting some type of error message instead of waiting around for a page that will never load. :(

The error reads:
"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 'KEY (people_id) ) TYPE=MyISAM AUTO_INCREMENT=7' at line 6"

Lines 1-8:
1 <?php
2 $connect = mysql_connect("localhost", "root", "****")
3 or die ("Hey, check your server connection.");
...
6 //Creates the main database
7 $query = mysql_query("CREATE DATABASE wiley")
8 or die (mysql_error());

and the quote is from line 45:
45 PRIMAY KEY (people_id)
46 ) TYPE=MyISAM AUTO_INCREMENT=7";

I have triple checked the code and can't seem to locate the problem. Thanks for the help in advance.

-Mike

Line 45 should probably read "PRIMARY KEY (people_id)" --missing an "R" in primary.

um..., thank you.

This is the error that I have been generating:

Warning: mysql_connect(): Access denied for user: 'Stephen@localhost' (Using password: YES) in D:\Program Files\Apache Group\Apache2\test\createmovie.php on line 2
Hey dude, wake up and check your server connection.

I have the correct password, I know that because I can log into the server, and when prompted for the password, I am able to gain access...I know localhost is correct...so I have isolated the issue down to the username. I looked in the WinMySQLAdmin 1.4 interface and saw that the "Local Username" is Stephen so I tried that...I have tried "root", and generated nothing, as well as a variety of other names, and am tempted to start calling it names. What could be amiss? Thanks...