Re: Will this work?

Path	csiph.com!eeepc.pasdenom.info!news.pasdenom.info!news.dougwise.org!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Derek Turner <frderek@cesmail.net>
Newsgroups	comp.lang.php
Subject	Re: Will this work?
Date	8 Feb 2011 16:36:22 GMT
Lines	24
Message-ID	<8rd9o6Fnl3U2@mid.individual.net> (permalink)
References	<8rbc1jFh6iU2@mid.individual.net> <4d509ce2$0$25004$bed64819@gradwell.net> <8rctf4Fnl3U1@mid.individual.net> <4d516375$0$6000$bed64819@gradwell.net>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
X-Trace	individual.net 4Iwp3+lruha+2TrHOviGYg57P0/adW2N6Wz+F9GUwM3apFPoFf
Cancel-Lock	sha1:4APUne9yLs6+VFke9e2xFDN+ImI=
User-Agent	Pan/0.133 (House of Butterflies)
Xref	csiph.com comp.lang.php:11086

Show key headers only | View raw

On Tue, 08 Feb 2011 15:35:05 +0000, Denis McMahon wrote:


> <?php
> 
> $fmt = "SELECT `workName`, `composer`, SUBSTRING(`Reference`,
> LOCATE(\'%02d-\', `Reference`)) as TRACK FROM `work` WHERE `Reference`
> LIKE \'%%%02d-%%\' ORDER BY TRACK";
> 
> for ($i = 1; $i < 100; $i++) {
> $result = $mysql_query(sprintf($fmt,$i,$i)); if (!$result) {
>   // print an error message, maybe break
> }
> if (mysql_num_rows($result) == 0) break; // empty result set, finished
> // process $result here
> }
> 
> ?>
> 
> Rgds
> 
> Denis McMahon

Cool! very many thanks, it works. One more question: why the double %% ?

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

Thread

Re: Will this work? Derek Turner <frderek@cesmail.net> - 2011-02-08 16:36 +0000

csiph-web