inc/record.inc.php
changeset 63 d76966db18e5
parent 62 ce4919f37489
child 65 ce1c4d5e1576
equal deleted inserted replaced
62:ce4919f37489 63:d76966db18e5
  1282 		$sqlq = "SELECT * 
  1282 		$sqlq = "SELECT * 
  1283 				FROM records 
  1283 				FROM records 
  1284 				WHERE content LIKE '".$question."' 
  1284 				WHERE content LIKE '".$question."' 
  1285 				OR name LIKE '".$question."' 
  1285 				OR name LIKE '".$question."' 
  1286 				ORDER BY type DESC";
  1286 				ORDER BY type DESC";
  1287 		echo " $sqlq ";
       
  1288 		$result = $db->query($sqlq);
  1287 		$result = $db->query($sqlq);
  1289 		$ret_r = array();
  1288 		$ret_r = array();
  1290 		while ($r = $result->fetchRow())
  1289 		while ($r = $result->fetchRow())
  1291 		{
  1290 		{
  1292 		    if(xs($r['domain_id']))
  1291 		    if(xs($r['domain_id']))
  1308 				FROM domains, records, zones  
  1307 				FROM domains, records, zones  
  1309 				WHERE domains.id = records.domain_id 
  1308 				WHERE domains.id = records.domain_id 
  1310 				AND zones.domain_id = domains.id 
  1309 				AND zones.domain_id = domains.id 
  1311 				AND domains.name LIKE '".$question."' 
  1310 				AND domains.name LIKE '".$question."' 
  1312 				GROUP BY domains.id, domains.name, zones.owner, records.domain_id";
  1311 				GROUP BY domains.id, domains.name, zones.owner, records.domain_id";
  1313 
       
  1314 		echo "<br> $sqlq ";
       
  1315 		$result = $db->query($sqlq);
  1312 		$result = $db->query($sqlq);
  1316 		$ret_d = array();
  1313 		$ret_d = array();
  1317 		while ($r = $result->fetchRow())
  1314 		while ($r = $result->fetchRow())
  1318 		{
  1315 		{
  1319 		    if(xs($r['domain_id']))
  1316 		    if(xs($r['domain_id']))