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

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

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,

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 better job,