PHP Resource ID error

I want to retrieve or output data in the database but I kept on getting the error called "Resource ID".

Here is my code:

<?php 

$host="localhost";
$username="root";
$password ="123192";
$db_name = "customers";

//Connecting to your Host
mysql_connect("$host","$username","$password") or die("Failed To Connect The server");
/开发者_运维技巧/Selecting your Database
mysql_select_db("$db_name") or die("Failed To Select The DB");

$name = $_REQUEST['customerName'];

echo 'WELCOME! <b>'.$name.'</b> We hope that you\'ll Enjoy your stay ';

$sql="SELECT Name FROM `people` WHERE id =2 && Name = 'Kyel'";
$rs=mysql_query($sql);
echo "$rs";
?>

If I need improvement regarding my code kindly tell me.

---

mysql_query() returns a resource. The to string (implicitly triggered by using echo to output it) of that is Resource ID # followed by the id.

A resource in PHP is only supposed to be used with other PHP functions. This includes but is not limited to file, curl, ftp handles, etc.

I could tell you to..

(a) use mysql_fetch_array() (or similar) or

(b) use PDO.

The latter is by far much better advice.

---

Try this instead of the echo statement:

$array = mysql_fetch_assoc($rs);
var_dump ($array);