[RESOLVED] Grouping MySql in drop down boxes

[chalex90]

Hello kind users of PHPBuilder.
I'm having a bit if touble loading MySQL into a drop down box.
What I want is to display just one record for each different bit of information.

so at the moment i have:
TEST
TEST
TEST
TEST1
TEST1
TEST1
TEST1
TEST2

displaying in my drop down box and i want this:
TEST
TEST1
TEST2

I'm using the below code with no prevail.

<option value="other" selected="selected">Other:</option>
		<?
        $projectsql=mysql_query("SELECT type FROM some_DB GROUP BY type ASC LIMIT 1");
	if ($projectsql){
			$project = mysql_fetch_array($projectsql);
			$prjctchk = mysql_num_rows ($prjctsql);
		while($prjctchk < 0) { 


			?>
				<option value="<? echo $project['type']; ?>"><? echo $project['type']; ?></option>
		<?

		};
		?>

    <?
}else{
	echo mysql_error();
};

Any help appreciated!!

[bradgrafelman]

For one, you should start using the full "<?php" opening tag and never use the "<?" (or "<?=(expression);?>") short tag as the latter has been deprecated and disabled by default for some time now.

Also note that you aren't looping through the result set properly; each call to the mysql_fetch_*() functions will return one row at a time (moving the internal pointer on to the next row). See the PHP manual page for [man]mysql_fetch_array/man for examples. Even better, see the page for [man]mysql_fetch_assoc/man instead since you don't use the numerical array indexes and instead only need an associative array.

[chalex90]

Cheers, dunno wtf iwas doin with tht one tbh.
Never code stoned