php - How can i put a single value in a single column with fputcsv -

php - How can i put a single value in a single column with fputcsv -

i want export info database csv file.

my php code this

$members = db::getresult('select * '.members_table_name.' order '.members_column_prefix.'_lastname, '.members_column_prefix.'_firstname'); $filename = "../db_user_export".".csv"; $handle = fopen($filename, 'w+'); fputcsv($handle, array_keys($members[0])); foreach ($members $member) { fputcsv($handle, $member); }//foreach fclose($handle);

now output in csv this:

"column a" "column b" "column c", "password,username,fistname", "lastname,updated" "loggedin,is_new"

but want this:

"column a" "column b" "column c", "password" "username" "firstname".

anyone knows how ?

do not utilize select * , instead select fields want

php mysql sql csv