Re: [PHP] Last Name extraction in query

2011-04-04 Thread Andre Polykanine
ostly in Russian) Twitter: http://twitter.com/m_elensule Facebook: http://facebook.com/menelion Original message From: Geoff Lane To: php-general@lists.php.net Date created: , 7:46:26 PM Subject: [PHP] Last Name extraction in query On Monday, April 4, 2011, Jim

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Jim Giner
To those who have been so helpful: I did manage to subscribe to a mysql mailing list. thanks for the pointers. As for my orig problem - for those who are intereseted: The FIELD function apparently doesn't work in 5.0.2, even tho it is in the online ref manual. I was given a suggestion of using

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Bastien Koert
On Mon, Apr 4, 2011 at 2:40 PM, Steve Staples wrote: > On Mon, 2011-04-04 at 14:06 -0400, Jim Giner wrote: >> no - that address came back undeliverable. >> > >> > To subscribe to the list, send an empty message to >> > >> > >> > Marc >> >> >> > http://lists.mysql.com/mysql > > there is the subscr

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Steve Staples
On Mon, 2011-04-04 at 14:06 -0400, Jim Giner wrote: > no - that address came back undeliverable. > > > > To subscribe to the list, send an empty message to > > > > > > Marc > > > http://lists.mysql.com/mysql there is the subscribe box on the right side... use that. they are a helpful bunch

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Jim Giner
no - that address came back undeliverable. > > To subscribe to the list, send an empty message to > > > Marc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Jim Giner
Thanks - will do! > I found a mailing list that might work for you: > > To subscribe to the list, send an empty message to > > > Marc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Last Name extraction in query

2011-04-04 Thread sono-io
Jim, > Actually - I can't seem to find a mysql newsgroup anywhere. The ones that > come up in google search are all dead and buried. I found a mailing list that might work for you: To subscribe to the list, send an empty message to Marc -- PHP General Mailing List (http://www.php

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Hans Åhlin
Read about Friday posting ;) http://news.php.net/php.general/306939 2011/4/4 Geoff Lane : >  On Monday, April 4, 2011, Jim Giner wrote: > >> Actually - I can't seem to find a mysql newsgroup anywhere.  The >> ones that  come up in google search are all dead and buried. > > You could try http://for

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Geoff Lane
On Monday, April 4, 2011, Jim Giner wrote: > Actually - I can't seem to find a mysql newsgroup anywhere. The > ones that come up in google search are all dead and buried. You could try http://forums.mysql.com/ or have a look around Yahoo groups (e.g. php_my...@yahoogroups.com). HTH, -- Geof

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Robert Stone
RTRIM(race_winner)). Cheers, --- Em seg, 4/4/11, Jim Giner escreveu: De: Jim Giner Assunto: [PHP] Last Name extraction in query Para: php-general@lists.php.net Data: Segunda-feira, 4 de Abril de 2011, 12:50 having a problem posting this message - forgive any duplication please. Hi, I'

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Jim Giner
Actually - I can't seem to find a mysql newsgroup anywhere. The ones that come up in google search are all dead and buried. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Jim Giner
good point. So wrapped up in making my php script work that I didn't think about that. "Ashley Sheridan" wrote in message news:1301936583.2288.3.camel@localhost... > On Mon, 2011-04-04 at 11:50 -0400, Jim Giner wrote: > >> having a problem posting this message - forgive any duplication please.

Re: [PHP] Last Name extraction in query

2011-04-04 Thread Ashley Sheridan
On Mon, 2011-04-04 at 11:50 -0400, Jim Giner wrote: > having a problem posting this message - forgive any duplication please. > > Hi, > I'm trying to use sql to extract the last name from a person's name field in > my table. Here's my Select: > > $q = "SELECT race_winner,count(race_date) as win

[PHP] Last Name extraction in query

2011-04-04 Thread Jim Giner
having a problem posting this message - forgive any duplication please. Hi, I'm trying to use sql to extract the last name from a person's name field in my table. Here's my Select: $q = "SELECT race_winner,count(race_date) as wins, substr(race_winner,FIELD(' ',race_winner)) as last_name etc.,,,