UPDATE php function

[kickatruckx]

I am building a 'news' database and have all the forms coded, and the naviagtion. My add script is working just fine to add news to the database, and I can pull that information into a form again to edit, but my script to update the edited news is failing. Here it is:

<?

include('CONNECT.php');

$query  = "UPDATE tc_news SET headline='$headline', ";
$query .= "author='$author', ";
$query .= "modify_date=NOW(), body='$body', status='$status', ";
$query .= "WHERE id=$id";

if ( mysql_query($query) ) {
    header( "Location: listnews.php?message=News article updated." ); 
    exit();
}
header( "Location: listnews.php?message=Update failed: $query" );

?>

Any suggestions????

[planetsim]

Well are you getting any specific errors within the script. It maybe because your record hasnt been updated even though you may have pressed the update button. If the record is still the same it will return false as there were 0 rows required to be updated.

[kappaluppa]

I am trying to do exactly what you are saying you did: have a news section where I can submit info to a database, extract the data to fill forms for editing, and then update the database.

You got further than I did - I can only get the data to the data base. I need help with getting it out, editing it, then putting it back in.

Can you tell me how you extract the data into a form for editing?

Thanks,
K