Overwriting Data

[rapmonkey]

Say I have information in a table. The information columns are named data and info. How can I over write the data in that row, replacing it with new data?

[elfynmcb]

Hey,

You'll have to do that with a mysql_query() using the UPDATE statement. search www.google.com for "sql update tutorial"

[rapmonkey]

I know I have to use update, but its not working.

[elfynmcb]

Well,

That would suggest that the syntax of the query was wrong or that you do not have the update grant permission in mysql.

Does your query look like this???

UPDATE db_name.table_name SET column_name='column_value' WHERE other_column_name='other_column_value'

[rapmonkey]

Here is the code I have after connecting to the database:

<?php
$query = "UPDATE reviews SET review = '$review' WHERE codename = '$codename'";

$result = MYSQL_QUERY($query);

MYSQL_CLOSE();

echo "The review was successfully edited, then added to the game database.";
?>

[elfynmcb]

Hey,

Your code should looklike this:

<?php

$query = "UPDATE reviews SET review='$review' WHERE codename='$codename'";
$result = mysql_query($query);
if( ! $result )
{
    die("warning: query failed");
}
else
{
    echo "The review was successfully edited, then added to the game database.";
    mysql_close($your_connection_link_name);
}


?>