mccoy81 Posted October 4, 2013 Share Posted October 4, 2013 HI Larry and fellow forum members, First of all I love your books, they have taught me so much about website design. Now I have found a pretty big error that I do not know if you have found or not. On the stored procedure add_customers in the second example you have the phone number column set as an INT. After testing my site and wondering where the error was I found out that: 2147483647 is the largest int value for mysql. so any phone number you try to insert that is larger than that number comes up as that number (most will be). So I just switched the column and the stored procedure to a BIGINT and the problem is fixed. I just thought if you and your members did not know that yet it would be a good thing to let everyone in on. Link to comment Share on other sites More sharing options...
Larry Posted October 7, 2013 Share Posted October 7, 2013 Hmmm...I'll check that out. Thanks for letting me know. Link to comment Share on other sites More sharing options...
Recommended Posts