PHP MS-SQL Query problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
modplod
Forum Commoner
Posts: 45
Joined: Mon Feb 27, 2006 11:18 am

PHP MS-SQL Query problem

Post 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%')";
modplod
Forum Commoner
Posts: 45
Joined: Mon Feb 27, 2006 11:18 am

Re: PHP MS-SQL Query problem

Post by modplod »

sorted, There was no problem, turned out to be a typo in my mssql class I was writing at the same time.
Post Reply