help with a php script

[itivae]

Hi.

I am not sure why i am having such a problem with this. I want to check a query and if it matches data in the last name column I want to print the data. However, if there is no match i want it to echo an error and end. Im sure this is probably a typo somewhere but I do not see it. Hope fully one of you will.

Thanks

$query = "SELECT * FROM main WHERE last = '$lastname'";


 if ($result = $mysqli->query($query)){
    while ($obj = $result->fetch_object()) {
    
       printf ('<div class="name">'."%s", $obj->last);
       printf ("%s", $obj->first);
             printf ("%s", $obj->voter_id);
             printf ("%s", $obj->dob);
             printf ("%s", $obj->city .'</div>');
        
            
            }
        }
        else{
        echo 'There is no person in your database by that last name.';
        $mysqli->close();
        exit;
        } 

[traq]

$result will always be truthy unless there is an error in your query (even if there are no rows in the result). $result->num_rows is what you need to check.

[itivae]

heh Derh..... Thanks a lot Traq. I knew it was something obvious just couldn't see it. Sorry for not posting a descriptive title.

[traq]

heh Derh..... Thanks a lot Traq. I knew it was something obvious just couldn't see it. Sorry for not posting a descriptive title.

You're welcome.

(The "non-descriptive thread title" was actually another mod, but yeah—threads with vague, "I needz help" titles tend to get glossed over. It's a help forum, so "help" is a given; likewise, it's a php forum, so "php" is a given. Next time, just give us a clue about the actual problem you're facing. )