期望参数1是资源，布尔给定，查询使用前1个顺序通过desc [duplicate]

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

i still new in sqlserver and i trying to fetch database like this

$sql = "select top 1 pdate from j2365join_transaction_old where order by pdate desc";
$mulaisql = sqlsrv_query($sqlconn2, $sql, array(), array( "Scrollable" => 'static'));
$mulai = sqlsrv_fetch_array ($mulaisql, SQLSRV_FETCH_ASSOC);
print_r ($mulai);

but go error

sqlsrv_fetch_array() expects parameter 1 to be resource, boolean given

, can someone explain to me why i got this error, thanks

</div>

Answer 1

Error in your query my friend.

$sql = "select top 1 pdate from j2365join_transaction_old where order by pdate desc";

You should write condition after where clause. If there is no WHERE condition then please remove WHERE clause. So your query will we right

$sql = 'select "top 1 pdate" from j2365join_transaction_old  order by pdate desc';

Generally you should not use spaces in column, although you have done then you can read it by using

Quote ("field name")

Large brackets

"[field name]"

With backticks

SELECT * FROM `Area One`