php/mysql update variable by 1

RoyalMarine

trying to get mysql to update by +1 if a user uploads an image, or decrease by 1 if they delete an image etc.

$update = mysql_query("UPDATE uploaders SET image = image + 1 WHERE username = '$user'");

i have $user set as

$user = $_SESSION;

ive been using the $user variable on plenty of other pages and no problems there..

any suggestions?

RoyalMarine

been trying something different still with no luck yet.

$update = mysql_query("UPDATE uploaders SET image = image+1 WHERE id ='$_SESSION[id]'");

Webmonkey

What is the data type of the image column?

RoyalMarine

its in int(11) type

Webmonkey

Are you sure that $_SESSION exists.

Have you printed it out to see if so?

Maybe you are forgetting your session_start() at the top of your PHP file.

RoyalMarine

i have the session_start() in an include file.

in the same script, im using this
$foldername = $_SESSION;

and it works when i upload an image to a directory with $foldername in it.

Webmonkey

RoyalMarine wrote: »

i have the session_start() in an include file.

in the same script, im using this
$foldername = $_SESSION;

and it works when i upload an image to a directory with $foldername in it.

What's the actual error. Can you print out the mysql last error string.

RoyalMarine

thats the thing it doesnt give any error either

Adam

so what debugging have you done?

RoyalMarine

got it working with this

if (isset($_SESSION))

$update = mysql_query("UPDATE uploaders SET image =image+1 WHERE username ='$_SESSION[user]'");

Webmonkey

RoyalMarine wrote: »

got it working with this

if (isset($_SESSION))

$update = mysql_query("UPDATE uploaders SET image =image+1 WHERE username ='$_SESSION[user]'");

Well, in that case it couldn't have been set like I said above. You are hiding the problem there. I'd check your work flow/logic if I were you

RoyalMarine

yeah i found where i messed up. i was putting the sql statement above the if(isset) statement.