Well, I don't know all your database, but here's a sample script I would use:
if (!logged_in)
{
$query1 = mysql_query("SELECT * FROM membersinfo WHERE id = 'president'");
while ($row = mysql_fetch array($sql))
{
echo "<tr>
<td>$sub_office</td>
<td>$fname $lname</td>
<td>$hphone / $cphone</td>
<td>$eml</td>
<td>$adress, $cty, $st $zp</td>
<td>$sub_name</td>
</tr>";
}
} elseif (logged_in)
{
$query2 = mysql_query("SELECT * FROM membersinfo");
while ($row = mysql_fetch array($sql))
{
echo "<tr>
<td>$sub_office</td>
<td>$fname $lname</td>
<td>$hphone / $cphone</td>
<td>$eml</td>
<td>$adress, $cty, $st $zp</td>
<td>$sub_name</td>
</tr>";
}
}
Last edited by Demiloy; Aug 7th, 2008 at 11:00 am.