Warning: mysql_query(): Unable to save result set in /usr/local/www/sendsmsnow/http/lib/dblib.php on line 103
select count(distinct(pp.fid))
from atpicture pp where pp.fruser=515969 and pp.fconfirmed in (1)
Blaise Nwaozuzu, blaise2blaze - Free Text Messaging Profile – Send Free Text (SMS) - SendSMSnow.com
select pp.*,date_format(pp.fdate, '%b %D,%Y') as fdate,
date_format(pp.fdate, '%Y%m%d') as date,
pp.ftitle as ftitle,pp.ftitleconfirmed as titleconf
from atuserpicture up
inner join atpicture pp on pp.fid = up.frpicture where (fconfirmed in (1)) order by RAND(),fid desc limit 6 offset 0