Index: branches/unlabeled/unlabeled-1.6.32/admin/tools/sql_result.php
===================================================================
diff -u -r2859 -r5264
--- branches/unlabeled/unlabeled-1.6.32/admin/tools/sql_result.php	(.../sql_result.php)	(revision 2859)
+++ branches/unlabeled/unlabeled-1.6.32/admin/tools/sql_result.php	(.../sql_result.php)	(revision 5264)
@@ -65,8 +65,7 @@
    </tr>
 <tr>
 <?php
-  if($SqlErrorNum>0)
-  {
+  if ($SqlErrorNum > 0) {
 ?>
 <?php int_subsection_title(admin_language("la_prompt_sqlquery_error")); ?>
  <tr <?php echo int_table_color(); ?>>
@@ -76,42 +75,48 @@
    </tr>
 <tr>
 <?php
-  }
-  else 
-  {    	  	
-  	$ResultObject = new clsItemCollection();
-  	$ResultObject->classname = "clsItemDB";
-  	echo "<TR><TD colspan=3><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\">";
-  	while($SqlResult && !$SqlResult->EOF)
-  	{
-  		$ResultObject->AddItemFromArray($SqlResult->fields,TRUE);
-  		$SqlResult->MoveNext();
+	}
+  	else {
+  		$ResultObject = new clsItemCollection();
+  		$ResultObject->classname = "clsItemDB";
+  		echo '<tr><td colspan="3">';
+  		while ($SqlResult && !$SqlResult->EOF) {
+  			$ResultObject->AddItemFromArray($SqlResult->fields,TRUE);
+  			$SqlResult->MoveNext();
+  		}
+
+  		if (method_exists($SqlResult, 'FieldTypesArray')) {
+  			// it was query that has results
+  			$objListView = new clsListView(NULL,$ResultObject);
+  			
+  			echo '<table width="100%" border="0" cellspacing="0" cellpadding="4">';
+  			$fields = $SqlResult->FieldTypesArray();
+  			if ($fields) {
+  				$width = 100 / count($fields);
+  				$width = "width=\"".$width."%\"";
+
+  				foreach ($fields as $f) {
+  					$name = $f->name;
+  					$objListView->ColumnHeaders->Add($name,$name,1,0,"",$width,"", "",$name);
+  				}
+  			}
+  			
+  			$objListView->PrintToolBar = FALSE;
+  			$objListView->nowrap = FALSE;
+  			$objListView->CurrentPageVar = "";
+  			$objListView->PerPageVar = "";
+  			$objListView->checkboxes=false;
+  			echo $objListView->ColumnHeaders->PrintColumns();
+  			if ($ResultObject->NumItems() > 0) {
+  				echo $objListView->PrintItems();
+  			}
+  			echo '</table>';
+  		}
+  		else {
+  			echo language('no_results');
+  		}
+  		echo '</TD></TR>';
   	}
-    $objListView = new clsListView(NULL,$ResultObject);
-    $fields = $SqlResult->FieldTypesArray();
-    if(is_array($fields))
-    {    
-    	$width = 100 / count($fields);
-    	$width = "width=\"".$width."%\"";
-    	
-    	foreach($fields as $f)
-    	{    	
-    		$name = $f->name;    	
-			$objListView->ColumnHeaders->Add($name,$name,1,0,"",$width,"", "",$name);		
-    	}
-    }
-  	$objListView->PrintToolBar = FALSE;
-  	$objListView->nowrap = FALSE;
-  	$objListView->CurrentPageVar = "";
-  	$objListView->PerPageVar = "";
-  	$objListView->checkboxes=false;
-  	echo $objListView->ColumnHeaders->PrintColumns();
-  	if($ResultObject->NumItems()>0)  	
-  	{
-  		echo $objListView->PrintItems();  	
-  	}
-  	echo "</TABLE></TD></TR>";
-  }
 ?>  
 </TABLE>
 <?php int_footer(); ?>
\ No newline at end of file