[fw-db] Help on building query please

I have to rebuild an sql query to Zend. How to build this query with Zend_DB?
[code]
"SELECT *, (TO_DAYS(NOW()) - TO_DAYS(websites.logged)) as days_old
$more_if_there_is_more
FROM `website_programs`, `websites`
LEFT JOIN `top_sites`
ON top_sites.siteid=websites.websiteid
AND top_sites.programid=website_programs.programid
WHERE website_programs.programid='$program_select'
AND website_programs.active='1' AND website_programs.websiteid =
websites.websiteid
AND websites.websiteid != 'AST' $alpha_sql_1 $sort_by_sql_1 LIMIT
$offset, $perpage
[/code]

Thanks,
V
--
View this message in context: http://www.nabble.com/Help-on-building-query-please-tp20000576p20000576.html
Sent from the Zend DB mailing list archive at Nabble.com.