执行此代码段时
$result = mysqli_query($db,"SELECT * FROM 'teklab_support' WHERE 'archive' = 0 and 'adate' < 'mdate'"); $row_cnt = $result->num_rows; echo $row_cnt;
我没有得到任何输出或错误。查询在phpmyadmin中经过了明确的正确测试。谢谢你的帮助
mrwjdhj31#
所以我们找到了解决办法 $count = $db->sql_numrows($db->sql_query("SELECT * FROM 'teklab_support' WHERE 'archive' = '0' and adate < mdate")); echo $count;
$count = $db->sql_numrows($db->sql_query("SELECT * FROM 'teklab_support' WHERE 'archive' = '0' and adate < mdate")); echo $count;
zdwk9cvp2#
看起来不太好
$sql = "SELECT * FROM 'teklab_support' WHERE 'archive' = 0 and 'adate' < 'mdate'"; $results = mysqli_query($db, $sql); $row_count = mysqli_num_rows($results); echo $row_count;
2条答案
按热度按时间mrwjdhj31#
所以我们找到了解决办法
$count = $db->sql_numrows($db->sql_query("SELECT * FROM 'teklab_support' WHERE 'archive' = '0' and adate < mdate")); echo $count;zdwk9cvp2#
看起来不太好