Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-16 Thread Frank Flynn
On 4/16/02 2:34 PM, "Lisi" <[EMAIL PROTECTED]> wrote: > Thanks for the explanation! Very clear. > > How do you know how fragmented your DB is? I apologize if this is covered > somewhere, like I said I was very confused buy this whole topic. > > Thanks, > > -Lisi > Oh, sorry each database is d

RE: [PHP-DB] Delete from mysql table is there a way to....

2002-04-16 Thread Gurhan Ozen
] Delete from mysql table is there a way to Thanks for the explanation! Very clear. How do you know how fragmented your DB is? I apologize if this is covered somewhere, like I said I was very confused buy this whole topic. Thanks, -Lisi At 01:00 PM 4/16/02 -0700, Frank Flynn wrote: >Pictur

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-16 Thread Lisi
Thanks for the explanation! Very clear. How do you know how fragmented your DB is? I apologize if this is covered somewhere, like I said I was very confused buy this whole topic. Thanks, -Lisi At 01:00 PM 4/16/02 -0700, Frank Flynn wrote: >Picture a Church, full of pews. This is your emp

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-16 Thread Frank Flynn
Picture a Church, full of pews. This is your empty table. As people (your data) come in to the church they fill the pews but unlike real life the first person goes all the way to the left hand side of the first pew, the second sits next to them and the third... When one pew is full they start

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-15 Thread Lisi
What exactly does it mean when a table becomes fragmented? How do you know when it's happened and something should be done? All the docs and books talk about how bad it is but I'm still confused on what this is and when it happens. Thanks, -Lisi At 05:00 PM 4/14/02 -0700, Jennifer Downey wr

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-15 Thread Jason Wong
On Monday 15 April 2002 08:46, Jennifer Downey wrote: > 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. The first post did show up. This is purely a MySQL issue. > Is there a way to delete a record from a mysql table withou

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-15 Thread Marius Ursache
your posts are here. i don't think you could do this in other way. if is possible i'm curios about it too. Jennifer Downey a écrit : > 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 f

[PHP-DB] Delete from mysql table is there a way to....

2002-04-14 Thread Jennifer Downey
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) {

[PHP-DB] Delete from mysql table is there a way to....

2002-04-14 Thread Jennifer Downey
Hi all, 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("D