CodeIgniter Forums
SQL returns no data? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: SQL returns no data? (/showthread.php?tid=27847)

SQL returns no data? - El Forum - 02-22-2010

[eluser]CoperNikus[/eluser]
If, for an example a
Code:
$this->db->query("SELECT * FROM ? WHERE id = ?");
doesn't match any data, what does it returns, I mean how do I check if it is empty?

SQL returns no data? - El Forum - 02-22-2010

[eluser]CoperNikus[/eluser]
???

SQL returns no data? - El Forum - 02-22-2010

[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
}