Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'broi'. (severity 16) in C:\xampp\htdocs\modules\topreferals.php on line 3
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\modules\topreferals.php on line 3
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\modules\topreferals.php on line 4
<?php
include "conreal.php";
$query = mssql_query("SELECT DISTINCT TOP 100 (userid), broi from items order by broi desc");
while ($a = $fetch = mssql_fetch_array($query)) {
$id = $a['userid'];
$getname = mssql_query("SELECT * from MEMB_INFO where memb___id='$id'");
$fatch = mssql_fetch_array($getname);
$username = $fatch['memb___id'];
$broi = mssql_num_rows(mssql_query("SELECT * from items where userid='$id'"));
$up = mssql_query("UPDATE items SET broi='$broi' WHERE userid='$id'");
$username = $fatch['memb___id'];
echo '
' . $username . '-' . $broi . '<br>
';
}
?>
ти все още ли не си разбрал че не става за bz
<?php
include "_header.php";
include "modules/link.php";
include "_footer.php";
?>
<?php
include "_header.php";
include "modules/vote.php";
include "_footer.php";
?>