ID: 6377
Updated by: [EMAIL PROTECTED]
Reported By: Bkrys at Ifrance dot com
-Status: Open
+Status: Closed
Bug Type: MySQL related
Operating System: Windows 98
-PHP Version: Earlier? Upgrade first!
+PHP Version: 3
Previous Comments:
------------------------------------------------------------------------
[2000-08-27 10:06:27] Bkrys at Ifrance dot com
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.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=6377&edit=1
