SQL

[GetRekt]

<?php
    $users_registered = number_format(mysql_num_rows(mysql_query("SELECT null FROM users")));
    $svip = number_format(mysql_num_rows(mysql_query("SELECT null FROM users WHERE rank = '3'")));
    $pvip = number_format(mysql_num_rows(mysql_query("SELECT null FROM users WHERE rank = '4'")));
    $uvip = number_format(mysql_num_rows(mysql_query("SELECT null FROM users WHERE rank = '5'")));
    $lvip = number_format(mysql_num_rows(mysql_query("SELECT null FROM users WHERE rank = '5' AND legend = '1'")));
?>

Is there a better way to do that

 

[cxdy]

yeah.

 

[GetRekt]

Wel what is it?

 

[Jian]

Who uses old-standard MySQL?

 

[GetRekt]

What am I supposed to use?

 

[Jian]

What am I supposed to use?

Oh I don't know? MySQLi, PDO? I don't know...

 

[GetRekt]

How would I make mysql -> MysqlI?

 

[Sysode]

Thread moved to help and support - any irrelevant posts from now on will be removed, either give an answer or don't comment.

 

[GetRekt]

It was in help and support......

 

[Sysode]

It was in help and support......

It was in "free programmes and scripts"