How do I comment out SQL query

PHP
1

Hi,
How do I comment out SQL query in a php page…? for instance,

I tried /*… */ but it doesnt work so I think it must be wrong then?

$sql_query ="
INSERT INTO root_contacts_cfm(
	/*
	cnt_firstname,
	cnt_lastname,
	cnt_organisation,
	cnt_address,
	cnt_postcode,
	cnt_telephone,
	*/
	cnt_email1,
	cnt_email2,
	cnt_comments,
	cnt_key,
	cnt_created
)
VALUES (
	/*
	'$cnt_firstname',
	'$cnt_lastname',
	'$cnt_organisation',
	'$cnt_address',
	'$cnt_postcode',
	'$cnt_telephone',
	*/
	'$cnt_email1',
	'$cnt_email2',
	'$cnt_comments',
	'$cnt_key',
	NOW()
	)
";

many thanks,
Lau

2

why do you say that it doesn’t work? what happens?

is there a syntax error? what might it be?

3

Double-dash on each line.

My search terms: sql comment.

4

According to the manual, your example is spot on for multi-line comments.

5

sorry it works actually with this for the multiple lines comment /*… */

i tested on a wrong file :stuck_out_tongue:

6

thank you. it works now. thanks for the info. very helpful. :smiley:

7

thanks for the tips. thank you. :smiley: