SQL help

[Xerez]

Hi, if I want to run a "question" in sql it says as default:

SELECT * FROM `players`

but I want it to something like this: take players cap and add 1000cap to it, to all players. Is it possible to make a code like that?

GETCAP + 1000 ?

I dont know anything about this stuff, but is it possible? please help me!

 

[ntmr]

You must run it only one time?

You can do it with php:

<?php
$i = 0;
$query = mysql_query("SELECT id, cap FROM players");

while ($data = mysql_fetch_array($query)) {
        $id = $data['id'];
        $cap = $data['cap'] + 1000;
        mysql_query("UPDATE players SET cap = '".$cap."' WHERE id = '".$id."'");
        $i++;
}

echo "$i players updated!";
?>

 

[Jonern]

There is a much more easy way to do this!

UPDATE players SET cap = cap + 1000;

 

[Element]

You must run it only one time?

You can do it with php:

<?php
$i = 0;
$query = mysql_query("SELECT id, cap FROM players");

while ($data = mysql_fetch_array($query)) {
        $id = $data['id'];
        $cap = $data['cap'] + 1000;
        mysql_query("UPDATE players SET cap = '".$cap."' WHERE id = '".$id."'");
        $i++;
}

echo "$i players updated!";
?>

Why bother doing it in PHP when you could execute a query directly? You're just complicating things that way

 

[ntmr]

Why bother doing it in PHP when you could execute a query directly? You're just complicating things that way

Ilike php :thumbup: