note 43468 added to function.mysql-query
| From: | diag at chREMOVEeerful dot com | Date: | Tue, 22 Jun 2004 13:54:05 +0000 |
| Subject: | note 43468 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-71499@lists.php.net to get a copy of this message | ||
On mysql 4.0.0-alpha-NT, using float as column type in my case as part of a two-field primary key,
will after inserting/updating the 0.66 not find the record with key 0.66 when searched for by
key=0.66 (but with: key>0.65 AND key<0.67).
Solution: use DECIMAL(3,2) (or bigger).
----
Manual Page -- http://www.php.net/manual/en/function.mysql-query.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+43468
Delete -- http://master.php.net/manage/user-notes.php?action=delete+43468&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+43468&report=yes
Search -- http://master.php.net/manage/user-notes.php