updating a mysql row

[Imad]

Hi guys, I forgot how to update a mysql row. E.G: editing text that has already been inserted into the MySQL database.

Best Regards.

 

EDIT: Just remembered.

[discomatt]

Google.

[revraz]

Google "UPDATE mysql"

[discomatt]

Sorry for the harshness of the above post

 

$q = "UPDATE `table` SET `col` = 'data' WHERE `id` = " . (int)$id .";

if ( mysql_query($q) == FALSE ) {
    echo 'Could not update row...';
    # Debug
    # echo '<br>' . mysql_error();
    # echo '<br>' . $q;
}