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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu May 02 14:01:34 2024 UTC