Page 1 of 1

PHP MS-SQL Query problem

Posted: Fri May 01, 2009 6:56 pm
by modplod
Hi, all, Just a wee problem with a mssql query.
The following query works when I enter it in to server mngt studio, and gives the correct results, but when I pipe it through mssql_query I get a whole bunch of errors. Can anyone see the problem with it or suggest an alternative query, thanks

Code: Select all

$query = "SELECT hlc_resort, hlc_ticket, hlc_employee FROM hotlist_comments WHERE (hlc_ticket LIKE 'T%')";

Re: PHP MS-SQL Query problem

Posted: Sun May 03, 2009 9:24 am
by modplod
sorted, There was no problem, turned out to be a typo in my mssql class I was writing at the same time.