Record Paging query

[geniusgenie]

hii,
This is ali... I am using php 5 with Mysql. I want to ask, how can I split records into multiple pages and access those pages using letter wise naming. Like we have a company listing arranged into multiple pages from A to Z pages and I want to show Companies starting from letter "C" so this arrangement should allow me.

please guide me about this

regards

[Roger_Ramjet]

First thing you should remember is that there are plenty of companies like 3com whose name starts with a number. Where are you going to list those? 😃
Likewise, what would you list A Jones & Sons under?

To query for companies by first letter you need to use the string comparison function LIKE with a wildcard: name LIKE "C%"
That will return all companies beginning with the letter C.