[SOLVED] How could I do this? Lot's of if statements.

[thewhat]

$userid = ($data['user_id']);

 

if ($userdata['attacking_wars'] == 0) (

 

$dbquery5 = "UPDATE ".$db_prefix."users SET attack_1= '$userid' WHERE user_id='".$data['user_id']."'" ) ;

 

if ($userdata['attacking_wars'] == 1) (

 

$dbquery6 = "UPDATE ".$db_prefix."users SET attack_2= '$userid' WHERE user_id='".$data['user_id']."'" ) ;

 

if ($userdata['attacking_wars'] == 2) (

 

$dbquery7 = "UPDATE ".$db_prefix."users SET attack_3= '$userid' WHERE user_id='".$data['user_id']."'" ) ;

 

I'm doing something wrong because it never updates. I just need it to properly connect. :\

[revraz]

Change your lines from

 

if ($userdata['attacking_wars'] == 0) (

 

$dbquery5 = "UPDATE ".$db_prefix."users SET attack_1= '$userid' WHERE user_id='".$data['user_id']."'" ) ;

 

to

 

if ($userdata['attacking_wars'] == 0) {

 

$dbquery5 = "UPDATE $db_prefix users SET attack_1= '$userid' WHERE user_id='".$data['user_id']."'";

}

 

What is the tablename, like prefixusers?

[thewhat]

Yeah. All the variables are properly set and all. Thank you, let me try this out and get back to you.

[kenrbnsn]

Please post more of your code, especially where you are actually doing the mysql_query() call.

 

Ken

[thewhat]

Well it worked. That was the entire code anyway, really. Minus a few variable definitions. Topic solved.