Help with PHPExcel Library and mySQL data from a table
- by user547363
Hello! Everyone..
I have this script
$query = "SELECT id,last_name,first_name FROM users WHERE tmima_id='6'";
$result = @mysql_query($query);
while($row = mysql_fetch_array($result))
{
$i = 3;
$emp_id = $row['id'];
$cell = 'A'.$i;
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue($cell, $row['last_name']. $row['first_name']);
$i++;
}
But in the .xls file it prints only one user. Why id doesnt print all of the users ? W
Thanks in advance.