通知是什么：资源ID＃9？ [重复]

Question

Possible Duplicate:
How do i “echo” a “Resource id #6” from a MySql response in PHP?

I created a SELECT query but it has an error. When I print_r(result) I get the resource id#9 notice here is the code:

$query= "SELECT * FROM {$hotel_name} WHERE Bdate BETWEEN {$chack_in} AND {$chack_out}";

$availability = mysql_query($query);

confirm_query($availability);

print_r($availability);

Answer 1

'$availability` prints as 'resource id#9' because it is a resource. http://php.net/manual/en/language.types.resource.php

There is nothing wrong with this, it is expected. mysql_query returns resource types when the query executes successful, and false when it fails. You can call mysql_fetch_*($resource) on that resource to get data from it.

(Where * is assoc, object, array, etc)