using a field to list?

kaos057

I am still fairly new and need some help on this one. I am making a character roster which is ordered by class, but each class has about 100 lines of code. I want to make it so it cycles through the "class" field, and when it sees a new class, it does those 100 lines, then starts over and looks for the next class. Keep in mind that under the "class" column in the database there will be multiple fields with the same data which is pretty much why im stumped. Maybe some kind of mysql_fetch_? with something that makes it only use identical info once? All help on this will be very much appreciated.

😕

jnuneznyc

First post the table structure and then post whatever code you might have or at least illustrate what you want displayed.

kaos057

$result = mysql_query("SELECT * FROM profiles WHERE class = 'bard'",$db);

if ($myrow = mysql_fetch_row($result)) {

echo "<img src=bards.jpg>\n";

echo "<table align=center>\n";

do {

             printf("<tr><th width=200><font size=2><a href=\"acroproster.php?id=%s\">%s</th><th width=15><font size=2>%s</th><th width=20><font size=2> +%s</th>\n",
              $myrow[0], $myrow[1], $myrow[3], $myrow[6]);

} while ($myrow = mysql_fetch_row($result));

echo "</table><br><br>\n";

}

that is how i have it now. after this is identical code except the class name to put the next class on the page. What i want to do is instead of doing this code over and over for each class, I want to have a line or two that will make it do this code again but use the next class until there are no more classes. The db looks similar to this

id name password lvl class race

1 john g36fh56dg 23 bard human
2 joe 43j5hgkj45 45 bard human
3 chris 43kj5hg34 43 cleric human

as you can see some rows have the same class so it would need to know to only do each class once.

kaos057

bump

ahundiak

First do a query to get a list of classes.

SELECT DISTINCT class FROM profiles;

The DISTINCT keyword ensures you get back one and only one record for each class.Cycle through the results and process each class.