> Steve McGill wrote:
> > I have a situation where I am doing lots of complex sorting on records
that
> > already exist in a MySQL table. The table has a 'sort_order' field which
> > means I can do a simple ORDER BY sort_order to keep it nice and quick on
> > SELECT, it's only UPDATE which is slow.
Steve McGill wrote:
I have a situation where I am doing lots of complex sorting on records that
already exist in a MySQL table. The table has a 'sort_order' field which
means I can do a simple ORDER BY sort_order to keep it nice and quick on
SELECT, it's only UPDATE which is slow.
If I change the o
I have a situation where I am doing lots of complex sorting on records that
already exist in a MySQL table. The table has a 'sort_order' field which
means I can do a simple ORDER BY sort_order to keep it nice and quick on
SELECT, it's only UPDATE which is slow.
If I change the order that I want 10
1473
> ---
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 18 April 2002 14:21
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Updating Many Records
> >
> &
18 April 2002 14:21
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Updating Many Records
>
>
> I am not sure if this is possible.
>
> I have a database, and we fetch all the records and then list them.
>
> What we need is the one field in the database to be able to be updated.
I am not sure if this is possible.
I have a database, and we fetch all the records and then list them.
What we need is the one field in the database to be able to be updated.
Now the field will have different values for each record. Is it possible to update
the table with lots of different va
