Say:
Select * from jj001_trade_buyer where 1=1 order by trade_date DESC Say:
select top 5 trade.id,trade.subject,company.company_name,trade.image,company.id,member.Username,member.ID
from trade
RIGHT JOIN company ON trade.member_id=company.member_id
JOIN member ON trade.member_id=member.ID
WHERE trade.is_show=0
and company.member_type='金牌会员' and trade.image<>''
order by newid()
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\NewVer\conf\mssql_class.php on line 85