0

Hi all! I am still new at PHP and mysql and am having a little difficult time figuring out how to get my "Trainee Name" link to switch my info list from ascending to descending order and vice versa. Right now, you will see it defaults to ASC. Any help would be greatly appreciated. Thanks!

if (((!$keywords)) && ($_POST["submit"] != 'Edit Trainee') && ($_POST["submit"] != 'Add Trainee') && ($_GET["action"] != 'edit') && ($_GET["action"] != 'add')) {

      $query_trainees = "SELECT * FROM tdb_trainees ORDER BY tdb_trainees.last_name ASC";
   
	//echo $query_trainees."<br>";    
	$result_trainees = mysql_db_query($dbname, $query_trainees);	
	while ($r = mysql_fetch_array($result_trainees)) {
		   $trainee_id = $r["trainee_id"];
		   $last_name = $r["last_name"];
		   $first_name = $r["first_name"];
		   $producer_id = $r["producer_id"]; 
		   $phone1 = $r["phone1"];		  
		   $query_producer = "SELECT name FROM tdb_producers WHERE producer_id='".$producer_id."'";
		   $result_producer = mysql_db_query($dbname, $query_producer);
		   list($producer_name) = mysql_fetch_array($result_producer);
		   if (strlen($producer_name) > 30) {
		   	 $producer_name = substr($producer_name, 0, 30)."...";
		   }	   
	  	   $trainees_list_output .= '
			 <tr>
	          <td valign="top"><br><a href="/training/trainees.php?action=edit&trainee_id='.$trainee_id.'">'.$last_name.', '.$first_name.'</a></td>
	          <td valign="top"><br>'.$producer_name.'</td>
	          <td valign="top"><br>'.$phone1.'</td>
			</tr>';
	}
	
	echo '<table width="580" align="right" border="0" cellspacing="0" cellpadding="0">
	        <tr>
	          <td colspan="3">
			  <i>NOTE: Click the trainee name to edit/delete a trainee, or <a style="text-decoration:underline" href="/training/trainees.php?action=add&pid='.$producer_id.'">Add a New Trainee</a> here.</i><br>&nbsp;</td>
	        </tr>
	        <tr>
	          <td width="210" valign="top"><u>Trainee Name</u>:</td>
	          <td width="260" valign="top"><u>Company</u>:</td>
	          <td width="110" valign="top"><u>Phone</u>:</td>
			</tr>
			'.$trainees_list_output.'
		  </table>';
	
}
2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by diafol
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.