inc/record.inc.php
changeset 5 ebf8868e99f5
parent 1 58094faf794d
child 8 47dd15d8bb8c
equal deleted inserted replaced
4:55ed92aa7cf5 5:ebf8868e99f5
  1052 				}
  1052 				}
  1053 			}
  1053 			}
  1054 			break;
  1054 			break;
  1055 	    
  1055 	    
  1056 		case '1' :
  1056 		case '1' :
  1057 			$sqlq = "SELECT `domains`.*, count(`records`.`id`) AS `numrec`, `zones`.`owner`  
  1057 			$sqlq = "SELECT `domains`.*, count(`records`.`id`) AS `numrec`, `zones`.`owner`, `records`.`domain_id`
  1058 					FROM `domains`, `records`, `zones`  
  1058 					FROM `domains`, `records`, `zones`  
  1059 					WHERE `domains`.`id` = `records`.`domain_id` 
  1059 					WHERE `domains`.`id` = `records`.`domain_id` 
  1060 					AND `zones`.`domain_id` = `domains`.`id` 
  1060 					AND `zones`.`domain_id` = `domains`.`id` 
  1061 					AND `domains`.`name` = '".$question."' 
  1061 					AND `domains`.`name` = '".$question."' 
  1062 					GROUP BY (`domains`.`id`)";
  1062 					GROUP BY (`domains`.`id`)";