Simple query but where is problem?

salac.r · #1 (**permalink**) 09-19-2007, 08:41 PM

Hi
I have simple query

PHP Code:


			
$q="SELECT *

FROM a 

LEFT JOIN b ON ida=idb

WHERE desc LIKE :rejected AND date :y 

ORDER BY :order";

$values=array(

':rejected' =>'rejected',

':y'=>'y',

':order' => $this->_request->getPost('order','date'),

);



$result=$db->query($q,$values);

And it simply don't work
It looks that first two params are qoted ok.
But the third one not because the result has alwas same order.
But if i do this

PHP Code:


			
$q="SELECT *

FROM a 

LEFT JOIN b ON ida=idb

WHERE desc LIKE :rejected AND date :y 

ORDER BY '".$this->_request->getPost('order','date')."'";

$values=array(

':rejected' =>'rejected',

':y'=>'y'

);

It works.Can somebody help me?
Thanks

PS: I apologize for my poor english

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode