I have 390 articles in library a lot of users added those, i need to show in user statistics how many articles user wrote.
This is code which i placed in stat.php but i cant connect it with mysql it doesnt show anything
$libcount = mysql_query("SELECT COUNT(*) FROM `library` where `uploader`=$user_id and type =`library_texts`");а затем я поставил код, чтобы показать номер, как это
'<li><span class="gray">Library texts:</span> ' . $libcount . '</li>' .но он показывает, как это "Library texts: "