Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Dreamweaver MX: PHP Web Development
This is the forum to discuss the Wrox book Dreamweaver MX: PHP Web Development by Gareth Downes-Powell, Tim Green, Bruno Mairlot; ISBN: 9780764543876
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Dreamweaver MX: PHP Web Development section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 1st, 2005, 04:38 AM
Authorized User
 
Join Date: Apr 2005
Location: London, , United Kingdom.
Posts: 79
Thanks: 0
Thanked 0 Times in 0 Posts
Default Page 39 ...Is this book Out nof date?

Hi All
I have just started this book having read it from cover to cover.
Page 39
create table tablename (field1 type1, field2 type2, ... ...,); produced the result
Error 1064 (42000): You have an error in your SQL sybtax.......... Checking this in the manual I see it refered to alterations made to mysql in recent updates.
Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Message: %s near '%s' at line %d

I am not sure what this means but this could be a reason for the error when I type the code the book recommeds. I am using MYSQL version 4.13.

I am also not sure if the author intends us to enter in additional fields or the dots. Most likely seems obivious to others.

Any comment on this gratefully recieved. I do not want to add to the dificulty in learning PHP/MYSQL

All the best
Jacky Kenna


  #2 (permalink)  
Old March 30th, 2009, 03:03 AM
Authorized User
 
Join Date: Mar 2009
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
Default

CREATE TABLE tbl_name(
col_name_text VARCHAR(1),
col_name_int tinyint(11)
);

mysql correct syntax, otherwise this book does suck


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page 91 of book: Global Variables. Nick Y BOOK: Ivor Horton's Beginning Visual C++ 2005 1 June 24th, 2006 10:48 PM
book examples not on code download page jb4mt JSP Basics 3 September 23rd, 2003 01:18 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.