Re: mysql_fetch_array() expects parameter 1 to be resource, boolean

[Peter Brawley]

First, use the mysqli API, not the mysql API, which is deprecated and will be removed.

Second, check the return value of functions that can fail.

Third, the repeat call to the query func makes no sense.

$conn = mysqli_connect("localhost", "root", "", "paragon") 
        or die (mysqli_connect_error() ); 

$strSQL = "SELECT * FROM table"; 
$rs = mysqli_query( $conn, $strSQL ) or exit( mysqli_error( $conn ); 

while( $rs && $row=mysqli__fetch_array($rs) ) { 
 ...
}