News:

Please note these forums are mostly a testing ground for my SMF work and I don't really use them otherwise.

Main Menu

Paste-1321995762:v:use_geshi-1:v:type-php

Started by Guest, Nov 22, 2011, 09:02 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

Guest

if($srchprice=="Any")
{$sprc="pprice LIKE '%'";}

if($srchprice=="100000")
{$sprc="pprice <= '100000'";}

if($srchprice=="250000")
{$sprc="((pprice >= '100000.01') && (pprice <= '250000'))";}

if($srchprice=="500000")
{$sprc="((pprice >= '250000.01') && (pprice <= '500000'))";}

if($srchprice=="750000")
{$sprc="((pprice >= '500000.01') && (pprice <= '750000'))";}

if($srchprice=="1000000")
{$sprc="((pprice >= '750000.01') && (pprice <= '1000000'))";}

if($srchprice=="99999999")
{$sprc="pprice >= '1000000.01'";}