[SOLVED] Uknown error:

[mikelmao]

I made a small system wich updates users info.. Well it wont go in the DB .. .. Whts my what can i do :/?

(CODE:)

                  <?php
                      include 'connect.php';
                      if(isset($_SESSION['admin']))
                      {
                        if($_SERVER['REQUEST_METHOD'] == 'POST')
                        {
                        mysql_query("UPDATE users SET `order`='". $_POST['ord'] ."' AND `admin`='". $_POST['admin'] ."' WHERE id='". $_POST['idz'] ."'") or die("Mysql Query Error: " . mysql_error());
                        echo "User: ". $_POST['unamez'] .". Please wait to be redirected.";
                        echo "<meta http-equiv=Refresh content=3;url='info.php'>";
                        }
                        else
                        {
                        $a = mysql_query("SELECT * FROM users WHERE id=". $_GET['user'] ."");
                          while($r = mysql_fetch_array($a))
                          {
                            echo "<form action='edit.php' method='post'>
                                            <input type='hidden' name='idz' value='". $_GET['user'] ."'>
                                  Username: <input type='text' name='unamez' value='". $r['uname'] ."' readonly><br>
                                  Order: <select name='ord'>
                                        <option value='0'>Pending</option>
                                        <option value='1'>Approve</option>
                                        <option value='2'>Decline</option>
                                        </select><br>
                                  Power: <select name='admin'>
                                        <option value='0'><font color='orange'>Normal User</font></option>
                                        <option value='1'><font color='green'>Admin</font></option>
                                        </select><br>
                                  <input type='submit' value='Update User'>";
                          }
                        }
                      }
                      else
                      {
                        echo "You need to be admin to view this page.";
                      }
                      ?>

[NathanLedet]

<input type='hidden' name='idz' value='". $_GET['user'] ."'>

 

can you echo that out and tell us what that says?

 

I'm thinking, if you switch up your quotes for the value, that may help.

 

 <input type='hidden' name='idz' value="'. $_GET['user'] .'">;

[mikelmao]

nope

And it echo's the id of the user in the URL.. So its does what its supose to..

[Jabop]

You shouldn't post the same question in multiple forums. You could start by not just saying 'help it won't work what do i do.'

 

Show us your error message.

[mikelmao]

there is no error :/

[Jabop]

mysql_query("UPDATE users SET `order`='". $_POST['ord'] ."',`admin`='". $_POST['admin'] ."' WHERE id='". $_POST['idz'] ."'") or die("Mysql Query Error: " . mysql_error());

[timmah1]

Why not just write this

mysql_query("UPDATE users SET `order`='". $_POST['ord'] ."' AND `admin`='". $_POST['admin'] ."' WHERE id='". $_POST['idz'] ."'") or die("Mysql Query Error: " . mysql_error());

 

as this

mysql_query("UPDATE users SET `order`='". $_POST['ord'] ."', `admin`='". $_POST['admin'] ."' WHERE id='". $_POST['idz'] ."'") or die("Mysql Query Error: " . mysql_error());