You should also store all ids in an array to avoid duplicate entries when pushing new links if using limit x,x+20 If a new record is added to the database, previous last results and first new results would be the same
Remi Grumeau (+33) 663 687 206 http://www.remi-grumeau.com Le 24 juil. 2010 à 15:44, Victor Hudson a écrit : > Since we are talking php I'm going to assume mysql as well. What you > need is and ORDER BY clause in the query to sort your pubs however you > want. Next the query needs it's result set limited LIMIT 20,10. 20 > being the number your results start at 10 being how many to return. So > link URL looks kind of like all.php?start=20&count=10. With this link > and the above additions to your query if you have 40 pubs in db you > would get back pubs 20-29 in the order your sorting them. There is > much info on the web about this basic mysql and php stuff. Just google > it. Hope this helps. > > Vic Hudson > > -- > You received this message because you are subscribed to the Google Groups > "iPhoneWebDev" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/iphonewebdev?hl=en. > -- You received this message because you are subscribed to the Google Groups "iPhoneWebDev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/iphonewebdev?hl=en.
