php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #6377 Problem with length of number of the variables
Submitted: 2000-08-27 10:06 UTC Modified: 2005-09-02 07:58 UTC
From: Bkrys at Ifrance dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 3 OS: Windows 98
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: Bkrys at Ifrance dot com
New email:
PHP Version: OS:

 

 [2000-08-27 10:06 UTC] 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.


Patches

Pull Requests

 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Tue Jun 03 07:01:26 2025 UTC