Get num rows from mysql query php

Question

It's just my first post here in stackOverflow.

Could you tell me how it's possible that my code returns 1 in variable $rows even when the email is not listed in my database?

Code

$query = "SELECT COUNT(*) FROM konta  
WHERE email='".$fieldsFromForm['email']."'";
if($result = $this->dbo->query($query)){
    $rows = $result->num_rows;
    if($rows>0){
        return USER_NAME_ALREADY_EXISTS;
    }
}

You are querying for count(*). That query always returns one row! The count you are looking for is the data of that row. — Adrian W
– Adrian W, Commented Jul 20, 2018 at 10:34

Marvin Fischer · Accepted Answer · 2018-07-20 10:32:05Z

3

Because you select a count that will give you one row only containing 0 on no rows or a higher number if there are rows with that mail.

Use this query:

"SELECT * FROM konta WHERE email='".$fieldsFromForm['email']."'"

Optionally you can use COUNT(*) as cnt and get the associative result and go with $row->cnt, but I'd prefer the first option

answered Jul 20, 2018 at 10:32

Marvin Fischer

2,5823 gold badges25 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Get num rows from mysql query php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related