PHP Exception - MySqli Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by search.deal_category_id order by deal

MySqli Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by search.deal_category_id
   order by deal_category.priori' at line 6
Exception Type:   QMySqliDatabaseException

Rendered Page:   Click here to view contents able to be rendered

Source File:   D:\mobiles\sites\freelinerentalphones.org.uk\contract-mobilephonedeals.php     Line:   393

Line 388:    						   search.mobile_id = $this->intMobileId	
Line 389:    						   group by search.deal_category_id					   
Line 390:    						   order by deal_category.priority asc,deal_category.name asc";
Line 391:    				
Line 392:    				$objDatabase  = QApplication::$Database[1];
Line 393:    				$objDbResult = $objDatabase->Query($strSql);	
Line 394:    				while ($mixRow = $objDbResult->FetchArray()) {	
Line 395:    					
Line 396:    					if($mixRow["deal_category_id"] != $this->intDealCategoryId) //dont need to add deal category which he is on already
Line 397:    						$this->lstDealCategoryMain->AddItem($mixRow["deal_category_name"],$mixRow["deal_category_id"]);				
Line 398:    				}

Database Error Number: 1064

Query: Show/Hide

Select deal_category.id as deal_category_id, deal_category.name as deal_category_name
					       from search inner join deal_category on
					       search.deal_category_id = deal_category.id					       
						   where 
						   search.mobile_id = 	
						   group by search.deal_category_id					   
						   order by deal_category.priority asc,deal_category.name asc

Call Stack:

#0 D:\mobiles\sites\freelinerentalphones.org.uk\contract-mobilephonedeals.php(393): QMySqlDatabase->Query('Select deal_cat...')
#1 D:\mobiles\sites\freelinerentalphones.org.uk\contract-mobilephonedeals.php(68): ContractDeals->lstDealCategoryMain_Create()
#2 D:\mobiles\admin\qcodo\includes\qcodo\_core\qform\QFormBase.class.php(276): ContractDeals->Form_Create()
#3 D:\mobiles\sites\freelinerentalphones.org.uk\contract-mobilephonedeals.php(484): QFormBase::Run('ContractDeals')
#4 {main}

Variable Dump: Show/Hide

  COMSPEC
'C:\\WINDOWS\\system32\\cmd.exe'
  DOCUMENT_ROOT
'D:/mobiles/sites/freelinerentalphones.org.uk'
  GATEWAY_INTERFACE
'CGI/1.1'
  HTTP_ACCEPT
'text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5'
  HTTP_ACCEPT_CHARSET
'ISO-8859-1,utf-8;q=0.7,*;q=0.7'
  HTTP_ACCEPT_ENCODING
'gzip'
  HTTP_ACCEPT_LANGUAGE
'en-us,en;q=0.5'
  HTTP_CACHE_CONTROL
'no-cache'
  HTTP_CONNECTION
'close'
  HTTP_COOKIE
'PHPSESSID=t1q29jib2902b76jc2mv674e85'
  HTTP_HOST
'www.freelinerentalphones.org.uk'
  HTTP_PRAGMA
'no-cache'
  HTTP_USER_AGENT
'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
  HTTP_X_CC_ID
'ccc02-01'
  PATH
'C:\\PHP\\;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem'
  PATHEXT
'.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH'
  PATH_INFO
'/Sony_Ericsson_Naite_Black_Silver'
  PATH_TRANSLATED
'D:\\mobiles\\sites\\freelinerentalphones.org.uk\\Sony_Ericsson_Naite_Black_Silver'
  PHPSESSID
't1q29jib2902b76jc2mv674e85'
  PHP_SELF
'/contract-mobilephonedeals.php/Sony_Ericsson_Naite_Black_Silver'
  QUERY_STRING
''
  REMOTE_ADDR
'38.107.191.80'
  REMOTE_PORT
'41769'
  REQUEST_METHOD
'GET'
  REQUEST_TIME
1269070830
  REQUEST_URI
'/contract-mobilephonedeals.php/Sony_Ericsson_Naite_Black_Silver'
  RenderedPageForError
'	 '
  SCRIPT_FILENAME
'D:/mobiles/sites/freelinerentalphones.org.uk/contract-mobilephonedeals.php'
  SCRIPT_NAME
'/contract-mobilephonedeals.php'
  SERVER_ADDR
'213.175.206.208'
  SERVER_ADMIN
'admin@freelinerentalphones.org.uk'
  SERVER_NAME
'www.freelinerentalphones.org.uk'
  SERVER_PORT
'80'
  SERVER_PROTOCOL
'HTTP/1.1'
  SERVER_SIGNATURE
''
  SERVER_SOFTWARE
'Apache/2.2.11 (Win32) PHP/5.2.9-1'
  SystemRoot
'C:\\WINDOWS'
  WINDIR
'C:\\WINDOWS'
  _COOKIE
array (
  'PHPSESSID' => 't1q29jib2902b76jc2mv674e85',
)
  _ENV
array (
)
  _FILES
array (
)
  _GET
array (
)
  _POST
array (
)
  _REQUEST
array (
  'PHPSESSID' => 't1q29jib2902b76jc2mv674e85',
)
  _SERVER
array (
  'HTTP_X_CC_ID' => 'ccc02-01',
  'HTTP_HOST' => 'www.freelinerentalphones.org.uk',
  'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5',
  'HTTP_ACCEPT_LANGUAGE' => 'en-us,en;q=0.5',
  'HTTP_ACCEPT_ENCODING' => 'gzip',
  'HTTP_ACCEPT_CHARSET' => 'ISO-8859-1,utf-8;q=0.7,*;q=0.7',
  'HTTP_CONNECTION' => 'close',
  'HTTP_CACHE_CONTROL' => 'no-cache',
  'HTTP_PRAGMA' => 'no-cache',
  'HTTP_COOKIE' => 'PHPSESSID=t1q29jib2902b76jc2mv674e85',
  'PATH' => 'C:\\PHP\\;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem',
  'SystemRoot' => 'C:\\WINDOWS',
  'COMSPEC' => 'C:\\WINDOWS\\system32\\cmd.exe',
  'PATHEXT' => '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH',
  'WINDIR' => 'C:\\WINDOWS',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache/2.2.11 (Win32) PHP/5.2.9-1',
  'SERVER_NAME' => 'www.freelinerentalphones.org.uk',
  'SERVER_ADDR' => '213.175.206.208',
  'SERVER_PORT' => '80',
  'REMOTE_ADDR' => '38.107.191.80',
  'DOCUMENT_ROOT' => 'D:/mobiles/sites/freelinerentalphones.org.uk',
  'SERVER_ADMIN' => 'admin@freelinerentalphones.org.uk',
  'SCRIPT_FILENAME' => 'D:/mobiles/sites/freelinerentalphones.org.uk/contract-mobilephonedeals.php',
  'REMOTE_PORT' => '41769',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/contract-mobilephonedeals.php/Sony_Ericsson_Naite_Black_Silver',
  'SCRIPT_NAME' => '/contract-mobilephonedeals.php',
  'PATH_INFO' => '/Sony_Ericsson_Naite_Black_Silver',
  'PATH_TRANSLATED' => 'D:\\mobiles\\sites\\freelinerentalphones.org.uk\\Sony_Ericsson_Naite_Black_Silver',
  'PHP_SELF' => '/contract-mobilephonedeals.php/Sony_Ericsson_Naite_Black_Silver',
  'REQUEST_TIME' => 1269070830,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
  argc
0
  argv
array (
)

Exception Report Generated: Saturday, March 20 2010, 12:40:31 AM