Re: [php-list] deleting records from database

2006-06-05 Thread Anna Vester
into > errors when running a query? > i will not be doing this anymore... :) Anna __ Do You Yahoo!? Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com Community email addresses:   Post message: php-li

Re: [php-list] deleting records from database

2006-06-05 Thread Anna Vester
> The default for integer is INT(11) Cool I'll change it to that as well. Thankee. Anna Vester http://veanndesign.com http://reviews.veanndesign.com __ Do You Yahoo!? Tired of spam?  Yahoo! Mail has the best spam protection around htt

Re: [php-list] deleting records from database

2006-06-05 Thread Anna Vester
this is going. the light went on. :) good example. thank you. Anna http://veanndesign.com http://reviews.veanndesign.com __ Do You Yahoo!? Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com Community em

Re: [php-list] deleting records from database

2006-06-05 Thread Anna Vester
--- Pete <[EMAIL PROTECTED]> wrote: > In message > <[EMAIL PROTECTED]>, > Anna Vester <[EMAIL PROTECTED]> writes > >For example, my table has 10 > >records. > >The AUTO_INCREMENT value is 11. I then delete 2 > last > >records. I have 8 re

Re: [php-list] deleting records from database

2006-06-04 Thread Anna Vester
--- Mike Franks <[EMAIL PROTECTED]> wrote: > Hi Anna, I suspect you don't have a great deal of > experience with data > bases. Yes, I don't have much experience with dbs yet. But I'm working on it.  :) > > The ID that is being autogenerated by MySQL is

Re: [php-list] deleting records from database

2006-06-04 Thread Anna Vester
t those "gaps", but as Mike has already mentioned that is not a problem at all. > >   --- Debbie Woods <[EMAIL PROTECTED]> wrote: > >   > What database are you using? > >   Sorry I should have mentioned this. >   I use mysql 4 and php 5. > >   Tha

Re: [php-list] deleting records from database

2006-06-04 Thread Anna Vester
--- Pete <[EMAIL PROTECTED]> wrote: > In message <[EMAIL PROTECTED]>, Anna > <[EMAIL PROTECTED]> writes > >Hello group, > > > >I have another question about record deletion from > >database. > > > >For example, my database has 10

Re: [php-list] deleting records from database

2006-06-04 Thread Anna Vester
--- Debbie Woods <[EMAIL PROTECTED]> wrote: > What database are you using? Sorry I should have mentioned this. I use mysql 4 and php 5. Thanks! Anna Vester >  >   Hello group, > >   I have another question about record deletion from >   database. > >   F

[php-list] deleting records from database

2006-06-04 Thread Anna
1 through 10 with id #4 missing. Is there a command that syncs the database? How do I go about this to keep all the ids in the right order after the deletion? or What do I need to do to prevent that from happenning? All the help is appreciated. Anna Vester http://www.veanndesign.com http