Re: 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" <holmes072000@charter.net> 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...