RE: [PHP] Re: A stupid question...

2002-03-11 Thread Tim Ward
hat one. Tim Ward Internet chess www.chessish.com <http://www.chessish.com> -- From: Chuck "PUP" Payne [SMTP:[EMAIL PROTECTED]] Sent: 11 March 2002 02:59 To: Cary; mysql lists.mysql.com Cc: PHP General Subject: Re: [PHP] Re: A stu

Re: [PHP] Re: A stupid question...

2002-03-10 Thread Kim Kohen
G'day Daren > $query = "SELECT * FROM tbl_name WHERE LEFT(last_name, 1) == '$letter')"; > NOTE: LEFT() is a "special" function, I'd consider it a derivative of > SUBSTRING() Does MySQL have a function that can selectively return words from a column? What I'm looking for is the equivalent of

RE: [PHP] Re: A stupid question...

2002-03-10 Thread Demitrious S. Kelly
lists.mysql.com Cc: PHP General Subject: Re: [PHP] Re: A stupid question... I want to sort by a letter in a colomn. Let say I want to sort the colomn last_name. I can do order by but I can do just the A's. http://www.myserver.com/mysort.php?Letter=A Like to create a link on a web "A&qu

RE: [PHP] Re: A stupid question...

2002-03-10 Thread Daren Cotter
---Original Message- From: michael kimsal [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 10, 2002 8:17 PM To: Chuck \ Pup\\ Payne Cc: mysql lists.mysql.com Subject: Re: [PHP] Re: A stupid question... Chuck "Pup" Payne wrote: > I want to sort by a letter in a colomn. Let say I wan

Re: [PHP] Re: A stupid question...

2002-03-10 Thread michael kimsal
Chuck "Pup" Payne wrote: > I want to sort by a letter in a colomn. Let say I want to sort the colomn > last_name. I can do order by but I can do just the A's. > > http://www.myserver.com/mysort.php?Letter=A > > Like to create a link on a web "A" then sort only the last name are A. > > I hope t

Re: [PHP] Re: A stupid question...

2002-03-10 Thread Chuck \"PUP\" Payne
I want to sort by a letter in a colomn. Let say I want to sort the colomn last_name. I can do order by but I can do just the A's. http://www.myserver.com/mysort.php?Letter=A Like to create a link on a web "A" then sort only the last name are A. I hope that's helps. I can order by, but I can't

Re: [PHP] Re: A stupid question...

2002-03-10 Thread Chuck \"PUP\" Payne
I want to sort my a letter in a set colomn. Let say I want to sort the colomn last_name http://www.myserver.com/mysort.php?Letter=A Like to create a link like A then sort only the last name ore what ever I want to sort by that letter. I hope that's helps. I can order by, but I can't so a sort l