<
?php
require_once('upper.php');
require_once('database.php');
require_once('LoginStatement.php');
$LoginId=$_COOKIE['LoginIdCookie'];
$query="select * from activity_participation where LoginId='$LoginId'";
$result=mysqli_query($dbc,$query) or die ('Not Connected');
//echo "<div class='search_output_data'>
echo "<table border='0' cellspacing='0' cellpadding='0'>";
while($row=mysqli_fetch_array($result))
{
echo "<tr><th align='left' valign='top'>Activity Title</th>
<th align='left' valign='top'>Date of Participation</th>
</tr>
<tr><td colspan='4' align='left' valign='top'><table align='left' border='0' cellspacing='0' cellpadding='0'><tr><td align='left' valign='top'>".$row['Title']."</td> <td align='left' valign='top'>".$row['Date']."</td> </tr></table>
</td></tr>";
}
echo "</table>";
//echo "</div>";
require_once('lower.php');
?>
In table activity_participation many rows have same values. I want to display only different rows to user not to display same rows again and again.
Or Anybody have idea to prevent the row duplication in database....
Help me please.........
thanks in advance.............