urgent problem with mysql and phpmyadmin
Andrew, Thursday, February 21, 2002, 3:31:16 AM, you wrote: AB I have created a table in the mysql db, using phpmyadmin with the following AB statement: AB create table books AB ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary AB key(isbn)); AB which works fine and creates the table i need the problem comes when i try AB to insert some values into the price column using the phpmyadmin form, if AB for example i try to enter the price 34.99 it will only allow me to enter AB 34.9, and then when i go to the browse feature it shows the value as 34.90 AB any ideas on what's going wrong??? I have tested it and it worked fine. What version of MySQL do you use? AB any help would be much apprecited. AB thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent problem with mysql and phpmyadmin
I have created a table in the mysql db, using phpmyadmin with the following statement: create table books ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary key(isbn)); which works fine and creates the table i need the problem comes when i try to insert some values into the price column using the phpmyadmin form, if for example i try to enter the price 34.99 it will only allow me to enter 34.9, and then when i go to the browse feature it shows the value as 34.90 any ideas on what's going wrong??? any help would be much apprecited. thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: urgent problem with mysql and phpmyadmin
My guess. . . I have seen this problem with other databases . . . don't know if it is true for MySQL as well. Try to change to your field definition to float(5,2) as it may be counting the (.) as part of your field size. So if you number is xx.xx you will need 5,2. 4,2 would give you xx.x David McInnis -Original Message- From: Andrew Bunkell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 5:31 PM To: [EMAIL PROTECTED] Subject: urgent problem with mysql and phpmyadmin I have created a table in the mysql db, using phpmyadmin with the following statement: create table books ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary key(isbn)); which works fine and creates the table i need the problem comes when i try to insert some values into the price column using the phpmyadmin form, if for example i try to enter the price 34.99 it will only allow me to enter 34.9, and then when i go to the browse feature it shows the value as 34.90 any ideas on what's going wrong??? any help would be much apprecited. thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php