Code: Select all
<?php
require 'open_db.php';
if (isset($_POST['submit_3']))
{
$LN=$_POST['markLN'];
$query = "SELECT * FROM initials WHERE LN ='$markLN'";
$result = mysql_query($query) or die(mysql_error());
$check = '0';
while($row = mysql_fetch_assoc($result))
{
if ($check % 2 == 0)
{
$text1 .= '<tr width="970">';
}
else
{
$text1 .= '<tr bgcolor="#F89858">';
}
$text1 .= '<td width="96" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row['candidateID'].'</span></td>';
$text1 .= '<td width="226" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row['FN'].' '.$row['LN'].'</span></td>';
$text1 .= '<td width="206" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row['email'].'</span></td>';
$text1 .= '<td width="76" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><b>'.$row['progress'].'</b></span></td>';
$text1 .= '<td width="106" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row['add_date'].'</span></td>';
$text1 .= '<td width="96" align="center" valign="middle" style="padding-left: 15px;"><span class="style1"><a href="view_mark.php?ID='.$row['ID'].'" class="style1">View Mark</a></span></td>';
$text1 .= '</tr>';
$check ++;
}
if($check == 0)
{
$text1 .= '<tr width = "970">';
$text1 .= '<td align="center" width="100%"><span class="style1"><b>No Matches found!</b></span></td>';
$text1 .= '</tr>';
}
echo $text1;
}
elseif (isset($_POST['submit_4']))
{
$home_1=$_POST['home_1'];
$home_2=$_POST['home_2'];
$home_3=$_POST['home_3'];
$query = "SELECT * FROM initials WHERE home_1 ='$home_1' AND home_2 ='$home_2' AND home_3 ='$home_3'";
$result = mysql_query($query) or die(mysql_error());
$check = '0';
while($row1 = mysql_fetch_assoc($result))
{
if ($check % 2 == 0)
{
$text2 .= '<tr width="970">';
}
else
{
$text2 .= '<tr bgcolor="#F89858">';
}
$text2 .= '<td width="74" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row1['candidateID'].'</span></td>';
$text2 .= '<td width="224" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row1['FN'].' '.$row1['LN'].'</span></td>';
$text2 .= '<td width="204" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row1['email'].'</span></td>';
$text2 .= '<td width="144" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><b>'.$row1['progress'].'</b></span></td>';
$text2 .= '<td width="84" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row1['add_date'].'</span></td>';
$text2 .= '<td width="64" align="center" valign="middle" style="padding-left: 15px;"><span class="style1"><a href="view_mark.php?ID='.$row1['ID'].'" class="style1">View Mark</a></span></td>';
$text2 .= '</tr>';
$check ++;
}
if($check == 0)
{
$text2 .= '<tr width = "970">';
$text2 .= '<td align="center" width="100%"><span class="style1"><b>No Matches found!</b></span></td>';
$text2 .= '</tr>';
}
echo $text2;
}
elseif (isset($_POST['submit_5']))
{
$cell_1=$_POST['cell_1'];
$cell_2=$_POST['cell_2'];
$cell_3=$_POST['cell_3'];
$query = "SELECT * FROM initials WHERE cell_1 ='$cell_1' AND cell_2 ='$cell_2' AND cell_3 ='$cell_3'";
$result = mysql_query($query) or die(mysql_error());
$check = '0';
while($row2 = mysql_fetch_assoc($result))
{
if ($check % 2 == 0)
{
$text3 .= '<tr width="970">';
}
else
{
$text3 .= '<tr bgcolor="#F89858">';
}
$text3 .= '<td width="74" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row2['candidateID'].'</span></td>';
$text3 .= '<td width="224" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row2['FN'].' '.$row2['LN'].'</span></td>';
$text3 .= '<td width="204" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row2['email'].'</span></td>';
$text3 .= '<td width="144" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><b>'.$row2['progress'].'</b></span></td>';
$text3 .= '<td width="84" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row2['add_date'].'</span></td>';
$text3 .= '<td width="64" align="center" valign="middle" style="padding-left: 15px;"><span class="style1"><a href="view_mark.php?ID='.$row2['ID'].'" class="style1">View Mark</a></span></td>';
$text3 .= '</tr>';
$check ++;
}
if($check == 0)
{
$text3 .= '<tr width = "970">';
$text3 .= '<td align="center" width="100%"><span class="style1"><b>No Matches found!</b></span></td>';
$text3 .= '</tr>';
}
echo $text3;
}
elseif (isset($_POST['submit_6']))
{
$email=$_POST['email'];
$query = "SELECT * FROM initials WHERE email ='$email'";
$result = mysql_query($query) or die(mysql_error());
$check = '0';
while($row3 = mysql_fetch_assoc($result))
{
if ($check % 2 == 0)
{
$text4 .= '<tr width="970">';
}
else
{
$text4 .= '<tr bgcolor="#F89858">';
}
$text4 .= '<td width="74" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row3['candidateID'].'</span></td>';
$text4 .= '<td width="224" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row3['FN'].' '.$row3['LN'].'</span></td>';
$text4 .= '<td width="204" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row3['email'].'</span></td>';
$text4 .= '<td width="144" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><b>'.$row3['progress'].'</b></span></td>';
$text4 .= '<td width="84" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1">'.$row3['add_date'].'</span></td>';
$text4 .= '<td width="64" align="center" valign="middle" style="padding-left: 15px;"><span class="style1"><a href="view_mark.php?ID='.$row3['ID'].'" class="style1">View Mark</a></span></td>';
$text4 .= '</tr>';
$check ++;
}
if($check == 0)
{
$text4 .= '<tr width = "970">';
$text4 .= '<td align="center" width="100%"><span class="style1"><b>No Matches found!</b></span></td>';
$text4 .= '</tr>';
}
echo $text4;
mysql_close();
}
?>Code: Select all
if($check == 0)
{
$text4 .= '<tr width = "970">';
$text4 .= '<td align="center" width="100%"><span class="style1"><b>No Matches found!</b></span></td>';
$text4 .= '</tr>';
}code as the output. Can someone show me the way?
Thanks in advance,
Batoe
____________________________________________
"The road to success is filled with obstacles, but also success!"