increasing a variable by one

[cliftonbazaar]

At the moment I have lots of code that look like this

$temp=$player['matchesPlayed']+1;
$sqlPlayer .= " matchesPlayed='{$temp}', ";

to increase a variable in the database by 1, as I have to increase a lot of variables is there a better way of writing this?

I first tried

$sqlPlayer .= " matchesPlayed='{$player['matchesPlayed']++}',

but it didn't work

[jskywalker]

why did you use the '{}' in this:

$sqlPlayer .= " matchesPlayed='{$player['matchesPlayed']++}',

try:

$sqlPlayer .= " matchesPlayed='".$player['matchesPlayed']++."',"

[trq]

why did you use the '{}' in this

 

Because complex variables (eg; arrays) should be surrounded by braces when within strings.

 

Anyway, you can simply update records and increase there value without having to execute a SELECT query first (which it appears you are doing)

 

$sqlPlayer .= " matchesPlayed=matchesPlayed+1";

[cliftonbazaar]

Thanks for that thorpe, worked an absolute treat and I knocked out about a third of the code in that section - works a lot faster now that I don't have to use a SELECT first as well