We are busy adding Parish Rep & Contact Info for each Parish.
Please email any additions or changes to Tony Provost
"; $i=0; /* This is order of the columns in the parishreps table. They correspond to the values in the $row[] array. `RID` int(10) unsigned NOT NULL auto_increment, `Parish` varchar(50) NOT NULL default '', `Parish_City` varchar(40) NOT NULL default '', `Title` varchar(40) NOT NULL default '', `Name` varchar(40) NOT NULL default '', `Address` varchar(40) NOT NULL default '', `City` varchar(40) NOT NULL default '', `State` char(2) NOT NULL default '', `ZIP` varchar(10) NOT NULL default '', `Phone` varchar(12) NOT NULL default '', `email` varchar(40) NOT NULL default '', `Notes` varchar(254) NOT NULL default '', */ $query = "SELECT * from `parishreps` where Parish_City like 'A%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'B%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'C%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'D%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'F%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'G%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'H%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'I%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'L%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'M%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'N%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'O%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'P%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'R%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'S%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'T%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'W%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |
"; $i=0;$list[]=''; $query = "SELECT * from `parishreps` where Parish_City like 'Y%' order by Parish_City, Parish, Title desc, Name"; $mysql_result = mysql_query($query,$mysql_link); $prevCity = ""; $prevParish = ""; while ($row = mysql_fetch_array($mysql_result)) { $sameParish = ($prevCity == $row[2] && $prevParish == $row[1]) ; if ($sameParish) { $i--; $entry = $list[$i]; } else { if ($i > 0) { $list[$i-1] = $list[$i-1] . "
"; }
$entry = "$row[2] - $row[1]";
}
$list[$i]=$entry . "
$row[4] - $row[9] - $row[10]";
$i++;
$prevCity = $row[2];
$prevParish = $row[1];
}
$x = round(($i));
print"
| $list[$y] |