[SOLVED] help plz...

[ronnie88]

Hi I need help again.... I know this is probley all wrong.....

<?php
session_start();
include 'database.php';
if(!strstr($_SERVER['HTTP_REFERER'],"virtualairlineonline.com/blue_sky/flying2h.php")) {
          echo "ERROR: YOU CANNOT ACCESS THIS FILE MANUALLY";
}
$cash = ({$row['cash']} + 600);

$query  = "SELECT cash FROM virtuala WHERE username='{$_SESSION['username']}'";
$result = mysql_query($query);

$query  = "UPDATE virtuala SET cash = '$cash' WHERE username = '{$_SESSION['username']}'";
mysql_query($query) or die('Error, query failed');
echo "$_SESSION[username] your virtual airline has been set to $va Press the back button";
?>

 

I'm trying to add 600 to the column cash any help would be great....

[Orionsbelter]

you should make your title more descriptive next time.

[Orionsbelter]

and whats the full query for $row?

[vbnullchar]

$query = "update virtuala SET cash=cash+600  " ...... ;

[Orionsbelter]

$cash = ($row['cash'] + 600);

[Orionsbelter]

$query  = "UPDATE virtuala SET cash = cash+600 WHERE username = '{$_SESSION['username']}'";

 

 

 

try that and post back

[ronnie88]

thanks very much works great