Cant find MySQL row in PHP

Question

So I want to get a MySQL row count and I keep getting nothing instead. I keep getting the error

"Error: couldn't find the row.". When in fact the row is really there in database.

$sql = "SELECT * FROM users WHERE code = '$promo'";
$result = $conn->query($sql);

if ($result->num_rows > 0){
    $rowhis = $result->fetch_assoc();
} else {
    echo "Error: couldn't find the row.";
    die();
}

You Should look this first [here](https://stackoverflow.com/questions/1402566/what-is-the-difference-between-and-in-php) — always-a-learner, Jun 17 '17 at 07:16
Use prepared statements. This would help solve your problem. — Rotimi, Jun 17 '17 at 07:18

score -1 · Answer 1 · answered Jun 17 '17 at 07:19

-1

You may request to follow PHP appending string with php variable.Please reffer this get more idea

Here you just change your query like below given

$sql = "SELECT * FROM users WHERE code = '".$promo."'";

Please try this will help you.

answered Jun 17 '17 at 07:19

Pranav MS

2,235
2
23
50

Cant find MySQL row in PHP

1 Answers1