Jochem Maas wrote:
Tijnema ! wrote:
On 3/11/07, Mike Shanley <thebarmy@xxxxxxxxxxxxxxxxx> wrote:
Hi,
I am just not understanding what I could have possibly done wrong with
this query. All of the variables are good, without special characters in
any sense of the word... So why isn't it importing anything?
Thanks!
$q = "INSERT INTO
`visitors`(`username`,`password`,`email`,`firstname`,`lastname`,`birthdate`,`verifythis`)
VALUES ('".$username."',
'".md5($password1)."',
'".$email."',
'".$firstname."',
'".$lastname."',
'".$birthdate."',
'".$verifythis."');";
Haven't you converted all of your columns to literals: 'username', etc,
which should be plain username?
I find it's clearer to use the heredoc syntax:
$query= <<<QUERY
INSERT INTO visitors (username,password,email,firstname,lastname. . . etc)
VALUES($username,$password,$email . . . etc )
QUERY;
_____________________
Myron Turner
http://www.room535.org
http://www.bstatzero.org
http://www.mturner.org/XML_PullParser/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
