Aadhira
(Kalaimaruthalingam)
1
hi all ,i tried to get the result from the table MAIL using the below query ,but it gets displayed as a array ,how can i get it?
$connection=Yii::app()->db;
$sql = "SELECT Receiver from mail";
$command=$connection->createCommand($sql);
print_r($command->queryRow());
redguy
(Maciej Lizewski)
2
use queryScalar() instead of queryRow()
Aadhira
(Kalaimaruthalingam)
3
Thank you 
One more help,if i select * from mail what can i use instead queryScalar?
$connection=Yii::app()->db;
$sql = "SELECT * from mail";
$command=$connection->createCommand($sql);
print_r($command->queryScalar());
Aadhira
(Kalaimaruthalingam)
5
<?php
echo'Only First Row'. "</br>";
echo '-----------'. "</br>";
$connection=Yii::app()->db;
$sql = "SELECT * from mail";
$command=$connection->createCommand($sql);
print_r($command->queryAll());
echo "</br>";?>
</p>
had tried this,but gets the result as
Array ( [0] => Array ( [E_Id] => xx@gmail.com [Receiver] => david) )
i need the values alone to be displayed,can u help?
fouss
(Jsfousseni)
6
Try this my fiend!
echo'Only First Row'. "</br>";
echo '-----------'. "</br>";
$connection=Yii::app()->db;
$sql = "SELECT * from mail";
$command=$connection->createCommand($sql);
foreach ($command->queryAll()as $value) {
echo $value['E_id'].' '.$value['Receiver'].'</br>';
}