Syntax Question 1

[pollock77]

I'm not sure why this code isn't working.

  $data="('$_POST[username]', '$_POST[PASSWORD]', '$_POST[handle]', '$_POST[rank]', '$_POST[group]', '$_POST[gender]', '$_POST[av]')"
   $result3 = mysql_query("INSERT INTO users $data")
   or die(mysql_error()); 
   echo "Account successfully updated. Click [<a href='editor.cgi'>here</a>] to go back.";

I get this error:

Parse error: parse error, unexpected T_VARIABLE in /home/pollock7/public_html/new/editor.php on line 73

I'm not sure if I've looked at one too many semicolons or if I'm messing up some syntax, but can someone help?

 

[Wishdiak]

pollock77,

Just casually looking at it, I'd try it as:

  $data="('$_POST[username]', '$_POST[PASSWORD]', '$_POST[handle]', '$_POST[rank]', '$_POST[group]', '$_POST[gender]', '$_POST[av]')";

Wishdiak

http://www.wishdiak.com

 

[pollock77]

Yes, that helps, but now I'm ending up with an SQL error in syntax.

 

[Wishdiak]

pollock77,

Try:

$result3 = mysql_query("INSERT INTO users VALUES ($data)")or die(mysql_error());

Wishdiak

http://www.wishdiak.com

 

[pollock77]

I did that and got this error:

Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'pass', 'Francis Spunkle', 'Admin', 'admin3', 'm', '

http://'))

 

[Wishdiak]

pollock77,

One last shot in the dark before I whip out an actual tree-book. I'd try:

$result3 = mysql_query("INSERT INTO users VALUES $data")or die(mysql_error());

Wishdiak

http://www.wishdiak.com

 

[pollock77]

Oh, thank you very much, it worked

 

[Wishdiak]

pollock77,

Glad to hear it. It's all in the syntax.

Wishdiak

http://www.wishdiak.com