php如果sql查询返回有效结果

Question

I'm sure this is a simple fix, I want to run a code block if an sql query comes back with a positive result. something like:

if($query = mysqli_query($cxn,"[query]"))
{
Code to be executed if the query returns a positive result
}

I have tried this format but doesn't work. I'm sure I have done this before but I'm running in to a wall here.

Hope you can help.

Answer 1

So you mean if the query doesn't fail? then:

$query = mysqli_query($cxn, "[query]");
if($query !== false) {
  // Code to be executed if the query returns a positive result
}