mysql_fetch_array（）期望参数1是资源，在...中给出布尔值[HELP] [重复]

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'm just testing out to display data from database but i keep getting this error :( anyone help?

 <?php
        include 'Connect.php';
        ?>
        <?php
        //query the database
        $query = mysql_query("SELECT * FROM people ");
        mysql_select_db("roofandfacade");

        //fetch the results/convert results into array

        While ($rows= mysql_fetch_array($query)) {
            echo $rows['Person_Name'];
        }




        ?>

</div>

Answer 1

Looks like you are selecting your database after running your query. That won't work for what I hope is obvious reasons.

$query = mysql_query("SELECT * FROM people ");
mysql_select_db("roofandfacade");

Reverse that:

mysql_select_db("roofandfacade");
$query = mysql_query("SELECT * FROM people ");

I am not sure why you don't have mysql_select_db("roofandfacade"); in your connect.php file with your call to mysql_connect(). That would be a more logical place to put it.