Quote:
Originally Posted by elvira
However, it is interesting that it does not show me an error in all users only for some
|
Code:
$rescom = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT COUNT(*) FROM comments WHERE user = ".$user['id']) or sqlerr(__FILE__,__LINE__);
$arrcom = mysqli_fetch_row($rescom );
$torrentcomments = $arrcom[0];
$resposts = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT COUNT(*) FROM posts WHERE userid = ".$user['id']) or sqlerr(__FILE__,__LINE__);
$arrposts = mysqli_fetch_row($resposts);
$forumposts = $arrposts[0];
$resclient = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT name FROM clientselect WHERE id = ".$user['clientselect']." LIMIT 1") or sqlerr(__FILE__,__LINE__);
$row = mysqli_fetch_array($resclient);if($row){$clientselect = "$row[name]";}
on the last request it is not clear what you specifically want.
For the first two - you can not mix the names of variables, you will sometimes get out errors.
Or so you can:
Code:
$resclient = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT name FROM clientselect WHERE id = ".$user['clientselect']) or sqlerr(__FILE__,__LINE__);
$row = mysqli_fetch_array($resclient);if($row){$clientselect = "$row[name]";}