Yeah, just dump it, edit it, and import it back into a table. 50 records shouldn't take you to long. You'll thank yourself later.. :)
---John Holmes... ----- Original Message ----- From: "Jason Soza" <[EMAIL PROTECTED]> To: "1LT John W. Holmes" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 3:56 PM Subject: Re: [PHP] Sorting, sort of > 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!) > > Jason Soza > > ----- 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
