WordPress发布查询(WordPress post query)
如果他们是第843页的孩子,我正试图显示带有“医疗”标签的帖子,到目前为止,我一切都在工作。 我需要在这个if语句中获取一些HTML,以便我可以将它全部包含在div中,并且还为列表设置一个开始和结束ul。
有人可以帮我解决这个最后一个驼峰吗? 我只是不确定在哪里添加HTML。
<?php if (843 == $post->post_parent) { global $post; $myposts = get_posts('numberposts=10&tag=medical&order=DESC'); foreach($myposts as $post) : ?> <li><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></li> <?php endforeach; } ?>
I am trying to show posts with the tag "medical" if they are a child of page 843, and so far, I have everything mostly working. I need to get some HTML within this if statement so that I can enclose it all in a div, and also to set an opening and closing ul for the list.
Can someone please help me get over this last hump? I'm just not sure where to add the HTML.
<?php if (843 == $post->post_parent) { global $post; $myposts = get_posts('numberposts=10&tag=medical&order=DESC'); foreach($myposts as $post) : ?> <li><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></li> <?php endforeach; } ?>
原文:https://stackoverflow.com/questions/9318941
满意答案
Impala支持窗口功能。 这个问题是一个“缺口和孤岛”问题,因此可以使用行数的差异来解决:
select id, state, min(date) as start_date, max(date) as end_date from (select t.*, row_number() over (partition by id order by date) as seqnum_id, row_number() over (partition by id, state order by date) as seqnum_isd from table t ) t group by id, state, (seqnum_id - seqnum_isd);
差异的逻辑并不困难,但是当你第一次学习它时却很棘手。 它有助于运行子查询并查看行号值是什么 - 以及差异定义每个组的原因。
Impala supports window functions. This problem is a "gap-and-islands" problem, so it can be solved using a difference of row numbers:
select id, state, min(date) as start_date, max(date) as end_date from (select t.*, row_number() over (partition by id order by date) as seqnum_id, row_number() over (partition by id, state order by date) as seqnum_isd from table t ) t group by id, state, (seqnum_id - seqnum_isd);
The logic for the difference is not difficult, but tricky when you first learn it. It helps to run the subquery and see what the row number values are -- and why the difference defines each group.
相关问答
更多SQL将日期缩小到“开始 - 结束”范围(SQL reduce dates to range “start - end”)
根据开始日期和结束日期将多行插入SQL Server(Insert multiple rows into SQL Server based on start and end dates)
如何遍历日期范围?(How to iterate through range of Dates?)
验证日期的开始和结束(validating dates start and end)
SQL多个开始日期到结束日期(SQL multiple start dates to end date)
如何根据开始和结束日期复制记录(How to Duplicate Records According to Start and End Dates)
给定一个开始日期和结束日期...在C#中查找范围内的所有日期(Given a start and end date… find all dates within range in C#)
给出开始日期和结束日期的日期列表(Generating a list of dates given the start and end dates)
如何获得SQL Server中两个日期之间的所有星期的开始和结束日期?(how to get the start and end dates of all weeks between two dates in SQL server?)
SQL查询创建开始日期和结束日期(SQL Query Creating Start and End Dates)
相关文章
更多Solr 使用自定义 Query Parser
Solr 使用自定义 Query Parser
常用HQL(Hibernate Query Language)查询
solr学习笔记二-------solr query查询的参数
MongoDB学习 (五):查询操作符(Query Operators).1st
solr delete query
solr delete query
LeetCode:Word Break(DP)
httpclient post 请求
Mysql错误:Ignoring query to other database解决方法
最新问答
更多获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
如何通过引用返回对象?(How is returning an object by reference possible?)
矩阵如何存储在内存中?(How are matrices stored in memory?)
每个请求的Java新会话?(Java New Session For Each Request?)
css:浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
无论图像如何,Caffe预测同一类(Caffe predicts same class regardless of image)
xcode语法颜色编码解释?(xcode syntax color coding explained?)
在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
从旧版本复制文件并保留它们(旧/新版本)(Copy a file from old revision and keep both of them (old / new revision))
Copyright ©2023 peixunduo.com All Rights Reserved.粤ICP备14003112号
本站部分内容来源于互联网,仅供学习和参考使用,请莫用于商业用途。如有侵犯你的版权,请联系我们(neng862121861#163.com),本站将尽快处理。谢谢合作!