• Categories
    • PHP
    • phpMyAdmin
    • PHPMailer
    • FFMpeg
    • PHPEXcel
    • PHPDoc
    • PHPUnit
    • CakePHP
    • CakePHP 2.0
    • Cake PHP 2.1
    • CakePHP Model
    • Facebook PHP SDK
    • composer-php
    • PHP 7
    • PHP GD
    All Categories
  • About

The sum of the user's points

phphtmlmysql


PHP Snippet 1:

$db->query("SELECT COUNT(DISTINCT(Full_name)) as ID FROM db_main");

PHP Snippet 2:

$db->query("SELECT MAX(Date) AS Date, Full_name, Login, SUM(Points) AS Points FROM db_main GROUP BY Full_name LIMIT $limit");

Related Snippets

Get sql.h error on MacOS 12 (Monterey) sqsrv and pdo_sqsrv drive installation

Adding custom body class to the custom archive pages

CSV to PHP class properties

Error while importing CSV file in database

How to render html from a @foreach loop in a textarea

how to check version of codeigniter framework?

Best way to scrolldown onpageload

How can I create a Download Page with post php method?

Fatal error: Uncaught mysqli_sql_exception: Unknown database 'test' in ... (How do I fix that? Using PHP)

Undefined variable in Laravel 8 project (php 7.4)

How do I loop through an MS SQL database with VB.NET?

woocommerce get_order_report_data to show order_item_id

protect images from being copied

PHP array sort and remove duplicates by two field values

generate an Excel file using PHP

About Contact Privacy policy Terms and conditions