PHP Looping

Greyfish0620

Hey everybody! I'm working on a "Meet the Staff" page for my church and I have all the staff members listed in a MySQL database. The staff members are separated into 4 groups: Senior Pastor, Pastoral Staff, Church Staff, and Facilities. You can see here how I'm seperating each group. Each group except for the "Senior Pastor" group will have more than 1 member, so how can I create a PHP loop that will display each member in their correct category? Here is my coding so far...

<?php
while ($array= mysql_fetch_assoc($result)){
$completeTitle ="$array[name] $array[title]";
$nameLength = strlen($completeTitle) * 10.5;
$difference = 330 - $nameLength;
$margin = $difference / 2 + 25;
$titleName ="$array[name] - $array[title]";

if ($array[category] == senior){
echo "<div id=\"seniorPastor\"><!--Start: Senior Pastor-->\n";
echo "<img src =\"http://development.ccgulfbreeze.com/about/staff/images/$array[image].jpg\" width=\"106\" height=\"152\" class=\"staffPicture\" alt=\"$titleName\"/>\n";
echo "<img src=\"http://development.ccgulfbreeze.com/about/staff/includes/staffName.php?txt=$titleName&margin=$margin\" alt=\"$titleName\"/>\n";
echo "<p id=\"biography\">\n";
echo $array[bio];
echo "</p>\n";
echo "<div id=\"contactStaff\"><a href=\"http://www.ccgulfbreeze.com/contact/index.php?who=$array[name]\">Contact $array[name]</a></div>\n";
echo "</div><!--End: Senior Pastor-->\n";
}

if ($array[category] == pastoral){
echo "<div id=\"pastoralStaff\"><!--Start: Pastoral Staff-->\n";
echo "<img src =\"http://development.ccgulfbreeze.com/about/staff/images/$array[image].jpg\" width=\"106\" height=\"152\" class=\"staffPicture\" alt=\"$titleName\"/>\n";
echo "<img src=\"http://development.ccgulfbreeze.com/about/staff/includes/staffName.php?txt=$titleName&margin=$margin\" alt=\"$titleName\"/>\n";
echo "<p id=\"biography\">\n";
echo $array[bio];
echo "</p>\n";
echo "<div id=\"contactStaff\"><a href=\"http://www.ccgulfbreeze.com/contact/index.php?who=$array[name]\">Contact $array[name]</a></div>\n";
echo "</div><!--End: Pastoral Staff-->\n";
}

}
?>

bogu

U sould give use the DB table(s) structure if u want us to help u with the select query since u start this thread at the DATABASE section, if u want us to help u to output an array u should give us the array structure (try [man]print_r[/man] the array) and based on your array structure how you want it to be displayed.

jib0

You should sort your DB by category and then add a $current_category variable in your loop and write something like:

$current_category = '';
while ($array = mysql_fetch_assoc($result)) {
  if ($array[category] != $current_category) {
    PRINT_CATEGORY_TITLE, ETC.
    $current_category = $array[category];
  }

  PRINT_MEMBER
}

Good luck!

Greyfish0620

I attached a Word Document of my database structure below...

bogu

Parsing the mysql results you could create an array with your results something like this:

$results['senior'][0] = array('name'=>'John Spencer',..);
$results['senior'][1] = array('name'=>'...',..);
...
$results['senior'][n] = array('name'=>'...',..);
$results['pastoral'][0] = array('name'=>'Bob Rockwell',..);
$results['pastoral'][1] = array('name'=>'Joe Prestridge',..);
...
$results['pastoral'][m] = array('name'=>'...',..);
$results['other_group'][0] = array('name'=>'...',..);
...
$results['other_group'][k] = array('name'=>'...',..);

Creating this array is not so hard, you can do it something like this:

$results = array();
while ($rows= mysql_fetch_assoc($result)){
	$categ = $rows['category']; unset($rows['category']);
	$results[$categ][] = $rows;
}

this will produce the array I listed above ...

Using a [man]foreach[/man] you can easily output your results the way you want ...