About mssql, I am in a hurry to use the database mssql instead of mysql. I have defined an SQL statement $ SQL and the connection is successful. but why cannot I use mssql_query or mssql_nums_rows? Warning: mssql_query () [function. mssql-query]: Query about mssql, urgent
The database I use is mssql rather than mysql.
I have defined an SQL statement $ SQL
Then the connection is successful.
But why can't mssql_query and mssql_nums_rows be used?
Warning: mssql_query () [function. mssql-query]: Query failed in/opt/coolstack/apache2/htdocs/invoicelog/dealmssql. php on line 113
Warning: mssql_num_rows (): supplied argument is not a valid ms SQL-result resource in/opt/coolstack/apache2/htdocs/invoicelog/dealmssql. php on line 114
------ Solution --------------------
The first error indicates that your query failed.
The second error is associated. if the query fails, the value cannot be set.
Check your SQL commands
------ Solution --------------------
Invalid column name 'bu'
Invalid column name BU does your table have BU fields?
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service