Re: [php-list] deleting records from database

2006-06-04 Thread Mike Franks
On 6/4/2006, "Pete" <[EMAIL PROTECTED]> wrote: > > > >In message <[EMAIL PROTECTED]>, >Mike Franks <[EMAIL PROTECTED]> writes >> and you should never base >>any query or sorting logic on the key - it should only be used to fetch >>a particular record. > >I think that this sounds a little confus

Re: [php-list] deleting records from database

2006-06-04 Thread Mike Franks
On 6/4/2006, "Anna Vester" <[EMAIL PROTECTED]> wrote: > >Yes, I don't have much experience with dbs yet. But >I'm working on it.  :) > That's where we all start! ;-) > >I have 1 more question though. :) now that I'm >thinking about it. the auto_increment value of that id >column. >Should I bo

Re: [php-list] deleting records from database

2006-06-04 Thread James Keeline
--- Anna <[EMAIL PROTECTED]> wrote: > I have another question about record deletion from > database. > > For example, my database has 10 records with ids 1 > through 10. If I delete id #10 then everything is good > and all the records are still 1 through 9. However, if > I delete record id #4,

[php-list] Array Question

2006-06-04 Thread Mike Brandonisio
Hi, Is there a php function that will recreate the numeric array keys 0  to what ever is in the array or should I just render a new temp array  with a while or foreach loop? I'm trying to do some array  manipulation and not having the array keys in sequence does not work.  Partly I'm trying

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 known > as a "surrogate" > key. That is

Re: [php-list] deleting records from database

2006-06-04 Thread Anna Vester
--- Debbie Woods <[EMAIL PROTECTED]> wrote: > >   I'm not sure why this would cause any problems for > you. When you query the database, the missing record > with ID 4 shouldn't be an issue. What in particular > are you experiencing? I was concerned about those "gaps", but as Mike has already

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 records > > my TABLE has 10 records > MODE> That was my examp

Re: [php-list] deleting records from database

2006-06-04 Thread Pete
In message <[EMAIL PROTECTED]>, Mike Franks <[EMAIL PROTECTED]> writes >There should be >no reason for you to worry about any "gaps", agreed... > and you should never base >any query or sorting logic on the key - it should only be used to fetch >a particular record. I think that this sounds a

Re: [php-list] deleting records from database

2006-06-04 Thread Mike Franks
Hi Anna, I suspect you don't have a great deal of experience with data bases. The ID that is being autogenerated by MySQL is known as a "surrogate" key. That is, a value that uniquely identifies each record, but has no relationship to that data other than to be an identity. There should be no r

Re: [php-list] deleting records from database

2006-06-04 Thread Debbie Woods
  I'm not sure why this would cause any problems for you. When you query the database, the missing record with ID 4 shouldn't be an issue. What in particular are you experiencing?   --- Debbie Woods <[EMAIL PROTECTED]> wrote:   > What database are you using?   Sorry I should have mentioned

Re: [php-list] deleting records from database

2006-06-04 Thread Pete
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 records my TABLE has 10 records > with ids 1 >through 10. If I delete id #10 then everything is good >and all the

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. > >   For example, my database has 10 rec

Re: [php-list] deleting records from database

2006-06-04 Thread Debbie Woods
What database are you using?   Hello group,   I have another question about record deletion from   database.   For example, my database has 10 records with ids 1   through 10. If I delete id #10 then everything is good   and all the records are still 1 through 9. However, if   I delete recor

[php-list] deleting records from database

2006-06-04 Thread Anna
Hello group, I have another question about record deletion from database. For example, my database has 10 records with ids 1 through 10. If I delete id #10 then everything is good and all the records are still 1 through 9. However, if I delete record id #4, then in my db I would have records 1

[php-list] Script executes multiple times?

2006-06-04 Thread Jer
I've got a file of code that is included in a page. I recently made a change to the code and now the script executes multiple times. In the main file, I've got this: if ( $_SERVER[SERVER_NAME] == "www.domain.com" ) { $pagename = 'index'; $hitcount = 'X'; include("include/userlog.php"); } In