while loop

BEFOR

I've made a number of reuqests to programmers and posted this on another forum. Can't seem to get a response from anyone period. Could anyone make a suggstion on how to insert something similiar to the following repeat reqion (checkboxes)into the code below?

Into:

else {
$ADistance = ableDistanceHelp;
while ($xrow = mysql_fetch_array($result)){
$Distance = $ADistance->Calculate($Latitude,$Longitude,$xrow["Latitude"],$xrow["Longitude"]);
if ($Distance <= $Miles){
RIGHT HERE;
}
}
}
}
mysql_close($dbConn);
?>

AstroTeg

I'm wondering if part of the problem is how you're posting your question/problem. I don't have enough info to go off of to make any intelligent suggestion.

What is "something?" If you can define this, you should be able to then write code to reproduce it. What part of the code are you stuck on?

halojoy

<?php 

do {  

//somthing to do
}
while ($row_xrow = mysql_fetch_assoc($xrow)); 

?>

AstroTeg and me and most everybody here
do not know anything where variables came from
or, what is even worse what values they have
- $row_xrow
- mysql_fetch_assoc($xrow)

Some people here puts even questions with less information than you, BEFOR

Like somebody asks me in a website:
"How do I get to nearest hospital?"

Well, what would I answer ro that?
Take a guess, and say: "You take first road to left and at number 10, you see hospital entrence"
The chance I am right is no greater, than BEFOR is next president of USA.
Note:
( that is supposing BEFOR is: White, Rich, and of Male gender
if BEFOR is: Black, Poor and Woman from the ghetto,
I would say chance I am right about my guess,
is about as great as chance BEFOR will be next president
So much for democracy and equal rights and chances in a 'FREE' western country)

I need to know WHERE person is NOW
at least in what country or even better WHAT CITY.

Lack of info =
lack of help and solutions to your problems!

/halojoy
sweden
2005-07-15

BEFOR

Apologies for the confusion.
What I've been stuck on is the formatting.

</table>

xrow is already defined higher on the page, from a SELECT.

$xrow = mysql_fetch_array($result);

What I was trying to do is come up with a checkbox repeat region based on zip codes, which relies on both a series of code higher on the page and (2) include files -- which would display check boxes within a given range of a zip code.

Where you see "RIGHT HERE" the code presently uses printf to bring up what I need, but not as checkboxes. ex: ABC COunty, 10 mi'.s (from entered zip)
I was trying to convert this line into the checkbox repeat region. Mainly for those residing in counties that are ner state borders, to call up counties within the bordering states.

I thought this was mainly a format question since the 'do while' above already works. Only can't get it to display within the "RIGHT HERE"

To simplify things, maybe I can settle with formatting this 'do while' in three relatively equal columns that would be only for a single state, and to do this using:

<?php $num_rows = mysql_num_rows($Recordset1);
echo "$num_rows Rows\n";?>:

Along with a remainder?
So how might the "do while" be formatted into three columns?
//these are "County" listings within each state, so each result will be a different # results//

halojoy

<?php
?>
<table> 
<?php do { ?> 
<tr> 
<td><input type="checkbox" name="commercial4[]" value="<?php echo $row_xrow['ComID']?>"> 
</td> 
<td><?php echo $row_xrow['County']?></td> 
</tr> 
<?php } while ($row_xrow = mysql_fetch_assoc($xrow)); ?> 
</table> 

<?php
// Into: 

else { 
$ADistance = ableDistanceHelp; 
while ($xrow = mysql_fetch_array($result)){ 
$Distance = $ADistance->Calculate($Latitude,$Longitude,$xrow["Latitude"],$xrow["Longitude"]); 
if ($Distance <= $Miles){ 
/***** RIGHT HERE; 
is where BEFOR wants a checkbox feature
*****/
} 
} 
} 
} 
mysql_close($dbConn); 

?>

Sorry,
did not read your problem right, BEFOR

Still my reminder might awake some other new members at our forum
to be VERY CLEAR in description of issue
and so make it easy on Helpers to do their voluntary help mission here

/halojoy

BEFOR

I've contacted the software vendor and they were a little clueless. Makes me wonder.

Anyway I've decided to do a while loop outside of this, so please disregard the above.

<table>
<?php
while ($row_Recordset15 = mysql_fetch_assoc($Recordset15))
{
echo \"<tr> <td><input type=\"checkbox\" name=\"commercial4[]\" value=\"<?php echo $row_Recordset15['ComID']?>\">
</td>
<td><?php echo $row_Recordset15['County']?>, <?php echo $row_Recordset15['State']?></tr></td>";
}//end while
echo "</table>"; ?>

What's wrong with this picture? What isn't escaped?

halojoy

what is wrong
okay lets have a look

first we use PHP tag, it is second from right in post editor window!
(there is also a HTML tag and CODE tag for other source codes)

<?php ?>

<table>
<?php 
while ($row_Recordset15 = mysql_fetch_assoc($Recordset15)) { 

echo \"
<tr>

<td>
<input type=\"checkbox\" name=\"commercial4[]\" value=\"<?php echo $row_Recordset15['ComID']?>\"> 
</td> 

<td>
<?php echo $row_Recordset15['County']?>, <?php echo $row_Recordset15['State']?>

</tr>
</td>"; 

}  //end while

echo "</table>"; 

?>

now we wait and see if halojoy or any other one can know whats wrong??
your php reported the following error or notice to us:
...
...

well halojoy already can see a few errors in that code
I guess you can see it, too
Cant you?

<?php
// we always have option to TURN ON php reporting
// at begginng, top, of any PHP page
error_reporting( E_ALL); // turns on ALL notices

// rest of page
echo "halojoy recommendation";
echo "but what does he know, anyway ...";


?>

BEFOR

I don't know what you are referring to.
If you are hinting at a line by line echo I've tried that too:

<?php 
while ($row_Recordset15 = mysql_fetch_assoc($Recordset15)) 
{ 
echo "<tr><td><input type="checkbox" name="commercial4[]" value="$row_Recordset15['ComID']">";
echo"</td><td>";
echo"$row_Recordset15['County']";
echo"</tr></td>"; 
}//end while 
echo "</table>"; ?>

Nothing. Page blanks out.