Do these both to the same?

[eMonk]

$query = "SELECT .... ";
$result = $db->query($query);

$num_results = $result->num_rows;

if ($num_results == 0) {

exit;

} else {

// do something

 

$query = "SELECT .... ";
$result = $db->query($query);

$num_results = $result->num_rows;

if ($result) {

// do something

}

 

Do these both do the same?

[PFMaBiSmAd]

No.

 

The first one tests if there were any rows returned by the query, which also indirectly detects that the query executed without any errors.

 

The second one only tests if the query executed without any errors. There can still be zero rows in the result set at your // do something point in the code.

[eMonk]

Thanks for the clearification. I'll go with the first one.