ankit.pandeyc012 Posted December 15, 2010 Share Posted December 15, 2010 <?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............. Quote Link to comment https://forums.phpfreaks.com/topic/221746-i-want-to-prevent-the-display-of-repeated-row-in-database/ Share on other sites More sharing options...
Adam Posted December 15, 2010 Share Posted December 15, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/221746-i-want-to-prevent-the-display-of-repeated-row-in-database/#findComment-1147614 Share on other sites More sharing options...
Adam Posted December 15, 2010 Share Posted December 15, 2010 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"; Quote Link to comment https://forums.phpfreaks.com/topic/221746-i-want-to-prevent-the-display-of-repeated-row-in-database/#findComment-1147616 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.