Mysql, Deleting User

chugger93

Im trying to print out my user list, and have delete buttons next to them, so I can delete them. I cannot get this to work for the life of me. If I use the while($row = mysql_fetch_array($sql2)) it will grab the users listing fine. But it wont delete the user when you hit the button. However if i use while($row = mysql_fetch_object($sql2)), then the button deletes the user perfectly, but you cant see the users information.

echo "<table align=center cellpadding=1 cellspacing=0 bgcolor=#EEEEEE border=1 width=70%>";
echo "<tr>
  <td><font style='font-family: Verdana; font-size: 12px;'><b>Full Name</b></font></td>
   <td><font style='font-family: Verdana; font-size: 12px;'><b>Username</b></font></td>
    <td><font style='font-family: Verdana; font-size: 12px;'><b>E-mail</b></font></td>
    <td><font style='font-family: Verdana; font-size: 12px;'><b>Username To Delete?</b></font></td></tr>";


$sql1 = "SELECT id, real_name, username, email
        FROM user
        ORDER BY id ASC";
$sql2 = mysql_query($sql1);
while($row = mysql_fetch_object($sql2)){

while($row = mysql_fetch_array($sql2)){
$real_name = $row["real_name"];
$username = $row["username"];
$email = $row["email"]; 
}

echo "<tr>
<td valign='top'><font style='font-family: Verdana; font-size: 12px;'>$real_name</font></td>
<td valign='top'><font style='font-family: Verdana; font-size: 12px;'>$username</font></td>
<td valign='top'><a href=\"mailto:$email\"><font style='font-family: Verdana; font-size: 11px;'>$email</font></a>
<td valign='bottom'>"; 	

echo "
<td class=norText><input type=button value='Delete' class=norText onClick=\"if(confirm('Delete User Permantely?')) window.location='module/admin_delete.php?ID=$row->ID';\">
</td>
";

}

?>

andrewtayloruk

mysql_fetch_object brings the recordset back as an object. You can access the items like this

$row->ID;

mysql_fetch_array brings back the recordset as an array, you can access like this

$real_name = $row["real_name"];

You can't mix and match.

echo "<table align=center cellpadding=1 cellspacing=0 bgcolor=#EEEEEE border=1 width=70%>";
echo "<tr>
  <td><font style='font-family: Verdana; font-size: 12px;'><b>Full Name</b></font></td>
   <td><font style='font-family: Verdana; font-size: 12px;'><b>Username</b></font></td>
    <td><font style='font-family: Verdana; font-size: 12px;'><b>E-mail</b></font></td>
    <td><font style='font-family: Verdana; font-size: 12px;'><b>Username To Delete?</b></font></td></tr>";


$sql = "SELECT id, real_name, username, email
        FROM user
        ORDER BY id ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)){

echo "<tr>
<td valign='top'><font style='font-family: Verdana; font-size: 12px;'>$row['real_name']</font></td>
<td valign='top'><font style='font-family: Verdana; font-size: 12px;'>$row['username']</font></td>
<td valign='top'><a href=\"mailto:$row['email']\"><font style='font-family: Verdana; font-size: 11px;'>$row['email']</font></a>
<td valign='bottom'>";     

echo "
<td class=norText><input type=button value='Delete' class=norText onClick=\"if(confirm('Delete User Permantely?')) window.location='module/admin_delete.php?ID=$row['id'];\">
</td>
"; 

}

chugger93

Oh ok. So which is the better route? I tried your method and got this

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/closin2/public_html/passwords/module/section_users.php on line 101

a4arpan

echo "<table align=center cellpadding=1 cellspacing=0 bgcolor=#EEEEEE border=1 width=70%>";
echo "<tr> <td>Full Name</td> <td>Username</td> <td>E-mail</td> <td>Username To Delete?</td></tr>";

$sqlUser = "SELECT id, real_name, username, email FROM user ORDER BY id ASC";
$resUser = mysql_query($sqlUser);
while($arrUser = mysql_fetch_array($resUser))
{

echo "<tr> <td valign='top'><font style='font-family: Verdana; font-size: 12px;'>".$arrUser['real_name']."</font></td> <td valign='top'><font style='font-family: Verdana; font-size: 12px;'>".$arrUser['username']."</font></td> <td valign='top'><a href=\"mailto:".$arrUser['email']."\"><font style='font-family: Verdana; font-size: 11px;'>".$arrUser['email']."</font></a> <td valign='bottom'>";      

echo "<td class=norText><input type=button value='Delete' class=norText onClick=\"if(confirm('Delete User Permantely?')) window.location='module/admin_delete.php?ID=".$arrUser['id'].";\"> </td> ";

}