Board index   FAQ   Search  
Register  Login
Board index PHP PHP General

query not displaying all results

General discussions related to php

Moderators: macek, egami, gesf

query not displaying all results

Postby mricketts » Fri Dec 20, 2013 3:50 pm

I have a database with 3 tables. One table contains people, the other table contains categories and the third table is the many to many relationship table. My php file is a report showing all the people in each category. For some reason, my query is not displaying the first record in each category and I can't figure out how to fix it.

Code: Select all

<?php require_once('Connections/meritBadges.php');
$result = mysql_query('SELECT id, badge_name FROM meritbadgestable ORDER BY badge_name');

while ($row = mysql_fetch_array($result)) {
   $badgenumber = $row['id'];


$badgename = mysql_query("SELECT id, badge_name FROM meritbadgestable WHERE id=$badgenumber");
while($badge = mysql_fetch_array($badgename))

  { $badge_name = $badge['badge_name'];
  }


$counselors = mysql_query("SELECT id, firstname, lastname, counselorid, meritbadgeid FROM counselorstable, meritbadgetocounselortable WHERE id=counselorid AND meritbadgeid='$badgenumber' ORDER BY lastname");

$counselor = mysql_fetch_array($counselors);

if(empty($counselor)){echo '<h2>Merit Badge: ' . $badge_name . '</h2><p class="counselortable">There are no counselors for this merit badge.</p>';
}
   else {echo '<h2>Merit Badge: ' . $badge_name . '</h2>

   <table width="950" border=1 cellpadding="2" cellspacing="0" class="counselorstable">
     <tr id="tabletop">
       <td width="162" bgcolor="#000000">ID</td>
       <td width="160" bgcolor="#000000">Name</td>
   </tr>';}

while ($counselor = mysql_fetch_array($counselors)) {
  echo "<tr valign='top'>\n";
  $id = htmlspecialchars($counselor['id']);
  $firstname = htmlspecialchars($counselor['firstname']);
  $lastname = htmlspecialchars($counselor['lastname']);

  echo "<td>$id</td>\n";
  echo "<td>$firstname $lastname</td>\n";
  echo "</tr>\n";
}

  echo '</table><br />';


}
?>


mricketts
New php-forum User
New php-forum User
 
Posts: 2
Joined: Fri Dec 20, 2013 3:47 pm

Return to PHP General

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.