I want to prevent the display of repeated row in database

[ankit.pandeyc012]

<?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 plz.........

thx in advance.............

[Adam]

You can use group by column_name to prevent that. Only the first row matching column_name will be returned.

 

For example, assume you have a table containing the following data:

 

col1 | col2

-----------

1    | a

1    | b

1    | c

2    | d

2    | e

2    | f

 

Using a group by on col1 would return:

 

col1 | col2

-----------

1    | a

2    | d

[Adam]

Just to be clear actually, that would be added to your SQL:

 

$query="select * from activity_participation where LoginId='$LoginId' group by column_name_of_repetitive_values";