Re: [PHP] Last Name extraction in query

2011-04-04 Thread Andre Polykanine
Hello Geoff, As I dislike forums and like mailing lists (yes, an old habbit :-)), so here it is: mysql-subscr...@lists.mysql.com (that's for subscribing, indeed). And sorry for the offtopic. -- With best regards from Ukraine, Andre Skype: Francophile My blog: http://oire.org/menelion (mostly i

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
Hi Jim, I think that you'll find that ' ' is treated as a NULL and as such will always return zero. You are no catering for multiple spaces in the column race_winner. If you were using Oracle, their INSTR function has an optional argument that allows you to search backwards from the end of a str

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