PHP and forms

[runar56]

Hi,

I'm trying to edit values of a row through html forms. ALthough when I submit the changes, nothing happens. This is the execution script:

<?php
include "common_db.php";
db_connect('****');
mysql_select_db('****');
if($_POST['submit']) 
{
$pageid = $_POST['pageid'];
$pagename = $_POST['pagename'];
$pagecontent = $_POST['pagecontent'];
$pageurl = $_POST['pageurl'];
$pagemenu = $_POST['pagemenu'];
$query = "UPDATE content SET page_id = '$pageid', page_name = '$pagename', page_content = '$pagecontent', page_url = '$pageurl', display_menu = '$pagemenu'  WHERE page_id = '$pageid'";
}

echo "Query finished!";


?>

However the row I'm trying to edit doesn't change at all. I don't know what's wrong. Please help?

Thanks

[chyan]

<?php 
include "common_db.php"; 

$host="yourhostname";
$user="yourDBusername";
$password="yourDBpassword";
$db="database_to_use";

$conn=mysql_connect($ host,$user,$password);
mysql_select_db($conn,$db); 
if($_POST['submit'])  

{ 
$pageid = $_POST['pageid']; 
$pagename = $_POST['pagename']; 
$pagecontent = $_POST['pagecontent']; 
$pageurl = $_POST['pageurl']; 
$pagemenu = $_POST['pagemenu']; 
$query = "UPDATE content SET page_id = '$pageid', page_name = '$pagename', page_content = '$pagecontent', page_url = '$pageurl', display_menu = '$pagemenu'  WHERE page_id = '$pageid'"; 
if (!mysql_query($query,$conn))
{
echo mysql_error();
exit;
}

echo "Query finished!"; 
}

?>