Help with Drop down box inside of HTML table

Nipper10850

I'm trying to create a drop down box inside of a HTML table that was created using a while loop. Basically as far as I can tell everything is working correctly; only when I get to the last coloumn in the table I can't figure out the proper syntax to create the drop down list populated from the database. Please take a look at the code below and let me know what I'm doing wrong. any suqqestions are greatly appreciated.

// Get data from price table for drop down box
$quer2=mysql_query("SELECT * FROM `Price` WHERE Item_Num = '$variable2' "); 
// End query for price

//query Product table begins
$query = mysql_query("SELECT * FROM `Product` WHERE Cat_Index = '$cat' and Sub_Cat = '$cat3' "); 
while ($row = @mysql_fetch_array($query)) 
{ 
$variable1=$row["Pic"];
$variable2=$row["Item_Num"];
$variable3=$row["Name"]; 
$variable4=$row["Short_Des"]; 
//table layout for results 
print ("<tr align=\"center\">");
print ("<td><img src=\"images/products/$variable1.jpg\" height=\"64\" width=\"64\"></td>"); 
print ("<td>$variable2</td>"); 
print ("<td>$variable3</td>"); 
print ("<td>$variable4</td>");
print ("<td>");
while($noticia = mysql_fetch_array($quer2))
{
print ("<select name=\"price\" onchange=\"reload(this.form)\">
			<option>------</option>
			{<option value='$noticia[Price]'>$noticia[Desc] $noticia[Price]</option>}
			</select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			<input type=\"button\" value=\"Buy Now\">");
}
print ("</td>");

print ("</tr>"); 
}
//end

Roger_Ramjet

Create the drop down html code before the loop and then just add the string inside the loop

// Get data from price table for drop down box
$quer2=mysql_query("SELECT * FROM `Price` WHERE Item_Num = '$variable2' "); 
// End query for price

// NOW CREATE DROP DOWN CODE
$strDrop = '<select name="price" onchange="reload(this.form)">';
while ($row = mysql_fetch_array($quer2)) {
     $strDrop .= '<option value="' . $row['Price']. '">' .$row['Desc']. '  ' .$row['Price']. '</option>';
}
$strDrop .= '</select>';

//THEN USE IT HERE
while ($row = @mysql_fetch_array($query)) 
{ 
...........

...........
echo '<td>' . $strDrop .'</td>';

Nipper10850

Thanks. That works perfect. I'm having a little trouble with populating the drop down box, but I have had that problem before, so I'm sure I will be able to get it figured out.
Thanks for the fast reply.

Nipper10850

It's working great now (almost). I have another problem now maybe you can help.

What is occuring is a table is created by pulling certin fields from a database. The information from the database is then used to populate the drop down box in the last field.

If there is more than one row in the table what ever the value is for the last row is what is used to populate every drop down box on the screen. This of couse is not what I'm trying to do.

I have tested the query and the loop and I get all the values that I need but they are not being used by the loop to populate the drop down boxes correctly. If you can please take a look at the code I have. I think it has to do with nested loops and possible using an array to store the results, but can't figure it out.

Here is the code.

//query Product table begins to get correct value for drop down box
$query = mysql_query("SELECT * FROM `Product` WHERE Cat_Index = '$cat' and Sub_Cat = '$cat3' "); 
//pull the value to pass to drop down box
if ($row = mysql_fetch_array($query))
{ 
$price = $row["Item_Num"];
}

// Get data from price table for drop down box
$quer1=mysql_query("SELECT * FROM `Price` WHERE Item_Num = '$price' "); 


// Creat drop down box 
$strDrop = '<select name="price" onchange="reload(this.form)">'; 
if ($row = mysql_fetch_array($quer1)) 
{
     $strDrop .= '<option value="' .$row['Price']. '">' .$row['Desc']. '&nbsp;&nbsp;  $' .$row['Price']. '</option>'; 
} 
$strDrop .= '</select>';


//query product table second time for the rest of the display
$query2 = mysql_query("SELECT * FROM `Product` WHERE Cat_Index = '$cat' and Sub_Cat = '$cat3' "); 

while ($row = @mysql_fetch_array($query2)) 
{ 
$variable1=$row["Pic"];
$variable2=$row["Item_Num"];
$variable3=$row["Name"]; 
$variable4=$row["Short_Des"]; 
//table layout for results 
print ("<tr align=\"center\">");
print ("<td><img src=\"images/products/$variable1.jpg\" height=\"64\" width=\"64\"></td>"); 
print ("<td>$variable2</td>"); 
print ("<td>$variable3</td>"); 
print ("<td>$variable4</td>");
print ("<td>$strDrop</td>");
print ("<td><form target=\"paypal\" action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\">
			<input type=\"hidden\" name=\"cmd\" value=\"_ext-enter\">
			<input type=\"hidden\" name=\"redirect_cmd\" value=\"_xclick\">
			<input type=\"hidden\" name=\"business\" value=\"*..*\">
			<input type=\"hidden\" name=\"item_name\" value=\"$variable3\">
			<input type=\"hidden\" name=\"currency_code\" value=\"USD\">
			<input type=\"hidden\" name=\"amount\" value=\"$cat4\">
			<input type=\"image\" src=\"http://www.paypal.com/en_US/i/btn/x-click-but01.gif\" name=\"submit\" alt=\"Secure payments by paypal\">
</form></td>");
print ("</tr>"); 
}
//end
?>