Evidia Ltd » mysql http://www.evidia.com/blog Just another WordPress weblog Sat, 12 Jun 2010 15:56:19 +0000 http://wordpress.org/?v=2.9.2 en hourly 1 Checking for failed database search http://www.evidia.com/blog/?p=5 http://www.evidia.com/blog/?p=5#comments Sun, 06 Jul 2008 00:40:08 +0000 admin http://www.evidia.com/blog/?p=5 One way of detecting of a select statement returned any results.  Using this currently…

  $result = mysql_query(“SELECT * FROM some_table where some_field = ’some_value’ “, $connection);

  if (!$result) 
    $count=0;
  else
    $count =mysql_num_rows($result);

  if ($count == 0) {
   die(“Database query failed: ” . mysql_error());

]]> http://www.evidia.com/blog/?feed=rss2&p=5 0