|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull Requests |
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Nov 03 06:00:01 2025 UTC |
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.