Updating database

[Anon]

Does this code look right.
Could not execute query please contact administrator.

I know where that is I just cant fine out whats wrong.

<?
include("config.php");
$connection = mysql_connect ($host, $username, $pass) or die ("Could not connect to database please contact administrator.");
$db = mysql_select_db($db_name, $connection) or die("Could not select database please contact administrator.");
$sql = "SELECT * FROM home";
$result = mysql_query($sql, $connection) or die("Could not execute query please contact administrator.");
while ($row = mysql_fetch_array($result)) {
$content =$row['content'];
$display_block = "$content";
}
if ($mode=update){
$table_name="home";
$sql1="UPDATE $table_name SET (content) =('$text')";
$result = mysql_query($sql1, $connection) or die("Could not execute query please contact administrator.");
}
?>

[tomhath]

Are you sure you are querying the right database? I don't see you have a mysql_use_db (or whatever the function is, I don't have a manual handy).

[daynah]

$sql1="UPDATE $table_name SET (content) = ('$text')";

This line looks a bit funny to me. Maybe if you try taking out the parenthesis, it may work?

$sql1="UPDATE $table_name SET content = '$text'";

Everything else looks fine though. 🙂 I'm also wondering, do you want a WHERE clause at the end of the UPDATE statement?

[Anon]

What would the where clause say?

[Anon]

The where clause specifies which column cells to update...

UPDATE tbl_name expr1=value1 WHERE col1='something'

Will update all rows with column col1 values equal to something.

................................

My question though is where does the db actually get updated? Does something need to act on the result statement?

or would

$var = mysql_query(UPDATE...
mysql_result($var)

work???

[Anon]

I just answered my own question.......
All that is needed is to send the query statement with the UPDATE syntax.

$sqlconnection = mysql_connect "$system", "$user", "$dbpass");

mysql_select_db("$database", $sqlconnection);

$update = "UPDATE tablename SET col1='F' WHERE id=$id";

if (mysql_query($update, $sqlconnection)) {

print ("<h3>It has been removed:</h3>\n");

} else {

print ("<h3>It was NOT removed:</h3>\n");

}