trying to update the database

[amarafzal]

Hi All

Im trying to update the database from a form a user fills in. The user firsts selects the ID, it then takes them to a page where the form is filled in with there details. They can change details and when the y click on submit it takes them to another page where IT SHOULD UPDATE THE DATABASE. Im using the following code to update but doesnt work. Help anyone

  <?

$db_name = "web";
$table_name = "internal_vacancys";
$connection =/mysql_connect("df", "df", "df") or die(mysql_error());
$db =/mysql_select_db($db_name, $connection) or die(mysql_error());

$sql = "UPDATE $table_name SET contact_name='$contact_name', contact_telephone='$contact_phone', date_posted='$date_posted', job_title='$job_title', job_summary='$job_summary', person='$person', package='$package', location='$location', salary='$salary'";
echo "Thank you. The job $job_title has been updated.";
$result =/mysql_query($sql,$connection) or die(mysql_error());
}
?>

[eoghain]

First off what is with the =/ before you mysql calls? Are you trying to supress errors? If so the proper syntax is = @mysql_???(). The @ symbol before the function name suppresses errors.

Next your query is written to update every record in the given table. Where is your WHERE clause? Without it all records will be updated with the given information.

Finally are you getting any errors or just a blank page, if you are getting errors you should include them in your question, and never supress errors until you are putting your code into production.