[alirezaok]

hello

this:

$Query = 'SELECT * '
. ' FROM `datas` '
. ' WHERE 1 AND `date` >= '2003-08-07' && `date` <= '2003-08-09' LIMIT 0, 30';
>>>>>>WORKS

but this:

$jsdate=2003-08-07;
$jedate=2003-08-09;
$Query = 'SELECT * '
. ' FROM `datas` '
. ' WHERE 1 AND `date` >= '$jsdate' && `date` <= '$jedate' LIMIT 0, 30';
>>>>>>Not Works

Whyyyy?

[YourPHPPro]

After

PHP Code:

$Query = 'SELECT * '

. ' FROM `datas` '

. ' WHERE 1 AND `date` >= '$jsdate' && `date` <= '$jedate' LIMIT 0, 30'; 

put

PHP Code:

print $Query; 

and I'm sure it would be obvious what is going on...

[Chroder]

You've got your stirngs screwed up a little bit. Try this

PHP Code:

 $Query = 'SELECT * '

. ' FROM `datas` '

. ' WHERE 1 AND `date` >= '.$jsdate.' && `date` <= '.$jedate.' LIMIT 0, 30'; 

Hence the dot operator by the variable $jsdate.

[YourPHPPro]

Originally Posted by Chroder

You've got your stirngs screwed up a little bit.

Is this also correct from your previous post ?

PHP Code:

$jsdate=2003-08-07;

$jedate=2003-08-09; 

[alirezaok]

thanks of all

my problem slove with it:

$Query = "select * from datas where 1 and date >= '$jsdate' AND date <= '$jedate' LIMIT 0, 30";

good luck