RE: [PHP] Stumped @ MySql insert query
| From: | Jay Blanchard | Date: | Fri, 13 Jun 2003 18:23:04 +0000 |
| Subject: | RE: [PHP] Stumped @ MySql insert query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-151397@lists.php.net to get a copy of this message | ||
[snip]
$sql1 = "INSERT INTO
contacts
VALUES (
$_POST['company'],
$_POST['pri_name'],
$_POST['sec_name'],
$_POST['assistant_1'],
$_POST['assistant_2'],
$_POST['pri_practice'],
[/snip]
$sql1 = "INSERT INTO contacts (you, should, have, some, column,
names, here, in parentheses)
VALUES (
'" . $_POST['company'] . "',
'" . $_POST['pri_name'] . "',
'" . $_POST['sec_name'] . "',
'" . $_POST['assistant_1'] . "',
'" . $_POST['assistant_2'] . "',
'" . $_POST['pri_practice'] . "',
etcetera
HTH!
Jay