Welcome Guest, Not a member yet? Register   Sign In
SQL returns no data?
#3

[eluser]danmontgomery[/eluser]
Any successful query will return a result, if there is a database error it will return FALSE.

Code:
$query = $this->db->query("SELECT * FROM ? WHERE id = ?");
if($query == FALSE) {
  // Handle DB error
} else if($query->num_rows() == 0) {
  // Handle successful query with no records returned
} else {
  // Handle successful query with records returned
}


Messages In This Thread
SQL returns no data? - by El Forum - 02-22-2010, 11:38 AM
SQL returns no data? - by El Forum - 02-22-2010, 12:00 PM
SQL returns no data? - by El Forum - 02-22-2010, 12:13 PM



Theme © iAndrew 2016 - Forum software by © MyBB