$results=mysql_query("SELECT TIMESTAMPDIFF(SECOND,'2007-12-30 12:01:01','2007-12-31 10:02:00')");
if(!$results)
{
echo mysql_error();
}
else
{
echo $resulta;
}
当我运行此查询时,我正在获取资源 ID #5
试试这个:
$results = mysql_query("SELECT TIMESTAMPDIFF(SECOND,'2007-12-30 12:01:01','2007-12-31 10:02:00')");
if (!$results) {
echo mysql_error();
} else {
$data = mysql_fetch_assoc($results);
var_dump($data); //check all the data that is returned
}
旁注:您的代码容易受到 sql 注入的影响。 mysql_*
已弃用。建议你使用 pdo
$results=mysql_query("SELECT TIMESTAMPDIFF(SECOND,'2007-12-30 12:01:01','2007-12-31 10:02:00')");
while($data=mysql_fetch_row($results)){
//your answer
}
或者你也可以试试这种方式
$results=("SELECT TIMESTAMPDIFF(SECOND,'2007-12-30 12:01:01','2007-12-31 10:02:00')");
$re = mysql_query($results) or die("wrong query".mysql_error());
while($row= mysql_fetch_array($re))
{
//your code here
}
是的,如上所述,您的代码容易受到SQL注入的影响。