php无法查询,PHP查询无法使用变量

在我的页面中,我有这个带有echo的代码.

include("../config.php");

$q = mysql_query("SELECT propertyaddress FROM propertydetail WHERE active='yes' and leasedatefrom='".date("m-d-Y", strtotime('+1 months'))."'");

$res = mysql_fetch_array($q);

echo "
pdetail=".$pdetail=trim($res['propertyaddress']);

echo $query="SELECT * FROM tenantmaster WHERE propertyaddress like '".$pdetail."'";

//echo $query="SELECT * FROM tenantmaster ";

//echo $query="SELECT * FROM tenantmaster WHERE propertyaddress = '1934 Heron Ave Unit D Schaumburg IL 60193'";

$resultdb = mysql_query($query);

if (!$resultdb) {

die('Invalid query: ' . mysql_error());

}

else{

echo "
right query";

}

echo "
num of row===".mysql_num_rows($resultdb);

$rowt = mysql_fetch_array($resultdb);

echo "
row===".$rowt['name'];

exit;

?>

config.php

$mysql_hostname = "localhost";

$mysql_user = "root";

$mysql_password = "";

$mysql_database = "gms_estate";

/*

$mysql_hostname = "localhost";

$mysql_user = "root";

$mysql_password = "";

$mysql_database = "gms_estate";

*/

$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password)

or die("Opps some thing went wrong");

mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");

?>

问题是我的第一个查询$q正在工作,但查询$query也工作,但mysql_num_rows($resultdb)不工作并显示0行但是,当我运行echo查询到数据库时,它显示1行.为什么？

我用trim()尝试了$res [‘propertyaddress’]变量但没有任何成功.

但是,当我使用1934 Heron Ave Unit D Schaumburg IL 60193(这是我的变量值)而不是$res [‘propertyaddress’]时,它正在工作.

所以,当我直接给出变量的值然后它正在工作但是当我给变量而不是.为什么？