Removing duplicate results

CraniumDesigns

Check out http://craniumdesigns.com/classes.php

Here is the code:

$query = mysql_query("SELECT * FROM roster ORDER BY pledge_class");
while($row = mysql_fetch_array($query)){							
echo "<a href=class_listing.php?pledge_class=".$row[pledge_class].">".$row[pledge_class]."</a><br>";

How do I remove the duplicate categories? Like those 3 MT'S? I only want one unique category result to show up.

TheDefender

Grouping with the GROUP BY clause...

$query = mysql_query("SELECT * FROM roster GROUP BY pledge_class ORDER BY pledge_class");

CraniumDesigns

thanks fellow christian!

TheDefender

You're welcome. God Bless You!

CraniumDesigns

how do i format the date? never done it before.

here's my code:

echo "<table border=1 cellpadding=3><tr><td><b>Name</b></td><td><b>Address</b></td><td><b>Birth Date</b></td><td><b>Phone No.</b></td><td><b>Email Address</b></td><td><b>AIM SN</b></td></tr>";

$query = mysql_query("SELECT * FROM roster WHERE pledge_class = '$pledge_class' ORDER BY first_name");
while($row = mysql_fetch_array($query)) {

	echo "<tr>";
	echo "<td>".$row[first_name]." ".$row[last_name]."</td>";
	echo "<td>".$row[street]."<br>".$row[city].", ".$row[state]." ".$row[zipcode]."</td>";
	echo "<td>".$row[dob]."</td>";
	echo "<td>".$row[phone]."</td>";
	echo "<td>".$row[email]."</td>";
	echo "<td>".$row[aim]."</td>";
	echo "</tr>";

}

echo "</table>";

the date is currently at 1982-05-06. how would i format it to be like 5/6/1982? thanks.

TheDefender

The strtotime function only works with dates after Jan 1, 1970, so if your dates are before that, let me know, so I can show you how to explode() the date, and recompile it that way instead...

$date = "1982-05-06";
$date = date("n/j/Y", strtotime($date));
echo $date;

Weedpacket

MySQL also has a DATE_FORMAT function, which (assuming that the date has been stored in a date/time type), can be used to reformat the date as desired within the query itself.