$sSql = "select ";
$sSql = $sSql. "FM_Id, First_Name, FN_Display, Last_Name, LN_Display, Company, Position, Salary, Sal_Display, Picture_Orig, Pic_Display, appStatus ";
$sSql = $sSql. "From fashionmeet order by FM_Id asc ";
$result=mysql_query($sSql);
$i =1;
while ($row = mysql_fetch_array($result))
{
$appStatus = "";
if($row['appStatus']=="Y")
$appStatus = "Accepted";
else if($row['appStatus']=="N")
$appStatus = "Rejected";
$i++;
if($i%2==0)
$rowClass="
";
else
$rowClass="
";
$sPhotopath = "./photos/" . $row['Picture_Orig'];
if(($row['Pic_Display']=="N")&&(file_exists($sPhotopath)))
{
$sPhoto = "./photos/" . $row['Picture_Orig'];
//get the image size of the picture and load it into an array
$mysock = getimagesize($sPhoto);
// $thump = "
";
$thump = "
";
}
else
$thump = "
";
if($row['FN_Display']=="N" && $row['LN_Display']=="N")
$Name = "
" . $row['First_Name'] . " " . $row['Last_Name'] . "
";
if($row['FN_Display']=="N" && $row['LN_Display']=="Y")
$Name = "
" . $row['First_Name'] . "
";
$Company = "
" . $row['Company'] ."
";
$Position = "
" . $row['Position'] ."
";
if($row['Sal_Display']=="N")
$Salary = "
" . $row['Salary'] . "
";
else
$Salary = "
";
$Accepted = "
" . $appStatus."
";
$Clear = "
";
echo $rowClass;
echo $thump;
echo $Name;
echo $Company;
echo $Position;
echo $Salary;
echo $Accepted;
echo $Clear;
}
?>