$query = "SELECT COUNT (*) AS spo FROM NAME_TABEL WHERE BEFORE_OURCE_OBAT = '1' AND ROOM = 'ORCHID' AND MONTH (DATE) = '$ month' "; $row = sqlsrv_query($conn, $query); $data = sqlsrv_fetch_array($row); $spo = $data['spo']; ?> why an error appears after the program is run, please help ? Warning: sqlsrv_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\siimut\name_tabel.php on line 140
All 2 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.