Forums

PHP

This topic is locked

update mysql filed PROBLEM

Posted 07 Jul 2008 17:33:33
1
has voted
07 Jul 2008 17:33:33 Jaime Romo posted:
i have a problem whit this,.
im sending 2 variables from flash to a php page that has to update some fileds on the data base.
the flash button send this:
on (release) {
numDepto = 201;
tower= "A";
getURL ("clicks.php", "_blank", "POST";
}

<b><font size=4>and the php page has this script</font id=size4></b>

&lt;?
$torre = $_REQUEST[['torre'];
$numDepto = $_REQUEST['numDepto'];
$id = $_REQUEST['id'];
?&gt;


&lt;?php
$con = mysql_connect("marala","xxxxxx","xxxxxx";
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("my_db", $con);

mysql_query("UPDATE maralaTorres SET clicks=clicks+1 WHERE torre ='$torre' AND numDepto = '$numDepto'";
mysql_close($con);
?&gt;

&lt;p&gt;&lt;?php echo $_REQUEST['torre']; ?&gt;&lt;/p&gt;
&lt;p&gt;&lt;?php echo $_REQUEST['numDepto']; ?&gt;&lt;/p&gt;
&lt;p&gt;&lt;?php echo $_REQUEST['id']; ?&gt;&lt;/p&gt;

can any one help me figuring this out what is wrong with my php script that it doesnt update the field on table.

THANKS





Visit my home page
www.cancuncoral.com

Reply to this topic