print in alphabetical order?

[lavashark_com]

the following code was made for me. it prints out all the authors in the database.

is there an easy way to ask it to print alphabetically?
thank you.

 {
      ?>
        <tr> 
          <td align="center"> 
            <table width="400" border="0" cellspacing="1" cellpadding="4" bgcolor="#F2F2F2">
              <tr bgcolor="#CCCCCC"> 
                <td>&nbsp;</td>
                <td><?php print "$admin_authorname"; ?></td>
                <td><?php print "$admin_title"; ?></td>                

                <td colspan="3"><?php print "$admin_opreation"; ?></td>
              </tr>
              <?php
              if (!empty($result)) {
	        while ( list($key,$val)=each($result) ) {
	        $authorid = stripslashes($val["authorid"]);
	        $name = stripslashes($val["authorname"]);	        

	        $title = stripslashes($val["title"]);	        

	        $picture = stripslashes($val["picture"]);
              ?>
              <tr bgcolor="#FFFFFF">
              <td><?php print "$authorid"; ?></td>
                <td><?php print "$name"; ?></td>
                <td><?php print "$title"; ?></td> 
                <td valign="middle" align="center"><a href="authoradmin.php?page=<?php print "$page";?>&picid=<?php print "$authorid"; ?>" class="en_b">
                <?php
                if ($picture>'') {
                ?>
                <img src="<?php echo $PicturePath.$picture;?>" height="30" width="30" border="0">
                <?php
                }
                ?>
                <?php ($picture>'') ? print "$admin_change" : print "$admin_add"; ?>
                </a></td>
                <td><a href="authoradmin.php?editid=<?php print "$authorid"; ?>" class="en_b"><?php print "$admin_edit"; ?></a></td>                              

                <td><a href="authoradmin.php?delid=<?php print "$authorid"; ?>" class="en_b"><?php print "$admin_del"; ?></a></td>                              

              </tr>
              <?php
              }
              }
              ?>                       

            <tr bgcolor="#FFFFFF">
            <td align="right" colspan="6">
            <?php
              $pagenext = $page+1;
		$result1 = $db->getallauthors($pagenext,$record);
		if ($page!=0)
		{
		$pagepre = $page-1;		
		print "<a href=\"$PHP_SELF?page=$pagepre\"><font color=\"#FF0000\">$admin_previouspage</font></a>&nbsp;&nbsp;&nbsp;";
		}
		if (!empty($result1))
		{
		print "<a href=\"$PHP_SELF?page=$pagenext\"><font color=\"#FF0000\">$admin_nextpage</font></a>&nbsp;";
		}
		?>
            </td>
            </tr>
            </table>            

            </td>
        </tr> 
     <?php
      }

[ravnen]

would be a part of the sql query ('... ORDER BY ...')...

more details?

[lavashark_com]

more details would be nice.
I'm trying to learn it myself as we do it, I don't see 'order by' anywhere in the code, where would be a good play to put it?

thanks

[_RL_Ian]

What he means is, when you create your SQL statement. You should do something like this:

<?php
$sql = "SELECT firstname, lastname, middleinitial FROM users ORDER BY lastname, firstname ASC";
?>

You can substitute ASC with DESC to sort the other way.

Hope that helps.

[lavashark_com]

(RL)Ian wrote:

What he means is, when you create your SQL statement. You should do something like this:

<?php
$sql = "SELECT firstname, lastname, middleinitial FROM users ORDER BY lastname, firstname ASC";
?>

You can substitute ASC with DESC to sort the other way.

Hope that helps.

So, to learn it - - -
select means which variable's i will use?
from 'users' means which database its pullin from
and
order by means of course, how to sort it.

is that right?

[thorpe]

SELECT chooses which fields to pull the data from
FROM chooses the table
ORDER BY lets you choose a field sort by

[lavashark_com]

EDIT:
woah didnt see the update. thank you thorpe.

Hmm, so what's wrong with the following code?
Notice the addition to the sixth line. (I tried both name, and authorname not sure which one was correct, but both gave me no changes in the output)

