update table join

[dflow]

i wrote this script

 

for some reason it's not executing after submitting

<?php $ProposalID = $_GET['PropID'];
$con = mysql_pconnect($hostname_international, $username_international, $password_international);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
if (isset($_POST['submit'])) {
mysql_select_db("international", $con);
$query="UPDATE proposals, contact_form
     SET contact_form.StatusID =6, proposals.StatusID=6
       WHERE proposals.RequestID = contact_form.RequestID
        AND proposals.ProposalID = '$ProposalID'";


$update_tables_action = mysql_query($query) or trigger_error(mysql_error(),E_USER_ERROR);
echo "POST: <BR>";

}
?>

[Muddy_Funster]

is proposalID a varchar or an int? and does it have a valid value in it when you echo it out?

[dflow]

is proposalID a varchar or an int? and does it have a valid value in it when you echo it out?

 

it is an int and it gets the url parameter

[dflow]

strange aint it?

[mattal999]

Does the form have an image button or a submit button with the name "submit". If it has an image button, then x and y values are passed. If it is a submit button, but has no name then $_POST['submit'] will not be passed.

[Muddy_Funster]

As it's an int unquote it in the update query.  you are basicly telling the query the input is a string, and then trying to compare that to a coluim in your database that you have told the database isn't allowed string values in the first place.