[RESOLVED] adding NOW() to sql

[dakey]

Hi this is the last query for a while! i had someone on here help me write the following sql:

INSERT into invoices (company,firstname,lastname,email,address1,address2,town,city,county,country,postcode) SELECT company,firstname,lastname,email,address1,address2,town,city,county,country,postcode FROM `clients` WHERE id = '$_POST[id]'

however to this i would like to add to the 'date' column' in the 'invoices' table NOW()

is this possible?

thanks

[Weedpacket]

INSERT into invoices
	(company,firstname,lastname,email,address1,address2,town,city,county,country,postcode,`date`)
SELECT
	company,firstname,lastname,email,address1,address2,town,city,county,country,postcode,NOW()
FROM `clients` WHERE id = '$_POST[id]'