public static function findByHash($hash = '') { if (!isset($hash) || $hash === '') { return null; } $hashValue = db_sql_encode($hash); $query = "SELECT * FROM blogTripAttribute " . "WHERE hash={$hashValue} " . "ORDER BY updated DESC " . "LIMIT 1"; $result = mysql_query($query); if (!$result) { // Error executing the query print $query . "<br/>"; print " --> error: " . mysql_error() . "<br/>\n"; return null; } if (mysql_num_rows($result) <= 0) { // Trip does not exist return null; } // Create a Trip object with a special trip ID '-' to bypass the // checks on empty ID. The ID value will be overwritten by the // value coming back from the database anyway. $trip = new TripAttribute('-', '-'); if ($trip->loadFromResult($result)) { return $trip; } return null; }