[Resolved] Dynamic Select name from form

dmacman1962

Hi everyone,

I am stuck on getting a dynamic name for the select tag for my quantity field in my form.

Here is the code snippet:

<?php  

$result = mysql_query("SELECT * FROM dealeritems, quantities Where dealeritems.productID = quantities.productID ORDER BY dealeritems.ID");  

while($row = mysql_fetch_assoc($result)) {  

	$ID = $row['ID']; 
?>  

<tr> 
        <td width="100"><?php echo $row['ID']; ?></td> 
        <td width="100"><?php echo $row['ItemName']; ?></td> 
        <td width="150"><?php echo $row['ItemDescription']; ?></td> 
        <td width="150"><?php echo $row['BodyCopy']; ?></td> 
		 <td width="150"><?php echo $row['Price']; ?></td>
		<!--<input type="hidden" name="price_<?php echo $row['ID']; ?>" value="<?php echo $row['Price']; ?>"> -->
        <td width="100"><img src="<?php echo $path.$row['ImageName']; ?>" width="100" height="125"></td> 
        <td width="150"> 
            <input name="order[]" type="checkbox" value="<?php echo $row['ID']; ?>"> 
                <!-- Aside: include hidden itemnames to be used 
                    in the 'thank you for your order message' --> 
            <input type="hidden" name="name_<?php echo $row['ID']; ?>" value="<?php echo $row['ItemName']; ?>"> 
        </td> 
        <td width="150"> 
				<select name="<?php "Quantity[$ID]\" id=\"Quantity.$ID\" "?>"> <option value="<?php $row['Quantity']; ?>">"<?php $row['Quantity']; ?>"</option>
            </select> 
        </td> 
    </tr> 
<?php  

}   ?>

What I get is no name for the select and a check mark, which is not what's in my table for the quantity for any of the items.

I know i in my code, I just have not been able to see my error.

I appreciate the help.

Thanks,

Don

kburger

I don't understand what you're trying to do with this part.

<select name="<?php "Quantity[$ID]\" id=\"Quantity.$ID\" "?>"> <option value="<?php $row['Quantity']; ?>">"<?php $row['Quantity']; ?>"</option>
            </select>

For one thing, this is not a valid statement:

<?php "Quantity[$ID]\" id=\"Quantity.$ID\" "?>

Nor is this (twice):

<?php $row['Quantity']; ?>

It might help you if you start by writing what you're trying to accomplish in simple HTML, then go back and write it using PHP. If you can't write a valid HTML form you won't be able to write it using PHP.

dmacman1962

What I am trying rto do with that line is get the name, dynamically, and the quantity from the table. Here is a HTML version.

 <select name="Quantity">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
  </select>

I am trying to get the name dynamically, and quanitities from the table.

Thanks,

Don

kburger

Then I think those lines should be

<select name="Quantity" id="Quantity">
<?php 
for ($i=1; $i<=$row['Quantity']; $i++) {
	echo "<option value=\"$i\">$i</option>\n";
}
?>
</select>

assuming $row['Quantity'] contains "3".

dmacman1962

Thanks Kburger, that did exactly what I was trying to accomplish.

I will mark this resolved!