Question

我试图在问询中申请电话,我也这样做:

$sql = "SELECT id, Title, images, recdate,  item  AS type FROM ads_list WHERE to_days(now())<=(to_days(recdate)+14)";

www.un.org/Depts/DGACM/index_spanish.htm I ve Trial:

1. $sql = "SELECT id, Title, images, recdate,  item  AS type COUNT(*) FROM ads_list WHERE to_days(now())<=(to_days(recdate)+14)";

2. $sql = "SELECT COUNT(*) id, Title, images, recdate,  item  AS type FROM ads_list WHERE to_days(now())<=(to_days(recdate)+14)";

3. $sql = "SELECT COUNT(id), Title, images, recdate,  item  AS type FROM ads_list WHERE to_days(now())<=(to_days(recdate)+14)";

4. $sql = "SELECT id, Title, images, recdate,  item  AS type FROM ads_list WHERE to_days(now())<=(to_days(recdate)+14) COUNT(*)";

我做了什么错误?

Answer 1

(*)号是按功能分类的一组,它退回了选定的各行。各位必须按职能分组,按条款划分不列入集团的任何栏目。因此,你可以做到:

SELECT count(*) as  Count  FROM ads_list WHERE ...

但你可以(直接)按职能和四个标准栏选择一个组。你试图用数字(*)实现什么?

浏览量总数:mysql_num_rows($result_resource)。如果你需要浏览器和计票(而且你正在使用标准的神秘图书馆),这或许是获得你希望的最佳途径。如果你不需要一行(仅计数),则使用数字(*)。

友情链接