Matching a textbox value with column value using php

[georget]

Hie programmers.I am still new to web development. I am trying to match a textbox value to the one in the database. Here is my script below :

//Payments verification
 
$sql = "SELECT Econet_num FROM ecocash";
 
$result = $conn->query($sql);
 
if ($result->num_rows > 0) {
 
    while($row = $result->fetch_assoc()) {
        if($myecocash ==$row['Econet_num']{
         die("found");
 
        }
 
 
 $conn->close();
 
 
?>

[RonB]

$sql = "SELECT count(Econet_num) FROM ecocash where Econet_num = $myecocash";
 
$result = $conn->query($sql);
 
if ($result->num_rows > 0) {
    die("found");
}

[georget]

Okay I have tried your but it is giving this notice below

Notice: Trying to get property of non-object in C:\xampp\htdocs\adslonline\reg.php on line 48
Line 48 is where the if construct is located

[RonB]

Did you get that error before making the change?

If the query is successful, $result will be an object, but if it fails it won't be defined and would be the cause of the error message.

What datatype is Econet_num configured as? Is it an int or varchar?

Try adding single quotes around $myecocash in the query.