[Resolved] Deleting rows in MySQL...DRIVING ME NUTS

Rune

Ok, first I'd like to state that I'm a complete newbie. All I can do is minorly edit already made code, but I'm working hard to learn.

With that out of the way, heres my problem. I have a database, named inc_roster. It holds 2 tables, goldenaxis and backblade. Each of those tables also hold a table (I think..) called members. Basic setup, 'varchar(150) not null'. They hold names of the members of the clan website I'm building. Now I need a script that connects to the database, and displays on a seperate line:

checkbox membername
checkbox membername
checkbox membername

Submit Reset

But looking thru all the scripts, theres no way to customize them (on my level of n00bism) They either contain confusing as hell code, or more tables than I need. I just need a very simple script, that identifies what names are checked and deletes them. Is this as simple as it should be?

I would be EXTREMELY thankful if someone could premake the code..but pointing me in the right direction would also be great. Thanks in advance, I hope this is a ..'fixable' problem.

Rune

..still no posts? Is it this hard to do?

barand

Not hard to do, just hard to understand the table structure you have.

stolzyboy

give something like this a whirl, this is how is usually do it

<?
$conn = mysql_connect("localhost", "user", "pass") or die ("Could not connect to database!");
$db = mysql_select_db("databasename") or die ("Could not select database");
?>
<form action="page.php" method="post">
<?
if (isset($_POST['delete']))
{
?>
Entries have been deleted<br><br>
<?
while (@list($key, $value) = each($_POST['id']))
{
$queryd = "delete from tablename where fieldname = $value;";
$resultd = mysql_query($queryd) or die(mysql_error());
}

$query = "select * from table where blah....;";
$result = mysql_query($query1) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
?>
<input type="checkbox" name="id[]" value="<? echo $row['id']; ?>"> Delete?<br>
<?
}
?>
<input type="submit" name="delete" value="Delete Checked Items">
</form>

Rune

one database, inc_roster
one table named goldenaxis
one table named backblade

inside both of them is "members" (row or table.. I'm not sure) when I insert data into it, via phpmyadmin or php, the info gets inserted into that. Inside that is the member names of a clan website I'm making. Hope that helps...if that doesn't, I'll post a ss of phpmyadmin.

Rune

Parse error: parse error, unexpected $ in /home/inc/public_html/roster/index.php on line 28

with your code ...dont quite understand how to get that working, again I'm a total newb.

stolzyboy

that was just an example, i will get you a finished version tomorrow

Rune

Oh, I forgot: I dont need the entire database displayed, I can have 2 sets of code...like one that displays 'goldenaxis', and one that displays 'backblade'

Rune

Are you still making the code? I need it soon...thanks.

stolzyboy

sorry, i forgot, getting old ya know, anywho, this works, i tested it, the other was just thrown together quickly, that's why you got a parse error, all you need to change is the connection string data, the table and field names in the queries and that should be about it, don't change the variable names unless you know what you are doing with them, so here it is, you can create different queries dependent on what you want to select also...

<?
$conn = mysql_connect("localhost", "username", "password") or die ("Could not connect to database!");
$db = mysql_select_db("databasename") or die ("Could not select database");

if (isset($_POST['delete']))
{
?>
Entries have been deleted<br><br>
<?
while (@list($key, $value) = each($_POST['id']))
{
$queryd = "delete from tablename where fieldnameofid = $value;";
$resultd = mysql_query($queryd) or die(mysql_error());
}
?>
<form action="delete_checked.php" method="post">
<?
$query = "select * from tablename;";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
?>
<? echo $row['fieldname']; ?> <input type="checkbox" name="id[]" value="<? echo $row['fieldnameofid']; ?>"> Delete?<br>
<?
}
?>
<input type="submit" name="delete" value="Delete Checked Items">
</form>
<?
}
else
{
?>
<form action="delete_checked.php" method="post">
<?
$query = "select * from tablename;";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
?>
<? echo $row['fieldname']; ?> <input type="checkbox" name="id[]" value="<? echo $row['fieldnameofid']; ?>"> Delete?<br>
<?
}
?>
<input type="submit" name="delete" value="Delete Checked Items">
</form>
<?
}
?>

Rune

Thanks for doing so much already...but I've run into a problem...

<? 
$conn = mysql_connect("localhost", "inc_admin", "******") or die ("Could not connect to database!"); 
$db = mysql_select_db("inc_roster") or die ("Could not select database"); 

if (isset($_POST['delete'])) 
{ 
?> 
Entries have been deleted<br><br> 
<? 
while (@list($key, $value) = each($_POST['id'])) 
{ 
$queryd = "delete from goldenaxis where members = $value;"; 
$resultd = mysql_query($queryd) or die(mysql_error()); 
} 
?> 
<form action="delete_checked.php" method="post"> 
<? 
$query = "select * from goldenaxis;"; 
$result = mysql_query($query) or die(mysql_error()); 
while ($row = mysql_fetch_array($result)) 
{ 
?> 
<? echo $row['members']; ?> <input type="checkbox" name="id[]" value="<? echo $row['members']; ?>"> Delete?<br> 
<? 
} 
?> 
<input type="submit" name="delete" value="Delete Checked Items"> 
</form> 
<? 
} 
else 
{ 
?> 
<form action="delete_checked.php" method="post"> 
<? 
$query = "select * from goldenaxis;"; 
$result = mysql_query($query) or die(mysql_error()); 
while ($row = mysql_fetch_array($result)) 
{ 
?> 
<? echo $row['members']; ?> <input type="checkbox" name="id[]" value="<? echo $row['members']; ?>"> Delete?<br> 
<? 
} 
?> 
<input type="submit" name="delete" value="Delete Checked Items"> 
</form> 
<? 
} 
?>

"Entries have been deleted

Unknown table 'Grape' in where clause"

I'm not getting any errors or anything, but what I think the problem is is that all the entries in my members names have a .InC on the end (which is our clan tag), and when I run the script the .InC doesn't show up, so the dot must be doing something to it...but then I deleted the .InC from a name, and it did the same error.. any tips? (I can also send you a ss of phpmyadmin)

Oh, and when I try to delete a name that doesn't have the .InC it sats Unknown column 'Grape' in 'where clause'"

stolzyboy

do you have an id field, that distinguishes each person differently, like an auto_incremented field

Rune

No, its just 'members'. ..but I can easily make one.

stolzyboy

i would do that, then change the code to

select the id and use that for the value of the checkboxes

and

delete from tablename where id = '$value'

so it doesn't matter what a field contains, it will simply delete it where the id equals a certain id

Rune

OK, working perfectly now...thank you SO much...you have no idea how long I've been lookin for this code 🙂 🙂