Loop question

[TimUSA]

I created this code for SMF and TP so there is no mysql_connect as it is not needed.

 

Just an example of what i am trying to do here. I have this code which pulls a list of names from a database in a selection box. I need to repeat it a designated number of times. What I am getting is the list in one box but not the rest. Any ideas?

$query = "SELECT `memberName` FROM `smf_members` WHERE `ID_GROUP` IN (1, 9, 10, 11, 13) ORDER BY `memberName`;";
$result = mysql_query($query);
$times = 13;
$x = 0;

while ($x < $times) {
echo'
<SELECT id="name" name="name[ ]" style="WIDTH: 160px" value ="';
echo '" />';

if(mysql_num_rows($result)) {
// we have at least one user, so show all users as options in select form
while($row = mysql_fetch_row($result))
{
print("<option value=\"$row[0]\">$row[0]</option>");
}
} else {
print("<option value=\"\">No users created yet</option>");
}
++$x;
}

[revraz]

May want to move your SELECT outside of the while loop unless you want 13 SELECT statements.  Also, I dont see a closing /SELECT tag.

[TimUSA]

i do need 13 select statements

[revraz]

This works for me, which is basically what you are doing minus the SQL

 

<?php 
$x=0;
$y=13;
while ($x< $y) {
echo "<select name='name'>";
echo "<option value=1>1</option>";
echo "</select>";
$x++;
}

?>

[Barand]

Once you have looped through the return results once any further fetch_row() calls return false as there is no more data to read.

 

You need to rewind to the beginning of the resultset each time with

 

mysql_data_seek($result, 0)

[TimUSA]

Thank you

Thank you

Thank you

Thank you

Thank you

Thank you