Re: Why won't this query go through?

From: Date: Mon, 12 Mar 2007 09:11:23 +0000
Subject: Re: Why won't this query go through?
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-250273@lists.php.net to get a copy of this message
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@omniversalism.com> wrote in message news:45F42D52.2050408@omniversalism.com... > 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~

« previous php.general (#250273) next »