Jaloney Posted March 25, 2013 Share Posted March 25, 2013 Hi In the downloads for Chapter this book, Chapter Five is missing. I need the Forums scripts. Thank you Link to comment Share on other sites More sharing options...
Larry Posted March 25, 2013 Share Posted March 25, 2013 There are no scripts for Chapter 5. All the SQL commands are in the SQL file. Link to comment Share on other sites More sharing options...
Jaloney Posted March 26, 2013 Author Share Posted March 26, 2013 There is one folder titled SQL commands in the downloads for this book and it is for an author's table..Where are the SQL commands for the Forums database in Chapter 5. All of the tutorials in that chapter are based on that database, so I would appreciate a link to the SQL file as I do not find it on downloads page. Link to comment Share on other sites More sharing options...
Jaloney Posted March 26, 2013 Author Share Posted March 26, 2013 It is actually Chapter 6. I have two of your books and in one of them it was in a different chapter. The forums database that is used for the Chapter SIX tutorials on Database design, and primary key's ect .. there is no sql commands to fill it with data if I create the database.. Link to comment Share on other sites More sharing options...
Jaloney Posted March 26, 2013 Author Share Posted March 26, 2013 Okay I found the SQL commands nestled in the middle of the file. I copied and pasted into my PHP Myadmin SQL command prompt and I get an error on line one. #1064 - 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 'CHARSET utf8' at line 1 I looked at the code and it is exactly the same as yours and the books. All of the other SQL commands for other chapters work fine. I was hoping your command files were different as My instructor tried to figure out why this same error is happening with the file he provided to the class.. which gives the same error. He gave up and I can't give up as I need to learn this stuff and I can't learn it without a way to do the searches with the database. Link to comment Share on other sites More sharing options...
Larry Posted March 26, 2013 Share Posted March 26, 2013 You don't execute a CHARET command from within phpMyAdmin. The CHARSET in phpMyAdmin is configured in phpMyAdmin itself. CHARSET is used when connecting to MySQL from the command-line using the mysql client. 1 Link to comment Share on other sites More sharing options...
Jaloney Posted March 26, 2013 Author Share Posted March 26, 2013 Larry, Thank you so much. The instructors code has character set in two places and it wouldn't work in PHP myadmin. I deleted these and I am good to go. Finally! Link to comment Share on other sites More sharing options...
Larry Posted March 27, 2013 Share Posted March 27, 2013 Great. You're quite welcome. Link to comment Share on other sites More sharing options...
Recommended Posts