[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.,,,

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 wins,

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 a...@ashleysheridan.co.uk 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

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 Robert Stone
seg, 4/4/11, Jim Giner jim.gi...@albanyhandball.com escreveu: De: Jim Giner jim.gi...@albanyhandball.com 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

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, -- Geoff

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 ge...@gjctech.co.uk:  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

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 mysql-subscr...@lists.mysql.com Marc -- 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 mysql-subscr...@lists.mysql.com 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
no - that address came back undeliverable. To subscribe to the list, send an empty message to mysql-subscr...@lists.mysql.com 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 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 mysql-subscr...@lists.mysql.com Marc http://lists.mysql.com/mysql there is the subscribe box on the right side... use that. they