On Mon, Apr 4, 2011 at 2:40 PM, Steve Staples <sstap...@mnsi.net> 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
>> > <mysql-subscr...@lists.mysql.com>
>> >
>> > Marc
>>
>>
>>
> http://lists.mysql.com/mysql
>
> there is the subscribe box on the right side... use that.   they are a
> helpful bunch over there.
>
> --
>
> Steve Staples
> Web Application Developer
> MNSi (Managed Network Systems Inc.)
> 519.258.2333 x8414
> http://www.mnsi.net
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Try using LOCATE instead of the FIELD function

$q = "SELECT race_winner,count(race_date) as wins,
substr(race_winner,LOCATE(' ',race_winner)) as last_name


-- 

Bastien

Cat, the other other white meat

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to