Wrox Programmer Forums
BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5
This is the forum to discuss the Wrox book Beginning PHP4 by Wankyu Choi, Allan Kent, Chris Lea, Ganesh Prasad, Chris Ullman; ISBN: 9780764543647
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 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
Old August 1st, 2006, 06:52 AM
Registered User
Join Date: Jul 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to PeterJB
Default Creating database and tables. chapter 9

I have a problem with the code from the book, it won't let me use the following :-

$user_table_def = "usernumber MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,";

if I take away the DEFAULT '0', then it works but i have a problem running the userviewer.php script... it says:-

Error:1054: unknown column 'usernumber in field list'.

I tried to enter that line using command line client and it still wouldn't work. Somewhere there is a problem, you can't seem to use DEFAULT and NOT NULL AUTO_INCREMENT together.

Can anyone tell me how to fix this.

Thank you.

Dislexics have more fnu

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Tables in RichTextBox katsarosj Pro VB.NET 2002/2003 13 March 14th, 2014 05:50 AM
creating tables within tables in access??? carswelljr Access 3 August 23rd, 2006 01:21 PM
Help creating tables racin_vegas PHP How-To 1 January 19th, 2006 09:11 AM
Creating word tables, PLEASE help :D Cadey VB How-To 1 December 1st, 2003 08:31 AM
Creating Tables Programmatically stu9820 ASP.NET 1.0 and 1.1 Basics 10 October 22nd, 2003 04:25 PM

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