modify row

[fluppet]

Hi!

Im writing new scripts for my site, i bought a couple of books on php, and its going well - i need a bit of help though.

I am using a user system, with four levels, 1, 2, 3, and 4. These are stored under column "level" under table "login" i want to make a little script which allows a user to modofy anothers level:

would this be ok for the query? i have a form on the previous page, which uses a text field named "usertomodify", and an option box with the values 1, 2, 3, and 4. This is named "select"

$sql="alter table `table` modify `level` where username=\"$usertomodify\"

I somehow need to add "alter table table modify level -- modify level to the value from $select--

How do i do this? thanks for your help.

[laserlight]

ALTER should be used to alter the table specifications, i.e. add/delete/rename columns etc.

I think what you want is UPDATE
e.g.
UPDATE users SET level='$new_level' WHERE username='$usertomodify'

[fluppet]

Thank you very much - your very helpful. keep it up!

[fluppet]

by the way, where can i find a list of MySQL querys?

[fluppet]

Whats wrong with this?

This is the form for changing the details:

<form action="members-admin.php" enctype="multipart/form-data" method="post">
<strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Modify
</font>
</strong>&nbsp;                             

<input value="username" type="text" name="usertomodify">        &nbsp;<font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>to level</strong></font>&nbsp;     <select name="new_level">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>
<input type="submit" name="Submit" value="go">
</form>

and this is the members-admin.php file::

<?php    

//connect to MySQL  

$conn = @mysql_connect("localhost", "fluppet123", "FLP795PP")
              or die("could not connect to database");    

//select database  

$rs = mysql_select_db("test", $conn)
              or die("could not connect");  

//Query::  

$sql="UPDATE `users` SET `level`=\"$new_level\" WHERE username=\"$usertomodify\""    

//execute!  

$rs=mysql_query($sql,$conn);    

?>

It gives me a parse error on line 22 of members-admin.php - thats $rs=mysql_query($sql,$conn);

Thanks

[Weedpacket]

Originally posted by fluppet
by the way, where can i find a list of MySQL querys?

http://www.mysql.com/documentation/index.html perhaps?

[Weedpacket]

Originally posted by fluppet
Whats wrong with this?

It gives me a parse error on line 22 of members-admin.php - thats $rs=mysql_query($sql,$conn);

Thanks

Look at the end of line 21 - there's a ; missing.

[fluppet]

Thankyou - worked it out somehow before you got chance to reply

How do i display if a query has succeded?

I can do or die("");

but what about if it dosent die?

//execute query  

$rs=mysql_query($sql,$conn)  

or die("could not change user status!!!!");

[batman]

Try this:

//execute query   

$rs=mysql_query($sql,$conn);
if(!$rs)
{
echo "could not change user status!!!!";
} 
else
{
echo "successfully changed user status!";
}

[fluppet]

thankyouu!

[fluppet]

Whats the sql query to remove a row from a table please, anyone?

[batman]

Not sure what you mean by row, but this will delete a field:

$sql = mysql_query("ALTER TABLE table DROP fieldname");

This will delete a row:

$sql = mysql_query("DELETE FROM table WHERE var='$var'");