Help updating database

[Paws]

<form method="post" action="adminprocess.php">
      <label>Board Name
      <input type="text" name="forumname" value="<?php echo $info_r['forum_name']; ?>">
      </label>
        <p>
          <label>Board Description
          <input type="text" name="forumdescription" value="<?php echo $info_r['forum_description']; ?>">
          </label>
        </p>
        <p>
          <input type="submit" name="Submit" value="Submit">
        </p>
    </form>

 

$forumname = $_GET['forumname'];
$forumdescription = $_GET['forumdescription'];

$query = "UPDATE `info` SET `forum_name` = '$forumname' AND `info`.`forum_description` = '$forumdescription'";

mysql_query($query);

 

I'm using that code to update my database but it isn't working :/ Can anyone help?

[Bricktop]

Try:

 

$forumname = $_POST['forumname'];
$forumdescription = $_POST['forumdescription'];

$query = "UPDATE `info` SET `forum_name` = '$forumname' AND `info`.`forum_description` = '$forumdescription'";

mysql_query($query);

[phpSensei]

^^ EXPLAIN TO HIM WHAT HE DID WRONG!

 

<form method="post"

 

Your form method is post, thus you must get the HTTP POST VARS using $_POST....instead you were using $_GET

[Paws]

^^ EXPLAIN TO HIM WHAT HE DID WRONG!

 

<form method="post"

 

Your form method is post, thus you must get the HTTP POST VARS using $_POST....instead you were using $_GET

 

Thanks, god I feel like an idiot now -.-

[phpSensei]

^^ EXPLAIN TO HIM WHAT HE DID WRONG!

 

<form method="post"

 

Your form method is post, thus you must get the HTTP POST VARS using $_POST....instead you were using $_GET

 

Thanks, god I feel like an idiot now -.-

 

Don't worry lol, we all make mistakes, and thank Bricktop for fixing it for ya.

[Paws]

Ok, i've got a different problem now, when ever the user submits the forum it always puts the value as 0 in the database? :/

[phpSensei]

Ok, i've got a different problem now, when ever the user submits the forum it always puts the value as 0 in the database? :/

 

whats the column data type?

[Paws]

Text

[Paws]

Bump

[Paws]

Bump

[gevans]

Before you do the mysq_query() output the query variable to see if it's what you expect it to be;

 

$forumname = $_POST['forumname'];
$forumdescription = $_POST['forumdescription'];

$query = "UPDATE `info` SET `forum_name` = '$forumname' AND `info`.`forum_description` = '$forumdescription'";

echo $query;

mysql_query($query);

[Paws]

Yeah, its what it should be

[phpSensei]

Yeah, its what it should be

 

mysql_query($query);

 

that should be in a variable. You are echoing the mysql query, it has to be printed out using mysql_fetch_array, or mysql_fetch_assoc or mysql_fetch_object....or...etc

[gevans]

Yeah, its what it should be

 

Can you post it, it's hard to help when you don't show what you're getting.

[Paws]

UPDATE `info` SET `forum_name` = 'forum' AND `info`.`forum_description` = 'description'

[gevans]

If you're doing an update you need a WHERE clause so you know what one you're updating. Otherwise it will try and update the whole table.