Hello,
Did you control your user privileges? May be, your database user
don't have enough privileges for INSERT. If your database user have enough
database privileges for INSERT, you must control your SQL. Firstly you
should write your SQL to the screen with echo ($q) and then paste this in
the mysql command line. If you get an errors, there is a problem on your
SQL. :)
--
Haydar TUNA
Republic Of Turkey - Ministry of National Education
Education Technology Department Ankara / TURKEY
Web: http://www.haydartuna.net
"Mike Shanley" <thebarmy@xxxxxxxxxxxxxxxxx> wrote in message
news:45F42D52.2050408@xxxxxxxxxxxxxxxxxxxx
> 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);
>
> --
> Mike Shanley
>
> ~you are almost there~
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
