我有下面的MySQL查询,当满足条件时,我想回显一个特定的行;
global $post;
$post_author = $post->post_author;
$result = mysql_query("SELECT *, @rownum := @rownum + 1 from
(
SELECT (display_name) 'Author',
IFNULL(ROUND(SUM(balance.meta_value),2),2) 'Balance'
FROM posts p
JOIN users u
ON p.post_author = u.ID
JOIN postmeta odd ON p.ID = odd.post_id AND odd.meta_key = 'odd' AND odd.meta_value >= 1.5
LEFT JOIN postmeta balance
ON p.ID = balance.post_id AND balance.meta_key = 'balance'
WHERE p.post_status = 'publish'
GROUP BY u.ID
ORDER BY Balanco DESC
)x, (SELECT @rownum := 0) r");
$row = mysql_fetch_array($result);
当Author等于$post_Author时,我想回显第3行,有人能帮我吗。谢谢
<?php echo "{$row[3]}";?> where Author=$post_author
我相信一个简单的if
会让你高兴:
if ($row[0] == $post_author)
echo $row[3];