Multiple Query within one results

Trackignis

$query = "SELECT DISTINCT USER_NAME, ROLE FROM FOX_MASTER_ROLE_OF_USERS ORDER BY ROLE, USER_NAME"; 
			$result = mysql_query($query) or die(mysql_error());
			echo "<br />";
			echo "<table>";
			while($row = mysql_fetch_array($result))
			{
			echo "<tr>";
			echo "<td width=200>" . $row['USER_NAME']. "</td><td width=200>". $row['ROLE']. "</td width=200><td>". "<a href=javascript:confirmDelete('delete.php?id=$row[ID]')>[Delete]</a></td>" ;		

		echo "</tr>";
		}
		echo "</table>";

		?>

I have the above, there are duplicates in the table so i use Distinct, But as in the table i have an ID coloum i cant select that while using distinct but i need it to pass it on as a variable to the $row[ID]

How can i do this?

messels

Trackignis;10903704 wrote:

$query = "SELECT DISTINCT USER_NAME, ROLE FROM FOX_MASTER_ROLE_OF_USERS ORDER BY ROLE, USER_NAME"; 
			$result = mysql_query($query) or die(mysql_error());
			echo "<br />";
			echo "<table>";
			while($row = mysql_fetch_array($result))
			{
			echo "<tr>";
			echo "<td width=200>" . $row['USER_NAME']. "</td><td width=200>". $row['ROLE']. "</td width=200><td>". "<a href=javascript:confirmDelete('delete.php?id=$row[ID]')>[Delete]</a></td>" ;		

		echo "</tr>";
		}
		echo "</table>";

		?>

while($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{
...
echo "<td width=200>".$row['ID']...";
...
}

i'd also ditch the table. tables are SO 1999. divs are all you need. makes for way cleaner code.

scrupul0us

messels;10903738 wrote:
...divs are all you need...

you mean you don't use the matrix :eek:

Trackignis

Tables are used so its easier to extract the data once everything is filled in.

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
...
echo "<td width=200>".$row['ID']...";
...
}

That dont work 🙁

laserlight

Trackignis wrote:
I have the above, there are duplicates in the table so i use Distinct, But as in the table i have an ID coloum i cant select that while using distinct but i need it to pass it on as a variable to the $row[ID]

You should tell us your relevant database schema and what exactly you want to select and display.

messels wrote:
i'd also ditch the table. tables are SO 1999. divs are all you need.

That is rubbish. Tables should be used to display tabular data. Considering that Trackignis appears to want to display a list of names and corresponding roles, it could be the case that the data is tabular. If not, then instead of div elements, list and related elements should be used, since at the very least we are dealing with a list.