Re: Why won't this query go through?

"Tijnema !" <tijnema@xxxxxxxxx> · Sun, 11 Mar 2007 17:38:25 +0100

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."');";
mysql_query($q);

* me is gettings crazy!!! ALWAYS USE THE MYSQL_ERROR COMMAND!
mysql_query($q);
becomes
mysql_query($q) or die(mysql_error());
then post the result of the error, or fix it by yourself when you know where
the error is.

Tijnema

--
Mike Shanley

~you are almost there~

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php