FUDforum: comp.lang.php » Will this work?

Home » Imported messages » comp.lang.php » Will this work?

Show: Today's Messages :: Polls :: Message Navigator

Re: Will this work? [SOLVED] [message #172290 is a reply to message #172244]

Thu, 10 February 2011 17:05

Derek Turner
Messages: 48
Registered: October 2010

Karma:

Member

On Mon, 07 Feb 2011 23:03:15 +0000, Derek Turner wrote:

> How long and complicated can a while condition be?
>
> I want to:
>
> define a string variable ($i) starting at "01" use this in a mysql query
> increment the string
> dropout of the while when a zero result comes back from mysql

Many thanks for help received here. Final working code is:

<?php
// first connect to the database table (cantabi1_choir)
include("/home/cantabi1/member_connect.php");

//create a queries in for/next loop

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

// Now we look for disk numbers from 01 to 99

for ($i = 1; $i < 100; $i++){
$result = mysql_query(sprintf($fmt,$i,$i)) or die(mysql_error());
if (mysql_num_rows($result) == 0) break; // empty result set,
finished //

//process each $result
....
?>

The sprintf() function made the backslashes (needed in the simple assign
string) redundant (in fact they caused a MySQL error that took me a while
to debug). But it is all working perfectly now and the 'customers'[1] are
delighted.

So thanks again to the group and especially Denis.

1. in fact I'm doing it for the love of it, for my choir.

Report message to a moderator

[Message index]

		Will this work? By: Derek Turner on Mon, 07 February 2011 23:03
		Re: Will this work? By: Robert Heller on Mon, 07 February 2011 23:28
		Re: Will this work? By: Denis McMahon on Tue, 08 February 2011 01:27
		Re: Will this work? By: Derek Turner on Tue, 08 February 2011 13:06
		Re: Will this work? By: Jerry Stuckle on Tue, 08 February 2011 13:36
		Re: Will this work? By: Denis McMahon on Tue, 08 February 2011 15:25
		Re: Will this work? By: Denis McMahon on Tue, 08 February 2011 15:35
		Re: Will this work? By: Derek Turner on Tue, 08 February 2011 16:36
		Re: Will this work? By: Denis McMahon on Tue, 08 February 2011 17:23
		Re: Will this work? [SOLVED] By: Derek Turner on Thu, 10 February 2011 17:05

Previous Topic:	Question about binary transfers in POST requests
Next Topic:	file_put_contents not creating file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 12:36:36 GMT 2024

Total time taken to generate the page: 0.05862 seconds