It's actually not that large of a table, but it'll still be a PITA to
get all of the data reinserted.
I have about 50 records with the following fields:
'gen', 'year', 'color', 'name', 'email', 'location', 'misc', 'pic1', 'pi
c2', 'pic3', 'pic4'
So basically, I guess I want to rename 'name' to 'first_name', add
another column for 'last name', then update each record to separate the
first and last names into their respective columns, eh?
I suppose the easiest way is to save/export the table as a tab-
delimited txt file, make my first/last name changes that way, change
the layout of the table, then update the table using the new txt file?
Sorry for the newbie (and MySQL) questions - I'm not a programmer or DB
admin by trade, just volunteered to make a website and got caught up
with PHP and MySQL. I'm learning, really I am! (And having fun too!)
----- Original Message -----
From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
Date: Monday, May 6, 2002 11:46 am
Subject: Re: [PHP] Sorting, sort of
> You _definetly_ want to do this in your database, not with PHP and
> arrays.Databases are made to do this kind of sorting for you.
> I would modify your table first, adding in another column for
> first_name,then modify your form so that all data going in from
> now on is correct. The
> hard part will be getting the data you have now into the correct
> format. How
> big of a table are we talking?
> ---John Holmes...
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php