Codezwiz >> Forums >> General PHP Nuke Help >> PHP Looping

I have a table called roster_award that has the following fields
award_id
award_name
award_image
award_description

Would this loop gather all the nessecary info if I wanted to loop thru this and place in a table all the awards any of my members have. One line for each award and it's description.

$result3 = $db->sql_query("SELECT 'award_name', 'award_description' FROM roster_awards a JOIN roster_profile b WHERE a.award_id = b.award_id");
while ( $row = $db->sql_fetchrow($result3) ) {
   $awardname = $row["award_name"];
   $awarddetail = $row["award_decription"];
if (!$result3) {
   echo("<p>Error performing query: " . mysql_error() . "</p>");
   exit();
   }
}

Correct but you need your show html inside of the loop.

My latest is trying to get my roster to break on unit so it would list Headquarters and then the column heading then 1st Platoon and column headings, etc...

Any help is appreciated.

//begin layout of table to include loop for different units
//lists the header for the table displaying what's what

for ( $counter = 1; $counter <= 5; $counter += 1) {
$sql = "SELECT unit_id, unit_name, unit_nick FROM roster_units";
$result = $db->sql_query($sql);
while ( $row = $db->sql_fetchrow($result) ) {
      $unit_id = $row['unit_id'];
      $unit_name = $row['unit_name'];
      $unit__nick = $row["unit_nick"];

echo "<table border=0 width='100%' cellpadding='5'><tr>";
echo "<table border=0 width='100%' cellpadding='3'><tr><th width='100%'>$unit_name $unit_nick</th>";
echo "<table border=0 width='100%' cellpadding='3'><tr><th width='10%'>Rank</th><th width='15%'><b>Name</b></th><th width='20%'>Weapon</th><th width='25%'>Position</th><th width='15%'>ICQ</th><th width='20%'>Status</th>";
echo "</tr>";
}

$sql = "SELECT a.u_handle, a.u_rank, a.uniqueid, a.unit, a.weapon, a.position, a.icq, a.status, b.rank_image, b.rankname FROM roster_members a, roster_ranks b WHERE a.unit_id = $counter ORDER BY b.rank_id";
$result = $db->sql_query($sql);
while ( $row = $db->sql_fetchrow($result) ) {
      $rankname = $row['rankname'];
      $ri = $row['rank_image'];
      $hname = $row["u_handle"];
   $uid = $row["uniqueid"];
      $weapon = $row["weapon"];
   $position = $row["position"];
   $icq = $row["icq"];
   $status = $row["status"];
      if ($row["rank_image"] =="") {
$ri = " ;;";
} else {
$ri = "<img src='modules/roster/images/ranks/$row[rank_image]'>";

   }

//fill the table with values from roster
echo "<td width='10%' class='row1' align='center'>$ri</td><td class='row1' width='25%'><a class=\"mainroster\" href=\"modules.php?name=$module_name&file=rosterprofile&handlename=$uid\">$hname</a><td width='20%' class='row1' align='center'>$weapon</td><td width='25%' class='row1' align='center'>$position</td><td width='15%' class='row1' align='center'>$icq</td><td width='20%' class='row1' align='center'>$status</td>";
echo "</tr>";
}

echo "</table><br /><hr noShade>";
}
//end of the rank loop

CloseTable();
include("footer.php");
?>

Bump.

Any ideas out there on how I could get this to work.

If I break my roster up by unit, I think it would look a whole lot better.
[ Register or login to view links on this board. ]

Is my logic right setting up the for loop?

Your stopping the top loop after the $unit_name $unit_nick so that onle gets shown once? Or is it supposed to be the top of each section?

Whats the

for ( $counter = 1; $counter <= 5; $counter += 1) {

Originally posted by Telli @ Fri Nov 05, 2004 4:27 pm:

Your stopping the top loop after the $unit_name $unit_nick so that onle gets shown once? Or is it supposed to be the top of each section?

Whats the

for ( $counter = 1; $counter <= 5; $counter += 1) {

The for is another type of array. It will stop the code after 5 times through the loop.

Originally posted by aUsTiN @ Fri Nov 12, 2004 6:38 am:

The for is another type of array. It will stop the code after 5 times through the loop.

Really?

LOL I was asking what he was using it for as he doesn't need it.