Members";
$result = mysqli_query($db, "SELECT * FROM memberbio") or die(mysqli_error());
echo "
See More...
See More...
![](\"$row2[thumbpic]\")
";
}
}
}
elseif ($safe_action == 'viewbio')
{
$result = mysqli_query($db, "SELECT * FROM memberbio WHERE id=$id")
or die(mysqli_error());
$row = mysqli_fetch_assoc($result);
echo "
";
}
elseif ($safe_action == 'viewint')
{
$result = mysqli_query($db, "SELECT * FROM interviews WHERE id=$id") or die(mysqli_error());
$row = mysqli_fetch_assoc($result);
$intBody = $row['body'];
$intBody=str_replace("\n","
|
| ";
}
}
?>
See More...
Recently Added Interviews
Source |
Member |
Year |
$row2[title] | ";
if (!$row2['sourcesite'])
{
echo "$row2[source] "; } else { echo "$row2[source] "; } echo " | " . $row2['member'] ." | "; $dateof = substr($row2['dateof'], 0, 4); echo "". $dateof ." |
Current Members
"; $result = mysqli_query($db, "SELECT * FROM memberbio") or die(mysqli_error()); echo "|
| ";
}
}
?>
Ex-Members
"; $result2 = mysqli_query($db, "SELECT * FROM memberbio") or die(mysqli_error()); while ($row2 = mysqli_fetch_assoc($result2)) { if ($row2['status'] == "ex") { echo "$row[name]
"; echo "";
echo "![](\"$row[picdisplay]\")
";
echo "
";
echo "";
echo "position | $row[position]
"; echo "status of membership |"; if ($row['status'] == 'ex') { echo " Ex-Member"; } else { echo " Current Member"; } echo "
"; echo "albums | $row[albums]
"; echo "other bands | $row[formerbands]
"; echo "
";
}
elseif ($safe_action == 'int')
{
if(isset($safe_sort))
{
if($safe_sort == 'date')
{
$result = mysqli_query($db, "SELECT * FROM interviews ORDER BY dateof DESC") or die(mysqli_error());
}
elseif($safe_sort == 'member')
{
$result = mysqli_query($db, "SELECT * FROM interviews ORDER BY member") or die(mysqli_error());
}
}
else
{
$result = mysqli_query($db, "SELECT * FROM interviews ORDER BY id DESC") or die(mysqli_error());
}
echo ""; echo "status of membership |"; if ($row['status'] == 'ex') { echo " Ex-Member"; } else { echo " Current Member"; } echo "
"; echo "albums | $row[albums]
"; echo "other bands | $row[formerbands]
"; echo "
Interviews
"; echo "Sort by Date Added | Year | Member"; echo"
Source |
Member |
Year |
|
| $row[title] | ";
if (!$row['sourcesite'])
{
echo "$row[source] "; } else { echo "$row[source] "; } echo " | " . $row['member'] ." | "; $dateof = substr($row['dateof'], 0, 4); echo "". $dateof ." |
", $intBody); echo "
$row[title]
"; echo "";
if (!$row['sourcesite'])
{
echo "$row[source]
"; } else { echo "$row[source]
"; } echo "Interview with $row[member]
"; echo "$intBody"; echo "
"; echo "
";
}
?>
"; } else { echo "$row[source]
"; } echo "Interview with $row[member]
"; echo "$intBody"; echo "
"; echo "