PHP count rows of specific entries in database

Question

New to PHP and overwhelmed by all the different solutions to similar problems. I don't know if I have a coding problem, a multiple query problem, or both/more.

In one php file I am opening a connection, running a query, and then on success counting the number of times that entry appears in the database... or at least attempting to.

// $team1, $team2 and $page come in through _POST up here...

$connection = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);

// build long query at this point...

$result = mysqli_query($connection, $query);

//I was successful getting it into the database, now I want to count how many times each entry appears.
if ($result) {
        $team1result = mysqli_query($connection,"SELECT * FROM {$page} WHERE 'vote' = {$team1}") ;
        $team1row = mysqli_fetch_row($team1result);
        $team1count = $team1row[0];

        $team2result = mysqli_query($connection,"SELECT * FROM {$page} WHERE 'vote' = {$team2}") ;
        $team2row = mysqli_fetch_row($team2result);
        $team2count = $team2row[0];

        echo $team1count . " and " . $team2count;
}

I'm able to insert into the database just fine but then my console.log lights up with...

Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in...
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in ...

Thanks for all the help tonight.

SOLUTION (Thanks to wishchaser):

if ($result) {
    $team1rows = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM $page WHERE vote = '$team1'"));
    $team2rows = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM $page WHERE vote = '$team2'"));
    echo $team1 . " : " . $team1rows . "   |   ". $team2 . " : ". $team2rows;
}

Quotes should only be used around strings and not table names or columns names Put a ` around table names and column names. Also use us3.php.net/mysqli_error to error in sql. — Joshua Bixler
– Joshua Bixler, Commented Mar 12, 2014 at 4:34
You say you're counting the number of times that entry appears in the database. I don't see any counting in your code. You're just fetching one row of results from each query. — Barmar
– Barmar, Commented Mar 12, 2014 at 4:34
possible duplicate of mysql_fetch_array() expects parameter 1 to be resource, boolean given in select — John Conde
– John Conde, Commented Mar 18, 2014 at 17:38

wishchaser · Accepted Answer · 2014-03-12 05:45:58Z

1

There were no resulting rows for queries $team1result and $team2result. That is why you are getting this error.

use a if statement to check this

if($team1result)
$team1row = mysqli_fetch_row($team1result);

if($team2result)
$team2row = mysqli_fetch_row($team1result);

You will not get the errors.

And for counting the number of rows that a query result, use the folowing

$rows=mysqli_num_rows(mysqli_query($query));

and a good practice of finding the mistake in your query statement would be to echo it.

in this case

echo "SELECT * FROM $page WHERE vote = '$team1'";
echo "SELECT * FROM $page WHERE vote = '$team2'";

check if the echoed query has no mistakes(like an undefined variable).

edited Mar 12, 2014 at 5:45

answered Mar 12, 2014 at 5:32

wishchaser

6282 gold badges7 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Layne Over a year ago

$rows = mysqli_num_rows(mysqli_query($connection,"SELECT COUNT(*) FROM {$page} WHERE 'vote' = {$team1}")); //still returns Warnings.

wishchaser Over a year ago

check your query by echoing it. It must have problems. Or your database table have no rows matching the condition 'vote' = {$team1}

wishchaser Over a year ago

$rows = mysqli_num_rows(mysqli_query("SELECT * FROM $page WHERE vote = '$team1'")); please use this

Layne Over a year ago

Whoops, replied to wrong comment... HUZZA! $rows = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM $page WHERE vote = '$team1'")); //WORKS!!! Note: I had to add "$connection to that last line your used.

wishchaser Over a year ago

Since you are using only one connection, you need not add the connection parameter. It will work as it is. Glad it worked.

|

Community · Accepted Answer · 2023-11-17 19:55:19Z

0

You can easily count this using num_rows no need to access its index and all, simply use this

echo $team1row = mysqli_num_rows($team1result);

Reference Link

edited Nov 17, 2023 at 19:55

CommunityBot

11 silver badge

answered Mar 12, 2014 at 4:41

SagarPPanchal

10.2k6 gold badges36 silver badges66 bronze badges

3 Comments

Layne Over a year ago

I'm still getting all the "mysqli_fetch_row()" warnings.

SagarPPanchal Over a year ago

while using mysqli_num_rows we not have to use mysqli_fetch_row(), remove this because you just wanted to count na ?

Layne Over a year ago

HUZZA! $rows = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM $page WHERE vote = '$team1'")); //WORKS!!! Note: I had to add "$connection to that last line your used.

Collectives™ on Stack Overflow

PHP count rows of specific entries in database

2 Answers 2

6 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related