server-side formatter loop not showing last row

server-side formatter loop not showing last row

adam558adam558 Posts: 4Questions: 1Answers: 0
array( 'db' => '`s`.`nom`', 'dt' => 2, 'formatter' => function( $d, $row ) {
include('connect.php');
$id=$row[0];
                    $sqlg="SELECT s.nom as lenom FROM societe s,document_societe d where d.id_doc='$id' and s.id_soc=d.id_soc ";
                    $reqg= mysql_query ($sqlg) ;
                    $datag= mysql_fetch_array($reqg);
                    $lesoc='';
                    $nbr=mysql_num_rows($reqg);
                    $i=0;
                    while($datag= mysql_fetch_array($reqg)) 
                             {  $idn = $datag['lenom'];
                                $lesoc.=$i." <span class='label label-outline-success'>".$idn."</span><br/>";
                                $i=$i+1;
                             }

            return $lesoc;},'field' => 'lenom','as' => 'lenom' ),
This discussion has been closed.