Test if a query worked

[lurtnowski]

My understanding is that this

if($prepare->rowCount())

returns true if the Query returns at least 1 result.
Is there an if statement I can use to see if t he query was successful (even if it returns 0 results)

[John_Betong]

Don’t wonder, set a variable to the result and use var_dump(…) to view the result

http://php.net/manual/en/mysqli.query.php

Edit:
Wrap var_dump around:

echo "<pre>";
var_dump(...); 
echo "</pre>":

Linefeeds will be shown that makes the value easier to read.

I use a function Fred($val) which saves typing.

That was hard work formatting on a tablet

[colshrapnel]

Yes, but you don’t need it. Just leave your query alone.

[chorn]

->errorInfo() and set your PDO to throw an exception on failure.

[colshrapnel]

It makes no sense to use both. Just set error mode to exception.

Besides, the question was a different one