<?php
      if (!isset($HTTP_GET_VARS["editid"]))
	        {
      ?>
	  <?
	  $sql = "SELECT name, title FROM authors ORDER BY name, title ASC";
	  ?>        <tr> 
          <td align="center"> 
            <table width="400" border="0" cellspacing="1" cellpadding="4" bgcolor="#F2F2F2">
              <tr bgcolor="#CCCCCC"> 
                <td>&nbsp;</td>
                <td><?php print "$admin_authorname"; ?></td>
                <td><?php print "$admin_title"; ?></td>                

                <td colspan="3"><?php print "$admin_opreation"; ?></td>
              </tr>
              <?php
              if (!empty($result)) {
	        while ( list($key,$val)=each($result) ) {
	        $authorid = stripslashes($val["authorid"]);
	        $name = stripslashes($val["authorname"]);	        

	        $title = stripslashes($val["title"]);	        

	        $picture = stripslashes($val["picture"]);
              ?>
              <tr bgcolor="#FFFFFF">
              <td><?php print "$authorid"; ?></td>
                <td><?php print "$name"; ?></td>
                <td><?php print "$title"; ?></td> 
                <td valign="middle" align="center"><a href="authoradmin.php?page=<?php print "$page";?>&picid=<?php print "$authorid"; ?>" class="en_b">
                <?php
                if ($picture>'') {
                ?>
                <img src="<?php echo $PicturePath.$picture;?>" height="30" width="30" border="0">
                <?php
                }
                ?>
                <?php ($picture>'') ? print "$admin_change" : print "$admin_add"; ?>
                </a></td>
                <td><a href="authoradmin.php?editid=<?php print "$authorid"; ?>" class="en_b"><?php print "$admin_edit"; ?></a></td>                              

                <td><a href="authoradmin.php?delid=<?php print "$authorid"; ?>" class="en_b"><?php print "$admin_del"; ?></a></td>                              

              </tr>
              <?php
              }
              }
              ?>                       

            <tr bgcolor="#FFFFFF">
            <td align="right" colspan="6">
            <?php
              $pagenext = $page+1;
		$result1 = $db->getallauthors($pagenext,$record);
		if ($page!=0)
		{
		$pagepre = $page-1;		
		print "<a href=\"$PHP_SELF?page=$pagepre\"><font color=\"#FF0000\">$admin_previouspage</font></a>&nbsp;&nbsp;&nbsp;";
		}
		if (!empty($result1))
		{
		print "<a href=\"$PHP_SELF?page=$pagenext\"><font color=\"#FF0000\">$admin_nextpage</font></a>&nbsp;";
		}
		?>
            </td>
            </tr>
            </table>            

            </td>
        </tr> 
     <?php
      }
           ?>  

[_RL_Ian]

You have to run the query like so:

$sql = "SELECT name, title FROM authors ORDER BY name, title ASC"; 
$result = mysql_query($sql);

Also, in your while statement, none of the field names match the ones that you selected from the query.

[lavashark_com]

yeah im really going slow with this! :eek:

When I try the code:

	  <?
	   $sql = "SELECT name, title FROM authors ORDER BY name, title ASC"; 
$result = mysql_query($sql);  

?>
        <tr> 
          <td align="center"> 
            <table width="400" border="0" cellspacing="1" cellpadding="4" bgcolor="#F2F2F2">
              <tr bgcolor="#CCCCCC"> 
                <td>&nbsp;</td>
                <td><?php print "$admin_authorname"; ?></td>
                <td><?php print "$admin_title"; ?></td>                

                <td colspan="3"><?php print "$admin_opreation"; ?></td>
              </tr>
              <?php
              if (!empty($result)) {
	        while ( list($key,$val)=each($result) ) {
	        $authorid = stripslashes($val["authorid"]);
	        $name = stripslashes($val["authorname"]);	        

	        $title = stripslashes($val["title"]);	        

	        $picture = stripslashes($val["picture"]);
              ?>
              <tr bgcolor="#FFFFFF">
              <td><?php print "$authorid"; ?></td>
                <td><?php print "$name"; ?></td>
                <td><?php print "$title"; ?></td> 
                <td valign="middle" align="center"><a href="authoradmin.php?page=<?php print "$page";?>&picid=<?php print "$authorid"; ?>" class="en_b">
                <?php
                if ($picture>'') {
                ?>
                <img src="<?php echo $PicturePath.$picture;?>" height="30" width="30" border="0">
                <?php
                }
                ?>
                <?php ($picture>'') ? print "$admin_change" : print "$admin_add"; ?>
                </a></td>
                <td><a href="authoradmin.php?editid=<?php print "$authorid"; ?>" class="en_b"><?php print "$admin_edit"; ?></a></td>                              

                <td><a href="authoradmin.php?delid=<?php print "$authorid"; ?>" class="en_b"><?php print "$admin_del"; ?></a></td>                              

              </tr>
              <?php
              }
              }
              ?>                       

            <tr bgcolor="#FFFFFF">
            <td align="right" colspan="6">
            <?php
              $pagenext = $page+1;
		$result1 = $db->getallauthors($pagenext,$record);
		if ($page!=0)
		{
		$pagepre = $page-1;		
		print "<a href=\"$PHP_SELF?page=$pagepre\"><font color=\"#FF0000\">$admin_previouspage</font></a>&nbsp;&nbsp;&nbsp;";
		}
		if (!empty($result1))
		{
		print "<a href=\"$PHP_SELF?page=$pagenext\"><font color=\"#FF0000\">$admin_nextpage</font></a>&nbsp;";
		}
		?>

