Numerous syntax errors produce your invalid query...
1) If you use double quotes to enclose the string, "INSERT..., then you do
not have to delimit your single quotes.
2) You accidently delimit a variable at VALUES ('\$select
3) The SQL command its self does not need to end with a semi-colon.
Fixed string..
$sql = "INSERT INTO `guest`
(`title`, `first_name`, `last_name`, `login`, `password`,
`passport_number`, `e_mail`, `question`, `answer`,
`industry`, `job_title`, `state`, `city`, `company`, `last_visit`)
VALUES ('$select', '$f_name', '$l_name', '$login',
'$password', NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NOW())";
-Kevin
----- Original Message -----
From: "Pushpinder Singh Garcha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 1:30 PM
Subject: [PHP] PHP and MySQL
Hello,
I am using PHP to create forms and then am entering the user input into
a MySQL DB
In the first query I am trying to select the values that the user
entered on the form
THIS DOES NOT WERK.... gives error unable to execute query
$sql = "INSERT INTO `guest` (`title`, `first_name`, `last_name`,
`login`, `password`, `passport_number`, `e_mail`, `question`, `answer`,
`industry`, `job_title`, `state`, `city`, `company`, `last_visit`)
VALUES ('\$select\', \'$f_name\', \'$l_name\', \'$login\',
\'$password\', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NOW());";
WHEN I TRY TO HARD CODE THE VALUES INTO THE MYSQL QUERY, IT WERKS FINE
// $sql = 'INSERT INTO `guest` (`title`, `first_name`, `last_name`,
`login`, `password`, `passport_number`, `e_mail`, `question`, `answer`,
`industry`, `job_title`, `state`, `city`, `company`, `last_visit`)
VALUES (\'gh\', \'ghdfghhgj\', \'hgddj\', \'ggfgfg\', \'hfgdj\', NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NOW());';
Can somebody please tell me where I am going wrong..??
Many thanks
Pushpinder Singh Garcha
_________________________________
Web Architect
T. Falcon Napier and Associates, Inc.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
