[neex1233]

This script that I made updates MySQL through a form. Here's my code:

PHP Code:

    <?php
    error_reporting(E_ALL);
    ini_set("display_errors", "on");
    $con = mysql_connect("localhost","My_Username","Password");
    mysql_select_db("My_Database", $con);
    $sql = "UPDATE users SET username = '{$_POST['username']}',password = '{$_POST['password']}',userlevel = '{$_POST['userlevel']}'
    WHERE id = 23
    LIMIT 0";
    mysql_query($sql) or die (mysql_error());
    ?>

It's supposed to update the userlevel and password values in the table 'users', but it never works! Here's the form:

HTML Code:

    <form enctype="multipart/form-data" action="adm.php" method="POST">
    Username to edit:<br> <input type="text" name="username"><br />
    New Password:<br> <input type="text" name="password"><br />
    Userlevel:<br> <input type="radio" name="userlevel" value="1" /> 1
    <input type="radio" name="userlevel" value="2" /> 2
    <input type="radio" name="userlevel" value="3" /> 3
    <input type="radio" name="userlevel" value="4" /> 4
    <input type="radio" name="userlevel" value="5" /> 5
    <br>
    <input type="submit" name="edit" value="Update"></form>

I think it might be the button, but I doubt it. Please help! I've tried so many different things! Thanks!

[Nico]

Not sure how this actually behaves, but:

PHP Code:

" ... LIMIT 0"; 

... would limit the number of rows to update to 0. Try LIMIT 1.

[neex1233]

It still doesn't work.

[mdhall]

PHP Code:

$sql = "UPDATE users SET username = '($_POST['username'])',password = '($_POST['password'])',userlevel = '($_POST['userlevel'])'
    WHERE id = '23'"; 

You can also remove the enctype from your form, not sure you need it for the form fields you're using.

[neex1233]

The sql variable you made just gave me a syntax error. Is the button right, because I think there might be a problem with it.

[mdhall]

Try this ....

PHP Code:

    <?php
    $username = $_POST['username'];
    $password = $_POST['password'];
    $userlevel = $_POST['userlevel'];
    error_reporting(E_ALL);
    ini_set("display_errors", "on");
    $con = mysql_connect("localhost","My_Username","Password");
    mysql_select_db("My_Database", $con);
    $sql = "UPDATE users SET username = '$username', password = '$password', userlevel = '$userlevel'
    WHERE id = '23'";
    mysql_query($sql) or die (mysql_error());
    ?>

[neex1233]

No, doesn't work. Is there some kind of service that I have to turn on?

[Nico]

Do you get any errors? Or just a blank page?

Is there actually a row in the database with the ID = 23