Python,mysql question

deelan ggg at zzz.it
Thu Mar 18 15:06:22 CET 2004


james blair wrote:

> Hi
> I have a search page & the reults for the search are fetched from the
> database.
so you are doing web stuff?

> I want that on the results page only first 25 results are shown & a
> link "next 25 results" be shown.Same for the 2nd result page.
> How do I do this?
basically you re-run the mysql query at each page request.
check mysql's limit and offset keywords:
<http://www.mysql.com/documentation/mysql/bychapter/manual_SQL_Syntax.html#SELECT>

-- 
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
<#me> a foaf:Person ; foaf:nick "deelan" ;
foaf:weblog <http://www.deelan.com/> .



More information about the Python-list mailing list