mysql php decrement issue

ChicoMendez

Hi, ive an issue decrementing a value i grab from a my sql table... can anyone see any thing wrong with this...




firrst i get the counter value (to be decremented)

$counter=0;
$query = "SELECT counter FROM guest_admin WHERE username = '" .$table. "'";
$req = mysql_query($query) or die (mysql_error()); 
if ($req > 0) {
$r = mysql_fetch_array($req);
$counter = $r['counter']s;
}

then inside a loop i decrement it

$counter = $counter--;

then after the loop i update the table:

$queryud = "UPDATE guest_admin SET counter='".$counter."' WHERE username = '" .$table. "'";
mysql_query($queryud) or die (mysql_error()); 
mysql_close();

Tnx

Webmonkey

$counter = $counter--;

I think you are going against the whole idea of the --. Basically thats there so as it is convienent for you not to have to go $var =, but instead say $var--

Your code should be just

$counter--;

Also

$counter = $r['counter']s;

I maybe not advanced and not understand this, but whats with the s?

Hope this helps someway

ChicoMendez

what was i thinking of

$counter--;

did the job!!

cheers

the s business was i typo---

Tnx

Webmonkey

No probs

ChicoMendez

1 other question for you.

is there any way i could decrement that counter in the mysql table without using php . ie just SQL .....

TNX