<div class="department">Date</div>
<div class="action">Action</div>
</div>
<?php
$data = mysql_query("select * from `members` where `activated`='1' && designation!=5 and designation!=8") or die(mysql_error());
if(mysql_num_rows($data)>0)
{
while($row = mysql_fetch_object($data))
{
?>
<div class="log_row">
<div class="serial_no"><?php $fname = $row->first_name; $lname=$row->last_name; echo ucwords($fname); echo " "; echo " "; echo ucwords($lname); ?></div>
<div class="user_name"><?php echo $row->email_id; ?></div>
<div class="first_name"><?php $contact = $row->contact_number; if($contact!=""){echo $contact;}else{echo "Not Avail";} ?></div>
<div class="last_name"><?php $city=$row->state; if($city!="") {echo $desg->GetStatebyStateCode($city).","; echo $row->city.","; echo $row->address.","; echo $row->zip_code.","; }else{echo "Not Avail";}?></div>
<div class="email_address"><?php $desgd= $row->designation; echo $desg->getRoleByRoleId($desgd); ?></div>
<div class="organisation"><?php $org = $row->organisation; if($org!=""){echo $org;}else{echo "Not Avail";} ?></div>
<div class="department"><?php $date_time = $row->date_time; echo date('h:i:s:a',strtotime($date_time)); ?></div>
<div class="department"><a href="action.php?data=<?=$row->id?>">Delete/Update</a></div>
</div>
<?php
}
?>
</div>
<?php
}
else
{
echo "<h1>Not Found</h1>";
}
?>
?>
</div>
<div class="last_name">
<?php
$city = $row->state;
if ($city != "") {
echo $functions->GetStatebyStateCode($city) . ",";
echo $row->city . ",";
echo $row->address . ",";
echo $row->zip_code . ",";
}
?>
</div>
<div class="email_address"><?php
$desg = $row->designation;
echo $functions->getRoleByRoleId($desg);
?>
</div>
<div class="organisation"><?php
echo $row->organisation;
?>
</div>
<div class="department"><?php
$date_time = $row->date_time;
echo date('h:i:s:a', strtotime($date_time));
?>
</div>
<div class="action"><a href="action.php?data=<?php
echo $row->id;
?>
">Delete/Update</a></div>
</div>
<div class="last_name"><?php
$city = $row->state;
if ($city != "") {
echo $desg->GetStatebyStateCode($city) . ",";
echo $row->city . ",";
echo $row->address . ",";
echo $row->zip_code . ",";
} else {
echo "Not Avail";
}
?>
</div>
<div class="email_address"><?php
$desgd = $row->designation;
echo $desg->getRoleByRoleId($desgd);
?>
</div>
<div class="organisation"><?php
$org = $row->organisation;
if ($org != "") {
echo $org;
} else {
echo "Not Avail";
}
?>
</div>
<div class="department"><?php
$date_time = $row->date_time;
echo date('m-d-Y h:i:s:a', strtotime($date_time));
?>
