On Fri, Feb 6, 2009 at 13:03, Jochem Maas <jochem@xxxxxxxxxxxxx> wrote: > > there are a zillion variations on this theme (e.g. using HEREDOC syntax and/or putting each field & value That's right, when reading the OP's email, there was meant to be a #4 as well. 4.) Use HEREDOC syntax: <?php $sql =<<<SQL INSERT INTO table_name(column_a,column_b,column_c) VALUES('{$value_a}','{$value_b}','{$value_c}') SQL; ?> -- </Daniel P. Brown> daniel.brown@xxxxxxxxxxxx || danbrown@xxxxxxx http://www.parasane.net/ || http://www.pilotpig.net/ Unadvertised dedicated server deals, too low to print - email me to find out! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php