hi, I managed to display records according to categories in a table. Now I wanted to make a delete function to it but the delete button did not work. If I did not select records from list/menu, the delete button can work perfectly. However, I need to select records according to category. I did not know where to put '}' of the
CODE
if(isset($_POST['display']))
Can anyone help me with this?
CODE
<head>
<style type="text/css">
div
{
width:400px;
height:650px;
overflow: scroll
}
</style>
</head>
<div>
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="spps"; // Database name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
if(isset($_POST['display']))
{
$user = $_POST["levels"];
$sql="SELECT * FROM users WHERE level = '$user' ORDER BY user_id DESC ";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="1" cellpadding="3" cellspacing="1">
<tr>
</tr>
<tr>
<td align="center" ><strong>User Id</strong></td>
<td align="center" ><strong>Category</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"><? echo $rows['user_id']; ?></td>
<td align="center"><? echo $rows['level']; ?></td>
<td align="center" ><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=admin_submituser.php\">";
}
}}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>
</div>
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
| 
