Jump to content

get x to z


monkeytooth

Recommended Posts

ok, simple question I am sure. I know Ive done this before, but I cant remember how its been to long, and if I could even remember the term to call it I would look it up for a tut. But none the less I cant so here goes, cause I know you guys will help you always do..

 

Querying a DB.. I only want to list 50 results per page.. and have a back and next link for more then 50 results. So hit me... what do i do.. Ill even take a link if you know one to a good tutorial on the subject, save ya the time of typing here..  ::)

Link to comment
https://forums.phpfreaks.com/topic/120261-get-x-to-z/
Share on other sites

if you mean how could you paginate results see:

http://www.google.com/search?q=pagination+php&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

 

if you mean select values where the start letters range from x-z (as per your title?) you could try something like...

SELECT * FROM table WHERE value REGEXP '^([x-zX-Z])'

 

I figure you meant the first, but just being careful.

Link to comment
https://forums.phpfreaks.com/topic/120261-get-x-to-z/#findComment-619547
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.