[RESOLVED] how: quantity pull-down llist depending on number in qty field

mars16

I have a field in my table called thats called quantity, for a particular record, i want the form pulldown list to go from 1 to whatever the figure in the qty field. can someone help me with the code? i assume its some sort of a loop?

ClarkF1

$quantity = x; //x = quantity from database

echo "<select name='quantity'>";

$i = 1;

while ($i <= $quantity)
{
echo "<option value=\"$i\">$i</option>";
$i++;
}
echo "</select>";

mars16

ClarkF1, if you don't please check my code, i tried to incoprate it in my code.

It's return a pulldown but empty/blank

//store all field names as variables
$name=$nextresult['name'];
$address=$nextresult['address'];
$city_name=$nextresult['city_name'];
$tel =$nextresult['tel'];
$website =$nextresult['website'];
$email =$nextresult['email'];
$quantity =$nextresult['rooms'];

// Print out the contents of the entry
print ("Hotel Name: $name");
print ("<br/>Address: $address");
print ("<br/>City: $city_name");
print ("<br/>Telephone: $tel");
print ("<br/>Website: $website");
print ("<br/>Email: $email");
print ("<br/>Quantity: $quantity");

print ("

<form action='processroombooking.php' method='post'>

<select name='quantity'>
$i = 1
while ($i <=$quantity)
<option value='$i'>$i</option>
$i++
}
</select>

<input type='submit' name='submit' value='Book'>

</form>
");

Am sure of the $quantity variable as it already return the correct values in th first section of the code. i think problem with quotation marks or something like that

leatherback

WHY did you not just copy=> paste his code? Read his post, and compare it with yours. there are a gazillion things missing.

All echo "" statements are missing
$i = 1 should be $i = 1;
A { is missing after the whil() statement
$i++ should be $i++;

mars16

if i copy n paste as it is i will get errors like "parse error, unexpected T_STRING in " which i think is to do with the extra echos, so i removed the echos and pasted inside the exsisting PRINT statment. the errors have disappeared but the pull down list is blank.

leatherback

You should not get parse errors on the code that was given to you. It looks fine to me.
How did you insert it?
(I may hope you did not place it in a print() statement?)

mars16

yes it's working fine, i was trying to be clever! i appercaite your help

mars16

if you don't mind can you explain the code in english so i understand what is happening? i kno the html, just don't understand the while statment, and the $i++

ClarkF1

Basically it just starts with $i =1 and $quantity equal to the quantity for your table.

The while bit checks to see if $i is less than or equal to the quantity. If it is it creates the option for 1. Then $i++; increments the value (adds one to it) and it checks whether $i is less than or equal to the quantity (this time $i = 2) and so on until $i is one greater than quantity. When this is the case, it stops doing the stuff in the { } and goes on to process the rest of the script.

mars16

Its all clear to me now, thanks for the quick replies and the help

leatherback

Please mark the thread resolved if it is (See thread tools);