PHP

$total_points = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM account WHERE id='$id'"),0)

Mysql hesap tablosu

|user_id|

mysql puan tablosu

|id | user_id | points |

veya

PHP

$total_points = mysql_query("SELECT points FROM account WHERE id='$id'");

Mysql hesap tablosu

|user_id| points |

Mysql puan tablosu

|id | user_id | points |