PHP 4.0 Bug #6377: Problem with length of number of the variables
| From: | Bkrys at Ifrance dot com | Date: | Sun, 27 Aug 2000 14:06:27 +0000 |
| Subject: | PHP 4.0 Bug #6377: Problem with length of number of the variables | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-30814@lists.php.net to get a copy of this message | ||
From: Bkrys@Ifrance.com
Operating system: Windows 98
PHP version: Earlier? Upgrade first!
PHP Bug Type: MySQL related
Bug description: Problem with length of number of the variables
Problem whith the length of the variable in the table.
I have table for increment variables min et max to search in data database the number between min to
max.
//tableaux des 11 éléments des fourchettes de PRIX
$PrixMin=Array(1=>"0","300000","500000","750000","1000000","1250000","1500000","1750000","2000000","2250000","2500000","3000000");
$PrixMax=Array(1=>"300000","500000","750000","1000000","1250000","1500000","1750000","2000000","2250000","2500000","3000000","10000000");
If($Prix=12) // if price = 12éme element try to find le price between 3000000 and 10000000
{$query = "SELECT * FROM Biens AS t1,Client AS t2 WHERE t1.Ref=t2.Ref AND
t1.Dep='$Dep' AND t1.Type1='$TPE' AND t1.PrixVente BETWEEN
'$PrixMin[$Prix]' AND '$PrixMax[$Prix]'";}
// Fin de PRIX =12
If I change the variable 10000000 to 9000000 that work else you have nothing in the database. Of
course I try to find some price to put before in my database.
Ok I sorry for my bad english, but I hope you understand me else you have the code to explain the
problem.