PHP/MySQL Sorting...

[firemaster]

I need to pull data from my mysql database, but pull it out in alphabetic order while only displaying 30 at a time and making pages for 1-30, 30-60, etc. I have all the code to do this except to display in alphabetic order...

<?php
$oldlimit = $limit;
include("db_fns.php"); // file to connect to DB
$page_count = "SELECT * FROM members";
$page_count_query = mysql_query($page_count, $db_conn) or die (mysql_errno().": ".mysql_error()."<BR>");
$count2 = mysql_num_rows($page_count_query);
$user_var = "SELECT * FROM members DISC LIMIT $oldlimit, 30";
$user_var_query = mysql_query($user_var, $db_conn) or die (mysql_errno().": ".mysql_error()."<BR>");
$count = mysql_num_rows($user_var_query);
while($row = mysql_fetch_array($user_var_query)) {
$user_name = $row['member'];
$user_boat = $row['boat'];
$user_slip = $row['slip'];
if($a == '#0099ff'){
$a = '#0099ff';
} else {
$a = '#89CEFF';
}
print"<tr bgcolor='$a'>
<td><b>$user_name</b></td>
<td><b>$user_boat</b></td>
<td><b>$user_slip</b></td>
</tr>";
if($a == '#0099ff'){
$a = '#89CEFF';
} else {
$a = '#0099ff';
}
}
?>
</table>
<div align="center">
<?php
$newlimit = $limit+30;
$oldlimit2 = $oldlimit-30;
$pages = $count2/30;
$pcs = 1;
if($oldlimit2 < 0 )
{
print"Previous Page";
} else {
print"<a href='memlist.php?limit=$oldlimit2' class='links'>Previous Page</a>";
}
print" ¦ ";
while($pcs <= $pages) {
$page_limit = $pcs * 30;
$page_limit2 = $page_limit - 30;
echo "<a href='memlist.php?limit=$page_limit2' class='links'>$pcs</a> ";
$pcs++;
if($pcs > $pages)
{
$page_limit = $pcs * 30;
$page_limit2 = $page_limit - 30;
echo "<a href='memlist.php?limit=$page_limit2' class='links'>$pcs</a> ";
}
}
print" ¦ ";
if($count < 30 )
{
print"Next Page";
} else {
print"<a href='memlist.php?limit=$newlimit' class='links'>Next Page</a>";
}?>

[Romeo]

Hi Firemaster,

have you tried an ORDER BY:
"SELECT * FROM members ORDER BY member ASC LIMIT $oldlimit, 30"

Regards,
R.