Wrox Programmer Forums
|
BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6
This is the forum to discuss the Wrox book Beginning PHP, Apache, MySQLWeb Development by Michael K. Glass, Yann Le Scouarnec, Elizabeth Naramore, Gary Mailer, Jeremy Stolz, Jason Gerner; ISBN: 9780764557446
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 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 April 11th, 2006, 05:50 PM
Registered User
 
Join Date: Apr 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 14 ordermain sql prob

Just wondereing if any has solved the prob of entering all info into the ordermain table. Everything else seems to be running fine, however data only seems to get as far as the customer table and orderdet table. The ordermain table says empty set. Any ideas?
Thanks alot
Lisa
 
Old May 29th, 2006, 09:40 PM
Registered User
 
Join Date: May 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I, too am having the exact same problem...everything else in the chapter is fine...but nothing ends up being inserted into the ordermain table...what are we missing??? I've been banging my head against the wall for hours....


Mike

 
Old June 6th, 2006, 01:06 AM
Registered User
 
Join Date: May 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

BUMP:

I'm desperately flustered on why this doesn't work...does it work for anyone else???

 
Old August 25th, 2006, 03:26 PM
Registered User
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The reason it is not working because when insert the record to ordermain and field is missing. The missing field is subtotal and it is non-null field. If you add this field and a value, it will work.
The sample code has only the total but not the subtotal. Both fields must be submitted in order to work.






Similar Threads
Thread Thread Starter Forum Replies Last Post
chapter 14 vthunder70 BOOK: Beginning ASP.NET 2.0 and Databases 2 October 3rd, 2007 02:11 PM
Chapter 14 example pkumar@ech BOOK: Professional Jakarta Struts 0 November 15th, 2006 09:10 AM
Chapter 14 JonG BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 March 21st, 2006 10:04 PM
Chapter 14 Mike Smith BOOK: Professional C#, 2nd and 3rd Editions 2 January 4th, 2004 05:13 PM
Chapter 14 XML starsol Beginning PHP 2 July 18th, 2003 10:27 AM





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