why code not working?

[Manat]

Hi All,

I got a flash file calling a PHP file, this is my php code:

<?
$sql = mysql_query("SELECT requests FROM tableName");
$result = mysql_query($sql) or die(mysql_error());

$row = mysql_fetch_array($result);
$requests = $row2['requests'];

$requests=$requests++;
$sql2 = "UPDATE tableName SET requests = $requests";
$result2 = mysql_query($sql2) or die(mysql_error());
?>

Why isn't working, I php included my DBinfo connection strings.
I get no errors and no DB updates, nothing is working.

Any IDea why?

Thx

[laserlight]

$requests = $row2['requests'];

maybe that should be

$requests = $row['requests'];

instead?

btw,
$requests=$requests++;
probably should be
$requests++;

[AshtrayWaterloo]

Also, try this:

Instead of this: $row = mysql_fetch_array($result);
Try this: $row = mysql_fetch_assoc($result);

Ash