mercredi 25 mars 2015

alternative of mysql_result for mysqli or any other option [duplicate]


This question already has an answer here:




hello all i am migrating from mysql to mysqli and only issue till now i am having is finding the alternative of mysql_result function. i used mysqli_data_seek function but it is not giving me what i want


here is something that i use :



$countandget=mysql_query("select group_concat(distinct session_id)
from posts where comment !='' and onidis='3738'");
$NOTIFYALL121=mysql_result($countandget,0);
echo $NOTIFYALL121;
//it outputs like 1,2,3,4,5 whatever the user ids are


i have tried like :



$countandget=mysqli_query($conn,"select group_concat(distinct session_id)
from posts where comment !='' and onidis='3738'");
$NOTIFYALL121=mysqli_data_seek($countandget,0);
echo $NOTIFYALL121;
// it ouputs like 1


i want the comma separated values please let me know what should i do . as the matching rows may be more than 100, so i can not have loops...


Aucun commentaire:

Enregistrer un commentaire