update not working?

[john1704]

Why won't this mysql_query thing update what's in my database? BTW there is currently nothing in any field:

include "db_connect.php";
$update = $_POST['section1'];
mysql_query("UPDATE `sections` SET section1='$update'");

[Scriptmaker]

Add or die(mysql_error()); to the end to display any errors. Try again and post the error you receive.

I also added ECHO to the variable assignment. Make sure you are actually submitting data.

include "db_connect.php";
echo $update = $_POST['section1'];
mysql_query("UPDATE `sections` SET section1='$update'")or die(mysql_error());

Also, you need to give the query a WHERE statement. What other columns do you have in your db?

btw, if you are making a public script, using posted data to manipulate a db is very unsafe. If you haven't already, look into SQL Injection.

[john1704]

Ok don't worry I just made up those table names.

[roscor]

from www.mysql.com

For the single-table syntax, the UPDATE statement updates columns of existing rows in tbl_name with new values, see http://dev.mysql.com/doc/refman/5.0/en/update.html

basicaly you can only update an existing row so insert a nominal value first prior to the update query.