Dear all,
From the php code,
$db=mysql_connect("localhost","","");
mysql_select_db("school",$db);
$sql="select * from weather where date1='$date'";
$result=mysql_query($sql,$db);
$myrow=mysql_fetch_array($result);
no response is given and without any error message prompt out.
When the second statement from above code is changed to :
$sql="select * from weather where date1='2001-03-01'";
there is also no response.
However, when the condition "where date1=..." is deleted, the positive response is given when we display the data.
Please give me some methods to set the condition from the database.
Sincerely yours,
Simon
From the php code,
$db=mysql_connect("localhost","","");
mysql_select_db("school",$db);
$sql="select * from weather where date1='$date'";
$result=mysql_query($sql,$db);
$myrow=mysql_fetch_array($result);
no response is given and without any error message prompt out.
When the second statement from above code is changed to :
$sql="select * from weather where date1='2001-03-01'";
there is also no response.
However, when the condition "where date1=..." is deleted, the positive response is given when we display the data.
Please give me some methods to set the condition from the database.
Sincerely yours,
Simon