inserting blank row into csv export

[msimonds]

I am trying to insert a blank row into a CSV export and the export is not writing anything at all

I am sure that I am not formatting the line correctly:

Before adding the line to insert:

$sql = "SELECT ";
$sql .= 'Contact_Id as "Contact ID",';
$sql .= 'Company_Id as "Account ID",';
$sql .= 'Last_Name as "Last Name",';
$sql .= 'First_Name as "First Name",';
$sql .= 'Title as "Salutation",';

after

$sql = "SELECT ";
$sql .= 'Contact_Id as "Contact ID",';
$sql .= 'Company_Id as "Account ID",';
$sql .= 'as "Inserted Name",';  // this is the line that I am trying add to the CSV export for the blank column
$sql .= 'Last_Name as "Last Name",';
$sql .= 'First_Name as "First Name",';
$sql .= 'Title as "Salutation",';

I have tried these different lines and it still doesn't work:

$sql .= 'as "Inserted Name",';
$sql .= '  as "Inserted Name",';
$sql .= '"" as "Inserted Name",';
$sql .= '' ' as "Inserted Name",';

any help would be appreciated

Thanks
Mike

[zabmilenko]

What are you "as"ing ?

You use the keyword "as" to assign an alias to a table or field name:

Examples:

tablename AS tb1
username_field AS user
password_field AS pass

Without the original and valid table and field name, the AS command doesn't assign the alias to anything, which doesn't make sense.

What is the blank spot for? What other fields could it contain? Please be specific.

[Piranha]

If I understand you right you want an empty column returned form the database. I don't understand why, and I don't know for sure if it works but you can try the below:

$sql .= NULL 'as "Inserted Name",';