[SOLVED] Simple MySQL "UPDATE" question.

[MasterACE14]

Evening Everyone,

 

I have a simple question, with the following query:

<?php
$sql = "UPDATE `cf_users` SET strikeaction = '$strike_action', defenceaction = '$defence_action', covertaction = '$covert_action' WHERE `id` = '$player_accountid';";

 

to update every account in my database would I simply remove the "WHERE" ?

 

Regards ACE

[Barand]

Yes. An UPDATE without a WHERE is applied to every row.

[MasterACE14]

ok, Thankyou barand, I have 1 more question. I have some code to workout what will be UPDATE'ed in every account, and I am wondering, how would I make it workout the correct values to input for each user.

 

Here's practically what I have(theirs more to it, but this is the actual part):

<?php
// Players Actions
$strike_action = (($equippedweapondamage + $player_strength) + $equippedvehiclepower) * 100;
$defence_action = (($equippedarmordefence + $player_agility) + $equippedvehiclepower) * 100;
$covert_action = ($equippedvehiclepower + $player_intelligence) * 100;

// Workout the Players Income //
$players_income = ((($strike_action * $defence_action) * $covert_action) / 100000000);

 

Every user will have different, strike, defence and covert actions, which would change what their income is. Now how would I make these variables change to suit each user for the MySQL "UPDATE" ?

 

or would UPDATE'ing the database with my query I have above do this automatically?

 

Regards ACE

[Barand]

$strike_action = (($equippedweapondamage + $player_strength) + $equippedvehiclepower) * 100;

 

if strike_action, equippedweapondamage, player_strength, equippedvehiclepower are columns in the table you can use that expression in the update

 

UPDATE cf_users
SET strike_action = ((equippedweapondamage + player_strength) + equippedvehiclepower) * 100

 

and have SQL calculate the value for each user

[MasterACE14]

ok, thank you, that should work 

 

Regards ACE