Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #11256

Re: Will this work?

Show all headers | View raw

On Tue, 08 Feb 2011 01:27:46 +0000, Denis McMahon wrote:

> Note that an empty result set is still a result set!
> 
> This might be neater, and allows you to use an integer for your loop:

<snip>

Thanks but I'm searching for a string like "02-" so $i needs to be a 
string.

$sql = "SELECT `workName`, `composer`, SUBSTRING(`Reference`,LOCATE(\'08-
\',`Reference`)) as TRACK FROM `work` WHERE `Reference` LIKE \'%08-%\' 
ORDER BY TRACK";

works fine but I want to search on "01-" ... "99-" stopping when I get a 
zero result. Thanks for the heads-up on zero-result != false, that, and 
your fix are very helpful.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Will this work? Derek Turner <frderek@cesmail.net> - 2011-02-07 23:03 +0000
  Re: Will this work? Denis McMahon <denis.m.f.mcmahon@googlemail.com> - 2011-02-08 01:27 +0000
    Re: Will this work? Derek Turner <frderek@cesmail.net> - 2011-02-08 13:06 +0000
      Re: Will this work? Jerry Stuckle <jstucklex@attglobal.net> - 2011-02-08 08:36 -0500

csiph-web