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]
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
Bruce Gilbert wrote:
for the table name you mean like this?
$table_name =" 'Contact List' ";
No, backticks. I gave an example of the backtick in my email (in
brackets). It is on the same key as the tilde, and looks like this: `
Also, I would probably left $table_name as it was and put the b
for the table name you mean like this?
$table_name =" 'Contact List' ";
On 11/13/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
> Bruce Gilbert wrote:
> >> You would need to show us the SQL that was causing that error. Otherwise
> >> it is fairly meaningless.
> >
> > hope this helps...
> >
>
Bruce Gilbert wrote:
You would need to show us the SQL that was causing that error. Otherwise
it is fairly meaningless.
hope this helps...
Unrelated, but you should have quotes here. Like $_POST['f_name']
header("Location:http://www.inspired-evolution.com/show_addcontact.php";);
>You would need to show us the SQL that was causing that error. Otherwise
>it is fairly meaningless.
hope this helps...
http://www.inspired-evolution.com/show_addcontact.php";);
exit;
}else {
//if form variables are present,start a session
session_start();
}
//check for v
6 matches
Mail list logo
