def template(request): template_active = 'header-menu-item-active' articles = get_article_list(3) index = (request.GET.get('page', 1)-1)*9 sql = '''select * from templates limit %s,9''' % index temp = fetchall(sql) return render_to_response('template.html', locals())
def get_article_list(cate): sql = '''select * from articles where category_id=%s limit 0,10''' % cate return fetchall(sql)