Sort results alphabetically, rotate starting letter

[JKinBlack]

I need to pull records (book titles) from a database and sort them alphabetically.

 

The first time I pull them, sorted by first letter: a, b, c, d,...

The next time I pull them, sorted: b, c, d, .... y, z, a

The next time: c, d, e, .... y, z, a, b

 

:-\

 

Thanks for the help..

[Maq]

Check out limit.  LIMIT $start, $how_many_from_start);  Maybe recursively?

[sasa]

look

<?php
$ord = range('a', 'z');
$time = 3; 
for ($i= 1; $i < $time; $i++) array_push($ord, array_shift($ord));
$ord = implode("','",$ord);
$sql = "SELECT ....  ORDER BY FIELD(LCASE(LEFT(`field_name`, 1)),'$ord')";
?>