Mine

		$Query = $libmysql->Query( " SELECT * FROM `tcm_template` WHERE type = '$type' " );
			
			// Put the results into an array and change SC to the requested module
			while ( $row = mysql_fetch_array( $Query ) ) {
				
					echo $row['modname'].'<br />';
				
							
			}