Site Cloner PHP Script
Bargain Hunter PHP Script
Job Hunter PHP Script
Site Login and Access Control PHP Script

MYSQL NUM ROWS To Count Rows

MYSQL NUM ROWS

Counting Rows with mysqli_num_rows function can provide useful pieces of data. The following example demonstrates how to gather gather distinct first names in a table sorted by date.

$names = “select distinct firstname from table_sort WHERE date<=’2012-01-27′ “;
$result= mysqli_query($db, $names);
$name_count = mysqli_num_rows($result);
echo “There are “.$name_count.” rows.<br/><br/>”;

$names2 = “select DISTINCT firstname from table_sort WHERE date>=’2012-01-01′ “;
$result= mysqli_query($db, $names2);
$name_count2 = mysqli_num_rows($result);
echo “There are “.$name_count2.” rows.<br/><br/>”;

$myvalues=array(“After_2011” => $name_count, “Before_2011” => $name_count2);

echo “There are “.count($myvalues).” values in the array.<br/><br/>
There are “.($name_count+$name_count2).” rows in total.”;

Our Skills

Content Management Systems 100%
Joomla and Wordpress CMS 90%
HTML/CSS & JavaScript 95%
PHP & mySQL 95%
  • Categories

    • About

    Affordable web design,custom web development and mobile apps for individuals and businesses. 

    Strict Coding Standards

    • Linux Admin
    • Vancouver PHP Developer
    • MYSQL Programmer
    • Perl Programmer
    • Web Security
    • CMS
    • Vancouver Blogger
    • Do it yourself websites
    • Fast Loading Websites
    • Best Service

    Service List

    • HTML / CSS
    • Small Business Websites
    • Custom Web Apps
    • E-commerce
    • Wordpress
    • Joomla
    • Jquery / Angular.js
    • PHP / SQL
    • PHP Frameworks
    • Pro Content Writing
    • Android & IOS Apps
    • Social Media
    • SEO Committment

    Contact Us

    Fullstack Web Studio
    2000 Diamond Rd
    Squamish, BC, V0N 1T0
    P: (604) 210-2010

    Locations

    SEO Services

    Let us analyze your data and competition to acquire more traffic! Professional SEO content writer

    Links

    My Development Blog
    Internet Marketing Services
    Prices
    Our affordable web design and SEO services are carefully planned and implemented; starting with a breathtaking style.

    After that, I try to ensure your viewers will maximize their experience while Google and other search engines rank you high.

    © 2018 ALL Rights ReservedPrivacy Policy | Terms of Service    Sitemap

    Vancouver | North Vancouver | Burnaby | Richmond | Coquitlam | Port Coquitlam | Surrey | Langley | Maple Ridge | Mission | Abbotsford | Kamloops | Kelowna | Victoria | Squamish | Whistler | Pemberton