[SOLVED] formatting question

[gamesmstr]

I have a variable $type which is a string.  I am trying to update a db table where an element matches that string and increment it by 1.  I am using the following format.

 

mysql_query("UPDATE tablename set '$type'='$type'+1 where id = '$playerid'");

 

This format is not working and I suspect the culprit is the set '$type'='$type'+1.  Can anyone help me on how it should be formatted?

[wildteen88]

The format for your query should be

 

mysql_query("UPDATE tablename set column_name=column_name+1 where id = '$playerid'");

 

Does $type hold a column name?

[Mchl]

It's not clear what you want

 

Maybe this:

 

mysql_query("UPDATE tablename set 'type'='type'+1 where id = '$playerid'");

 

Or maybe this:

 

mysql_query("UPDATE tablename set 'type'=$type+1 where id = '$playerid'");

 

 

Does $type hold a column name?

 

Good question. Didn't think of that

[premiso]

You need to use backticks (`) around column names and single quotes(') around data.

 

mysql_query("UPDATE tablename set `$type`= ($type+1) where id = '$playerid'");

 

Also does $type hold a column name? (oh I see thats already been pointed out oh well.)

[gamesmstr]

The format for your query should be

 

mysql_query("UPDATE tablename set column_name=column_name+1 where id = '$playerid'");

 

Does $type hold a column name?

 

Yes, in string format.

[Mchl]

If there's column name in $type, then updating the column to its name +1 has little sense...

 

mysql_query("UPDATE tablename set `$type`=`$type`+1 where id = '$playerid'");

[gamesmstr]

If there's column name in $type, then updating the column to its name +1 has little sense...

 

mysql_query("UPDATE tablename set `$type`=`$type`+1 where id = '$playerid'");

 

Let me give an example

 

$type="cname";

 

I want the equivalent of

 

mysql_query("UPDATE tablename set cname=cname+1 where id = '$playerid'");

 

but using the $type variable.

[premiso]

$type_data = $type . "1";

mysql_query("UPDATE tablename set `$type`= '$type_data' where id = '$playerid'");

 

or

 

mysql_query("UPDATE tablename set `$type`= '" . $type . "1' where id = '$playerid'");

 

Should do the trick.

[Mchl]

The code I posted above should work.

[gamesmstr]

$type_data = $type . "1";

mysql_query("UPDATE tablename set `$type`= '$type_data' where id = '$playerid'");

 

or

 

mysql_query("UPDATE tablename set `$type`= '" . $type . "1' where id = '$playerid'");

 

Should do the trick.

 

What I am trying to do is update column $type with the value contained in that column + 1

 

[gamesmstr]

The code I posted above should work.

 

 

It did... Thanks!