Re: [PHP] reading records alphebetically

2001-06-30 Thread Jack Sasportas
} > > lets say > $name = "Fred"; > then > $name[0] is set to "F"; > $name[1] is set to "r"; > $name[2] is set to"e"; > and so on... > - Original Message - > From: "Jamie Saunders" <[EMAIL PROTECTED]> &g

Re: [PHP] reading records alphebetically

2001-06-30 Thread Julia A. Case
Try using a query like select * from table_name where name like '$letter%'; Julia Quoting Jamie Saunders ([EMAIL PROTECTED]): > Hi, > > I have a MySQL database set-up containing a few hundred records. I'm trying > to make a script that reads the 'name' field of the records and displays > only

RE: [PHP] reading records alphebetically

2001-06-30 Thread Warren Vail
ndexed. Warren Vail -Original Message- From: Jamie Saunders [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 30, 2001 10:30 AM To: [EMAIL PROTECTED] Subject: [PHP] reading records alphebetically Hi, I have a MySQL database set-up containing a few hundred records. I'm trying to mak

Re: [PHP] reading records alphebetically

2001-06-30 Thread Ethan Schroeder
letter = strtolower($name[0]); } lets say $name = "Fred"; then $name[0] is set to "F"; $name[1] is set to "r"; $name[2] is set to"e"; and so on... - Original Message - From: "Jamie Saunders" <[EMAIL PROTECTED]> To: <[EM

[PHP] reading records alphebetically

2001-06-30 Thread Jamie Saunders
Hi, I have a MySQL database set-up containing a few hundred records. I'm trying to make a script that reads the 'name' field of the records and displays only the records of which the name field begins with a specific letter: if ($letter = A) { display all records of which field 'name' being