[thelist] MySql Update Works sometimes?

[Joshua Hmielowski]

I have a php/mysql script updating my database.
By the act of some unforeseen greater force,
sometimes it works and sometimes it does not.
This has never happened to me before.

so basically I have this form where all of the information about this 
product is fed into
the input values from the database (works fine). If any values need 
updating, they can be
changed and submitted back to the DB via php/mysql UPDATE statement.
Now sometimes, I can go to this form, make changes and it updates just 
fine.
And sometimes It throws and error [no database selected].

I can go to one product, update it..and if throws an error, I can hit 
the back  button and submit it again,
and it work fine? I have done a var_dump() and all variables are 
getting passed no matter what happens
and the SQL is fine. I must be just missing something.
any thoughts?


Code:

// CONNECTION IS MADE VIA INCLUDE AND POPULATES FORM JUST FINE.

  if (isset($_REQUEST["job"]) && ($_REQUEST["job"] == "update_product")) 
{
	
  	$updateSQL = "UPDATE ".$_REQUEST['type']." SET 
id='".$_REQUEST['id']."', color='".$_REQUEST['color']."',  
size='".$_REQUEST['size']."', `vender#`='".$_REQUEST['vender#']."', 
series='".$_REQUEST['series']."', leadTime='".$_REQUEST['leadTime']."', 
items='".$_REQUEST['items']."', keywords='".$_REQUEST['keywords']."'  
WHERE number=".$_REQUEST['number']."";

   	$Result= mysql_query($updateSQL) or die(mysql_error());


echo $updateSQL;  // 	OUTPUT IS FINE.
echo "<br>";
echo $Result;  // 		WORK SSOMETIMES.
}



Joshua Hmielowski
---------------------------------
Independent Studio
[tel] 970-429-7469
[cel] 970-274-0870
www.independentstudio.net