Forums
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>
<?
$torre = $_REQUEST[['torre'];
$numDepto = $_REQUEST['numDepto'];
$id = $_REQUEST['id'];
?>
<?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);
?>
<p><?php echo $_REQUEST['torre']; ?></p>
<p><?php echo $_REQUEST['numDepto']; ?></p>
<p><?php echo $_REQUEST['id']; ?></p>
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