我是一位新手,正试图修改关于按职类限制定制外地数据员额的标准要求。 这里是我尝试的基调,但我可以说明如何过滤第15类。
$querystr = "SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = priority
AND wposts.post_type = post
AND wposts.post_status = publish
AND wposts.
ORDER BY wpostmeta.meta_value ASC";
使用查询——在休息前就座:
query_posts( meta_key=priority&order=ASC&orderby=meta_value&cat=15&post_type=post&post_status=publish );
<代码>meta_key= priority -> 显示与某种(优先)习俗领域有关的员额。
order=ASC ->
可使用<代码>cat=15,4显示第15和4类员额,或<代码>类别_姓名=工作人员,
。 更确切地说,使用查询——职位,通常你可以就使用查询——职位建造任何类型的员额进行再分配。 当你能够出于任何原因使用电梯时使用便衣。
阅读 in the WordPress Codex article Displaying Posts Using a Corporal Selected Query. next!
<><>Edit>: 如poelinca所指出的,如果你没有高度定制或复杂的查询,则考虑使用<代码>query_posts(。
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...