I get an empty output.

When I try:
(only difference being 'SELECT' authorname, or name)

 <?
	   $sql = "SELECT authorname, title FROM authors ORDER BY authorname, title ASC"; 
$result = mysql_query($sql);  

?>
        <tr> 
          <td align="center"> 
            <table width="400" border="0" cellspacing="1" cellpadding="4" bgcolor="#F2F2F2">
              <tr bgcolor="#CCCCCC"> 
                <td>&nbsp;</td>
                <td><?php print "$admin_authorname"; ?></td>
                <td><?php print "$admin_title"; ?></td>                

                <td colspan="3"><?php print "$admin_opreation"; ?></td>
              </tr>
              <?php
              if (!empty($result)) {
	        while ( list($key,$val)=each($result) ) {
	        $authorid = stripslashes($val["authorid"]);
	        $name = stripslashes($val["authorname"]);	        

	        $title = stripslashes($val["title"]);	        

	        $picture = stripslashes($val["picture"]);
              ?>
              <tr bgcolor="#FFFFFF">
              <td><?php print "$authorid"; ?></td>
                <td><?php print "$name"; ?></td>
                <td><?php print "$title"; ?></td> 
                <td valign="middle" align="center"><a href="authoradmin.php?page=<?php print "$page";?>&picid=<?php print "$authorid"; ?>" class="en_b">
                <?php
                if ($picture>'') {
                ?>
                <img src="<?php echo $PicturePath.$picture;?>" height="30" width="30" border="0">
                <?php
                }
                ?>
                <?php ($picture>'') ? print "$admin_change" : print "$admin_add"; ?>
                </a></td>
                <td><a href="authoradmin.php?editid=<?php print "$authorid"; ?>" class="en_b"><?php print "$admin_edit"; ?></a></td>                              

                <td><a href="authoradmin.php?delid=<?php print "$authorid"; ?>" class="en_b"><?php print "$admin_del"; ?></a></td>                              

              </tr>
              <?php
              }
              }
              ?>                       

            <tr bgcolor="#FFFFFF">
            <td align="right" colspan="6">
            <?php
              $pagenext = $page+1;
		$result1 = $db->getallauthors($pagenext,$record);
		if ($page!=0)
		{
		$pagepre = $page-1;		
		print "<a href=\"$PHP_SELF?page=$pagepre\"><font color=\"#FF0000\">$admin_previouspage</font></a>&nbsp;&nbsp;&nbsp;";
		}
		if (!empty($result1))
		{
		print "<a href=\"$PHP_SELF?page=$pagenext\"><font color=\"#FF0000\">$admin_nextpage</font></a>&nbsp;";
		}
		?>

I get the error:

Warning: Variable passed to each() is not an array or object in /home/stfusaco/public_html/news/admin/authoradmin.php on line 214

Line 214 being:

while ( list($key,$val)=each($result) ) {

😕 :eek: :xbones:

[Weedpacket]

Like the error message says, $result isn't an array (or an object). [man]mysql_query/man returns a result set (as the manual says).
The common method (which can be found by reading through the various sections in the manual that cover PHP's MySQL functions - you are doing this, I'd hope) would suggest replacing

while ( list($key,$val)=each($result) ) { 

with

while ($val = mysql_fetch_array($result)) {

[lavashark_com]

yeah that seemed to fix it. Thank you for your help.
(although before it listed them about 20/page, now it puts them all on the same page).

[Weedpacket]

You'll probably want to add a LIMIT clause to your query.