Can special conditions be made in WHILE statement if output is first?

Similar to FOR statement if I had if($i==1){...}

[Jeremy_H]

I'm using PHP's while function to output data from a MySQL table:

$result=mysql_query("SELECT * FROM x WHERE parameter="y" ORDER BY z");
while($row=mysql_fetch_array($result))
echo "<input type=\"radio\" name=\"a\" value=\"".$row["b"]."\" checked=\"checked\" />";

What I'm trying to do is to get the first one that outputs to be checked, and the rest not to be checked. As written above, all will have the checked output which is invalid.

If this were a for statement, something like i=1;i<count;i++, then I could have a statement below that has a special condition if i==1.

Is there anything I can do like this for the while statement?

Might I be able to use the for statement and not mess up the output of the MySQL data?

Thanks

[eelixduppy]

You could do something like this:

while($row = mysql_fetch_array($result)) {
if($row['field']!= "foobar") {
[url=http://us2.php.net/break]break[/url];
}
//continue with loop
}

Good luck! :)

[edited by: eelixduppy at 4:30 pm (utc) on Jan. 20, 2007]

[mcavic]

It can be a for statement, as long as you still check for the condition where MySQL has no more data. Or even an if, if you only one the first record. There's nothing special about while.

Or, just implement your own counter in the while loop, to make it act like a for.

[cameraman]

Or you can do the first one separately:
$result=mysql_query("SELECT * FROM x WHERE parameter="y" ORDER BY z");
$row=mysql_fetch_array($result);
echo "<input type=\"radio\" name=\"a\" value=\"".$row["b"]."\" checked=\"checked\" />";
while($row=mysql_fetch_array($result))
echo "<input type=\"radio\" name=\"a\" value=\"".$row["b"]."\" />";

[coopster]

And yet another option is to build the list into a variable rather than echo it to the browser on each iteration. If the list is empty, you know you are on the first checkbox option and you can set it to be checked. Otherwise, set the checked option to nothing. Then concatenate [php.net] the output into your initialized variable, something along these lines ...

$out = ''; // initialize 
while (processing rows) { 
 $checked = ($out) ? '' : ' checked="checked"'; 
 $out .= '<input type="radio" name="a" value="' . htmlentities($row['b']) . "$checked />"; 
}