Някой може ли да ми го преработи на SQL Code за бц ранка ...
$bc1 = "SELECT TOP 50 CharacterName, Class, Point, Bridge FROM EVENT_INFO_BC WHERE Bridge = 1 Order By Point desc";
$result1 = mssql_query($bc1);
$bc2 = "SELECT TOP 50 CharacterName, Class, Point, Bridge FROM EVENT_INFO_BC WHERE Bridge = 2 Order By Point desc";
$result2 = mssql_query($bc2);
$bc3 = "SELECT TOP 50 CharacterName, Class, Point, Bridge FROM EVENT_INFO_BC WHERE Bridge = 3 Order By Point desc";
$result3 = mssql_query($bc3);
$bc4 = "SELECT TOP 50 CharacterName, Class, Point, Bridge FROM EVENT_INFO_BC WHERE Bridge = 4 Order By Point desc";
$result4 = mssql_query($bc4);
$bc5 = "SELECT TOP 50 CharacterName, Class, Point, Bridge FROM EVENT_INFO_BC WHERE Bridge = 5 Order By Point desc";
$result5 = mssql_query($bc5);
$bc6 = "SELECT TOP 50 CharacterName, Class, Point, Bridge FROM EVENT_INFO_BC WHERE Bridge = 6 Order By Point desc";
$result6 = mssql_query($bc6);
$bc7 = "SELECT TOP 50 CharacterName, Class, Point, Bridge FROM EVENT_INFO_BC WHERE Bridge = 7 Order By Point desc";
$result7 = mssql_query($bc7);