how to made this on sql ?:D or php

[Kariton Revolution]

 

set .@count, query_sql ("SELECT char_id,value FROM `global_reg_value` WHERE str='reborncount' ORDER BY value DESC",.@charid,.@reborncount);

 

[Doch]

sql -> SELECT char_id,value FROM `global_reg_value` WHERE str='reborncount' ORDER BY value DESC

[Kariton Revolution]

sql -> SELECT char_id,value FROM `global_reg_value` WHERE str='reborncount' ORDER BY value DESC

how i can add that on my sql and php? can you give me a code of it thankyou!

[Doch]

idk what are you trying to do, but that the sentence SQL

[Kariton Revolution]

idk what are you trying to do, but that the sentence SQL

how can i make that on my sql 

Edited August 3, 2014 by Kariton Revolution

[Emistry]

$sql = "SELECT char_id,value FROM `global_reg_value` WHERE str='reborncount' ORDER BY value DESC";
$sth  = $server->connection->getStatement($sql);

$sth->execute($bind);

$result = $sth->fetchAll();

something like this.

[Kariton Revolution]

$sql = "SELECT char_id,value FROM `global_reg_value` WHERE str='reborncount' ORDER BY value DESC";
$sth  = $server->connection->getStatement($sql);

$sth->execute($bind);

$result = $sth->fetchAll();

something like this.

 

sir emistry can you explain it to me how i can make that on mysql hahah sorry i can't understand it 

what table should i do 

[Emistry]

now you're confusing me.

what you want actually.

• a php to execute sql
• a sql that retrieve data from mysql
• a mysql table to store information
• etc