Re: Why won't this query go through?

Jochem Maas wrote:

Tijnema ! wrote:

On 3/11/07, Mike Shanley <thebarmy@omniversalism.com> 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/