[PHP-DB] Deleting records...

[jas]

Ok I am trying to delete records from a database using an html form.  I have
2 files, file one = remove.php3 which queries the database table and
displays the current contents.  Code is as follows.

Current
Inventory";
$count = -1;
while ($myrow = mysql_fetch_row($result)) {
$count ++;
echo "Type Of Car: ";
printf(mysql_result($result,$count,"car_type"));
echo "remove
\n";
echo "Model Of Car: ";
printf(mysql_result($result,$count,"car_model"));
echo "\n";
echo "Year Of Car: ";
printf(mysql_result($result,$count,"car_year"));
echo "\n";
echo "Price Of Car: $";
printf(mysql_result($result,$count,"car_price"));
echo "\n";
echo "VIN Of Car: ";
printf(mysql_result($result,$count,"car_vin"));
echo "\n";
}
echo "";
?>
Once it queries the database it gives the user an option to check the
checkbox and delete that record.  Here is the done2.php3 page that actually
contains the delete sql statement
$db_name = "test";
$table_name = "inventory";
$connection = @mysql_connect("localhost", "root", "password") or die ("Could
not connect to database.  Please try again later.");
$db = @mysql_select_db("$db_name",$connection) or die ("Could not select
database table. Please try again later.");
$sql = "DELETE FROM $table_name WHERE $cars =
\"$car_type\",\"$car_model\",\"$car_year\",\"$car_price\",\"$car_vin\",\"$dl
r_num\"");
$result = @mysql_query($sql, $connection) or die ("Could not execute query.
Please try again later.");



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] deleting records

[John Hughes]

It's late and I'm getting groggy.

I have a table called mail_list.  There are four possible list_names.

I want to be able to either delete an email associated with a particular
list or all matching email.

Deleting WHERE email AND list match works fine.  The problem is when I want
to delete an address from all of the lists.

First I check the database to see how many matches I have.

$check_sql = "
SELECT list_id, email FROM mail_list
WHERE email = '$this_email'
";

For purposes of discussion, we'll say the answer was 3.

I use this sql when I want to delete all of the email addresses:

$remove_sql = "
DELETE FROM mail_list
WHERE
email ='$this_email'
";

Only the first record is deleted even though the check_sql found more than
one match.

Why doesn't the delete get all of the email addresses that match the first
time?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] deleting records

[John Hughes]

This was, of course, an example where the PHP code was introducing an error.
The delete sql works as expected and deletes all matching email.

Next time I'm going to sleep on a problem before posting.

- Original Message -
From: "John Hughes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 07, 2002 12:51 AM
Subject: [PHP-DB] deleting records


> It's late and I'm getting groggy.
>
> I have a table called mail_list.  There are four possible list_names.
>
> I want to be able to either delete an email associated with a particular
> list or all matching email.
>
> Deleting WHERE email AND list match works fine.  The problem is when I
want
> to delete an address from all of the lists.
>
> First I check the database to see how many matches I have.
>
> $check_sql = "
> SELECT list_id, email FROM mail_list
> WHERE email = '$this_email'
> ";
>
> For purposes of discussion, we'll say the answer was 3.
>
> I use this sql when I want to delete all of the email addresses:
>
> $remove_sql = "
> DELETE FROM mail_list
> WHERE
> email ='$this_email'
> ";
>
> Only the first record is deleted even though the check_sql found more than
> one match.
>
> Why doesn't the delete get all of the email addresses that match the first
> time?
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] deleting records using a checkbox

[Mark]

hello
i have been trying to delete items from a guestbook using multiple checkbox
fields but have had no success

this is the code i have been using to add the checkbox's to the records:

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







Queen Vic Message Book






Date/Time Posted: 



Name: 

Email:  
   








Delete Message 










this does add a checkbox to every record in the guestbook

how do i link the checkbox to each message id (which are auto incremented)
and then pass some code to delete every checked item??

please help me



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php