MySQL Noob question - Query Not Inserting PHP Post Variables

Squirreliness

Okay. I've worked on this forever and I still can't figure out what's wrong with it...
Most likely it's something really simple, but I never notice it :eek:

Goal - Users being able to update profile pages, ect
Problem - PHP variables not inserting into database (database value reverts to default or '0')

Code
tank.php (parts of code, I'm not copying all of it 😛)

  echo "<form method='post' action='tank.php?id=".$id."&update=true'>Display Name <input type='text' name='display_name'>";
  echo "<br><textarea rows='12' name='page' cols='50'>".$row5['page']."</textarea>";
  echo "<br><input type='submit' value='Update'></form>";

Explanation - This is the form that variables will be entered in

if(isset($update)){
  mysql_query("UPDATE players SET display_name='$display_name' AND page='$page'")or die(mysql_error());

}else{
  echo "";
}

Explanation - MySQL query, I'm positive I have the correct table names and stuff.

AH! I know it looks really simple (I have no idea why -I- can't fix it O.O) but I just am a noob. heh.

If you need any more code or information, feel free to comment, also, if my [weak] system needs a little refining, I'd love to see a comment.

-Squirrel
(yay my first post! 🙂)

Roger_Ramjet

Oh dear, not another outdated php book. I'll bet it's SAMS :eek:

There is everything wrong with your code. Luckily you are just starting out and the bad habits should be easy to break.

1 You are mixing GET and POST vars in that form. Don't whatever the provocation.

2 You are coding for Register Globals ON. Just don't do that. To access the form data you write

if (isset($_POST['update'])) {
   $update = $_POST['update']
}

I could go on and on but best thing for you would be to go away and read Paul Hudson's excellent tutorial then start over.

Squirreliness

Ahh. x.x
Heh. That's what you get from learning online :o :eek:

Thanks for the link! I'll make sure and click it and read..it? (hopefully, lol)