Re: order field of a table

2006-06-16 Thread theo
> > ...just realize this might get you more confused than clearing it out > for you, but what the hey. > Thanks, your answers surely help. But I was also interested in the question how to optimize the whole process. Say: In a php script, I want to delete an employee-record passing his ID to the

Re: order field of a table

2006-06-15 Thread Kim Christensen
On 6/15/06, theo <[EMAIL PROTECTED]> wrote: Now, there is a new employee "John" with "a job better than Peter's" His "importance" is one more than peter's, and all other move up +1; So the list should look like this after inserting "John": Peter; 24years, some job, 0 John; 28years, somewhat bet

Re: order field of a table

2006-06-15 Thread Barry
theo schrieb: Hi I' m a newbie and I'm sure this question has been answered many times, but I can't find the appropriate thread. Example: I have a table of people's data including a field called say "importance" like: NAME; AGE; FUNCTION; IMPORTANCE Peter; 24years, some job, 0 Anna; 22years

order field of a table

2006-06-15 Thread theo
Hi I' m a newbie and I'm sure this question has been answered many times, but I can't find the appropriate thread. Example: I have a table of people's data including a field called say "importance" like: NAME; AGE; FUNCTION; IMPORTANCE Peter; 24years, some job, 0 Anna; 22years, better job, 1