Re: [PHP] Re: please shed some light on SQLsyntax error

2005-11-13 Thread Max Schwanekamp
Bruce Gilbert wrote: //build and issue query $sql = "INSERT INTO $table_name values ('', '$_POST[f_name]', '$_POST[l_name]', '$_POST[address1]', '$_POST[address2]', '$_POST[address3]', '$_POST[postcode]', '$_POST[country]', '$_POST[prim_tel]', '$_POST[sec_tel]', '$_POST[email]', '$_POST[birthday]

Re: [PHP] Re: please shed some light on SQLsyntax error

2005-11-13 Thread Stephen Leaf
I believe it's proper SQL syntax to use a double quote " tho for column names. I've heard of backtick working.. but in any example I've ever seen both in classes and on mysql and postgresql sites they always use "" I don't use `` so I'm not sure how widely they are accepted. Just ran a test in s