when i enter only min value then it consider max as zero and return me null data

Question

When I enter only min value then it consider max as zero and return me null data

$min=$_REQUEST['min'];     
$max=$_REQUEST['max'];     
$q3="select * from product where '$min' < `price` < '$max'";    
$q=mysql_query($q3);

what do you mean null data? you haven't even fetched the rows yet. and please stop using `mysql_` functions. use mysqli or PDO instead with prepared statements — Kevin, Oct 31 '14 at 08:14
`when i enter only min value then it consider max as zero `: So when you dont provide max what should max be? — Hanky Panky, Oct 31 '14 at 08:14

Neeraj Verma · Answer 1 · 2014-11-04T09:32:55.043

0

If you do not provide value in your request, php will consider it as NULL. You should have to provide value every time or you can do this .

$min=$_REQUEST['min'];

$max=$_REQUEST['max'];

if(!$max){
   $max = 45; // or what ever value you like
}

$q3="select * from product where price > '$min' and price < '$max' ";

$q=mysql_query($q3);

edited Nov 04 '14 at 09:32

answered Oct 31 '14 at 08:16

Neeraj Verma

495
4
17

`$max you have backtick here, change it to single quete – arif_suhail_123 Oct 31 '14 at 08:18
i was talking about your query first you got backtiks in `$max` – arif_suhail_123 Oct 31 '14 at 08:19

score 0 · Accepted Answer · edited May 23 '17 at 12:25

0

Change the query by max value:

$min=$_REQUEST['min'];

$max=$_REQUEST['max'];

if( empty($max) )
   $q3="select * from product where price > '$min'";
else
   $q3="select * from product where price > '$min' and price < '$max' ";


$q=mysql_query($q3);

One more correction you should start using PDO . method your are using is depreciated.

Read This

edited May 23 '17 at 12:25

Community

1
1

answered Oct 31 '14 at 08:20

CS GO

914
6
20

when i enter only min value then it consider max as zero and return me null data

2 Answers2