Multiple Dropdown boxes with the same info...

bird_boy

Hey,
I'm having some problem with some code that I am trying to write. I am setting up a checkout for my school's bookstore (over an intranet), and I need to be able to have several dropdown boxes with the names of books. I have some code that actually creates the number of dropdown boxes, but it only populates the first dropdown list. However, I need it to put the names of the books in all of the dropdown lists. The code is as follows:
<snip>

		for($i=$num_books; $i>=0; $i--){
			$number = 1;
			echo "    <tr> ";
			echo "      <td width='50%'>Book# $number:&nbsp;<select name='checkout_book'>\n";
			echo " 		<option>Select A Book</option>\n";
			while($books = mysql_fetch_array($books_result, MYSQL_ASSOC)){
				$book_id = $books['book_id'];
				$title = $books['title'];
				echo " 		<option value=$book_id>$title</option>\n";;
			}
			echo "	</select></td>\n";
			$number++;
		}

</snip>
I am pretty sure that the while statement is only running through one time, however I'm not exactly sure how to fix it. Any suggestions?

leatherback

Hi,

although I am sure you can do it this way, and in some way resetting the query output, this is what I would do:


while($books = mysql_fetch_array($books_result, MYSQL_ASSOC))
  { 
   $book_id = $books['book_id']; 
   $title = $books['title']; 
   $option .="<option value=$book_id>$title</option>
   "; 
   }

for($i=0; $i<$num_books; $i++)
{ 
$number = 1; 
echo "
<tr><td width='50%'>
Book# $number:&nbsp;
<select name='checkout_book'>
<option>Select A Book</option>
$option
</select></td></tr>";
$number++; 
        }

bird_boy

I'm not really sure that would work either. Simply because I think it will only return the first row, and none of the rest...however I will give it a whirl to see...it's better then sitting here and not sure what to do 😃.

bird_boy

Oh...wait...I just noticed your period...couldn't see it in the post, but I could in my editor...that might actually work well.

gotta try now

bird_boy

Works...great. THANKS.