Delete from mysql table is there a way to....
| From: | Jennifer Downey | Date: | Mon, 15 Apr 2002 00:46:38 +0000 |
| Subject: | Delete from mysql table is there a way to.... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18502@lists.php.net to get a copy of this message | ||
Hi all,
I'm not sure if my first post showed up so I am going to post it again and I
apologize if it shows up twice.
Is there a way to delete a record from a mysql table without fragmenting the
db?
Here is the query I am using and it does a horrible job. Fragment city.
if ($quantity == 0)
{
$gone = mysql_query("DELETE FROM {$config["prefix"]}_my_items WHERE
uid={$session["uid"]} AND id = '$item'");
}
Thanks
Jennifer
--
The sleeper has awaken
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002