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