[Aadhira]

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());

[Maciej Liżewski]

use queryScalar() instead of queryRow()

[Aadhira]

redguy, on 06 February 2013 - 04:17 AM, said:

use queryScalar() instead of queryRow()

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());

[fouss]

queryAll()

[Aadhira]

fouss, on 06 February 2013 - 05:15 AM, said:

queryAll()

<?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]

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>';
}

[Aadhira]

fouss, on 07 February 2013 - 04:29 AM, said:

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>';
}

Thanks a lot

[fouss]

that's free!