Home

code for gor to see

June 15, 2008 - 6:15am — Anonymous
  1. function client_search_result($sstr = NULL) {
  2.  
  3.   if (!$sstr) {
  4.       drupal_set_message("Search cant be empty", error);
  5.       drupal_goto('clients');
  6.   } else {
  7.  
  8.   $query = "SELECT * FROM {clients} WHERE  coname LIKE '%".$sstr."%'OR tradename LIKE '%".$sstr."%' OR accno LIKE '%".$sstr."%'";
  9.   $result = db_query($query);
  10.  
  11.     while  ($object = db_fetch_object($result)) {
  12.       $output .= l(t($object->accno), 'clients/view/'.$object->accno).' - ';
  13.       $output .= l(t($object->coname), 'clients/view/'.$object->accno).'  ('.$object->tradename.')<br>';
  14.       $output .= 'Contact : '.$object->contact.', Phone : '.$object->phone.'<hr>';
  15.     }
  16.  
  17.   }
  18.   return $output;
  19. }