RE: [PHP] Sorting, sort of

> -Original Message- > I have about 50 records with the following fields: > 'gen', 'year', 'color', 'name', 'email', 'location', 'misc', > 'pic1', 'pi c2', 'pic3', 'pic4' > -Original Message- If you're going to be changing your database, you might also consider what to do w

Re: [PHP] Sorting, sort of

ROTECTED]> 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

Re: [PHP] Sorting, sort of

ade, 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, sor

Re: [PHP] Sorting, sort of

Hi Jason, I'd just get it over with and make first_name and last_name fields in your table. It will be so much easier to sort by last name that way. I do it this way everytime. It won't take much time to implement either. Good luck, Tyler Longren Captain Jack Communications [EMAIL PROTECTED]

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

Re: [PHP] Sorting, sort of

On Mon, May 06, 2002 at 11:25:03AM -0800, Jason Soza wrote: > I have a 'name' field in a MySQL table that contains people's first and > last names, > ... snip ... > I'm thinking the easiest way to sort by last name, which is what I want > to do, is to just go into MySQL and make 'first_name' and