There is a MySQL sample. The request is triggered, returns tsiferku. Everything is good, but when outputting in php it produces Resource id #6 , so it looks like arrays are displayed.

 $query = "SELECT COUNT(`sms_send_certificate`) FROM $userstable WHERE `sms_send_certificate` = 1"; $sms_counter_2 = mysql_query ($query, $db) or die("you have trouble"); print "sms ΠΏΠΎ сСртификатам: ".$sms_counter_2;

Or why so displayed?
How to display tsiferku?

    1 answer 1

    The mysql_query() function returns a handle to the resulting table. To get an answer, you must use one of the functions for reading the result, for example, mysql_result()

     $query = "SELECT COUNT(`sms_send_certificate`) FROM $userstable WHERE `sms_send_certificate` = 1"; $sms_counter_2 = mysql_query ($query, $db) or die("you have trouble"); print "sms ΠΏΠΎ сСртификатам: ".mysql_result($sms_counter_2, 0, 0);

    However, the mysql extension is now recognized as obsolete and excluded from PHP 7; instead, it is better to use the mysqli or PDO extension.

     try { $pdo = new PDO( 'mysql:host=localhost;dbname=test', 'root', '', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); $query = "SELECT COUNT(`sms_send_certificate`) AS total FROM $userstable WHERE `sms_send_certificate` = 1"; $sms = $pdo->query($query); $result = $sms->fetch(); echo "sms ΠΏΠΎ сСртификатам: ".$result['total']; } catch (PDOException $e) { echo "Ошибка выполнСния запроса: " . $e->getMessage(); }
    • Thank you very much for the clarification and help. Earned! - I_CaR