PHP 4.0 Bug #6377: Problem with length of number of the variables

From: 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.

« previous php.dev (#30814) next »