I'm not sure how to change DELETE statements in this fashion, but is there a
way maybe to run an OPTIMIZE TABLE query every so often in your PHP script..
I don't imagine you'd want it running too often since it locks the table you
run it on, but maybe on the reload of $PHP_SELF or something.. It can take a
while to run on tables with lots of data, so it may not be the best option
anyway.. Just a thought though.. Ooh, maybe a PHP script run from a cron job
every couple hours or something even??


Bob Weaver

"Jennifer Downey" <[EMAIL PROTECTED]> wrote in message
> Hi all,
> I'm not sure if my first post showed up so I am going to post it again and
> apologize if it shows up twice.
> Is there a way to delete a record from a mysql table without fragmenting
> 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

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

Reply via email to