Thread: SQL ERROR
View Single Post
  #7  
Old 2nd June 2021, 20:48
Elena Elena is offline
Senior Member
 
Join Date: Sep 2010
P2P
Posts: 111
Thumbs up
Quote:
Originally Posted by elvira View Post
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]";}
Reply With Quote