code:


			$query_roles_assigned = mysql_query ("

			SELECT distinct  USER_NAME, ROLE

			FROM FOX_MASTER_ROLE_OF_USERS

			ORDER BY USER_NAME

			");

			

				if(mysql_error()) 

				{

				echo mysql_error() ."<br>\n";

				}  

				

			echo "<table><tr><td>";

			echo "<tr><td colspan=3><br>ROLES ASSIGNED<br>---<br></td></tr>";

			

			while($role_assigned = mysql_fetch_array($query_roles_assigned,MYSQL_BOTH))

			{	

				echo "<tr>";

				echo "<td width=250>" . $role_assigned[0] . "</td><td width=250>" . $role_assigned[1] . "</td><td width>[DELETE]</td>";

				echo "</tr>";

			}

quote:

---

Originally posted by Dan Lewis
its all an internal system for a oracle roll out. arnt really bothered about security.

So i will need to create a new colum in the table for ID's or do i use the array as the ID?

---

code:


			$query_roles_assigned = mysql_query ("

			SELECT distinct  USER_NAME, ROLE, ID

			FROM FOX_MASTER_ROLE_OF_USERS

			ORDER BY USER_NAME

			");

				if(mysql_error()) 

				{

				echo mysql_error() ."<br>\n";

				}  		

			echo "<table><tr><td>";

			echo "<tr><td colspan=3><br>ROLES ASSIGNED<br>---<br></td></tr>";

			while($role_assigned = mysql_fetch_array($query_roles_assigned))

			{	

				echo "<tr>";

				echo "<td width=250>" . $role_assigned[0] . "</td><td width=250>" . $role_assigned[1] . "</td>

				<td width><a href='delete.php?id=$role_assigned[2]'>DELETE</a></td>"; echo "</tr>";

			}

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

			?>

code:


<? include("header.inc.php"); ?>

<?

    $sql = "DELETE FROM FOX_MASTER_ROLES_OF_USERS WHERE ID='$role_assigned[2]";

    $result = mysql_query($sql);

    echo "Row deleted!";

?>

code:


<?php

      include("header.inc.php");



      $id = $_GET['id'];



      $sql = "DELETE FROM FOX_MASTER_ROLES_OF_USERS WHERE ID=$id";

      $result = mysql_query($sql);

      echo "Row deleted!";

?>

code:
<td width><a href='delete.php?id=$role_assigned[2]'>DELETE</a></td>"; echo "</tr>";

quote:

---

Originally posted by Dan Lewis
That isnt working.

This is the deleting link;

code:
<td width><a href='delete.php?id=$role_assigned[2]'>DELETE</a></td>"; echo "</tr>";

so it is taking the ID out the table and you can see the link change when you hover over it. But as soon as you go to the delete.php it wont do anything. If i put in the code Where ID=2 it deletes that row. but everything else i have tried wont work.

---

code:


<?php





$query = "SELECT USER_NAME, ROLE, ID FROM FOX_MASTER_ROLE_OF_USERS"; 

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){

	echo $row['USER_NAME']. " - ". $row['ROLE']. " - ". $row['ID']. "<a href='delete.php?id=$row[ID]'>[DELETE]</a>" ;

	echo "<br />";

}

?>

code:


<? include("header.inc.php");?>

<?php      

$ID = $_GET['id'];

$SQL = "DELETE FROM FOX_MASTER_ROLES_OF_USERS WHERE ID=".$ID; 

?>

code:


WHERE ID='".$ID."'";

code:
<? include("header.inc.php");?>



<?php      



$ID = $_GET['id'];



$SQL = "DELETE FROM FOX_MASTER_ROLES_OF_USERS WHERE ID=".$ID; 



?>