(easy one) decreasing amount select field

jonathen

Hi all,

Quick question:

I have a form select field which I need to grab an amount from a field in my db (numeric)

What I want this to do is select the amount from the db (i.e 10) and automatically populate the select field incrementally by reducing each number by one, so that the desired output is:

... and so on, down to 1.

Any ideas how I can achieve this? Using $++ makes it increase - how would I make it decrease?

Thanks,

Jonathen

james2010

Ok, so you're retrieving a numerical value from a table?
Try something like this

// retrieve one field
$query = mysql_fetch_assoc($query_result);

echo '<select name="name">';
for($i=$query['value'];$i>0;$i--) {
  echo '<option value="' . $i . '">' . $i . '</option>';
}
echo '</select>';

jonathen

Hmm, I see the logic in that, but get an empty select field, even though I have specified the variable I am pulling from the db:

$query = mysql_fetch_assoc($query_result); 
echo '<select name="seats">'; 
for($i=$query['$free'];$i>0;$i--) { 
  echo '<option value="' . $i . '">' . $i . '</option>'; 
} 
echo '</select>';

the variable i am pulling is $free. Am I missing something here?

Weedpacket

You've got an extra $ in there if you look closely enough.

jonathen

No... I don't see an additional $

Weedpacket

Trust me, it's there. Look very closely at james2010's code, look very closely at yours, and see what's different about them. If you're still lost, go to the manual and see what it says about associative arrays.

This is called debugging. It's a vital skill to learn.

jonathen

I see you must mean the $free - using it without the $ return null listings, so I used the $, assuming it would pull that field from the db as a variable. However, neither worked, so I'll take a look at assoc arrays and see what I am missing.

jonathen

Sorry! I should have looked in the manual, you're right. Got it working without a problem 🙂 Thanks for the patience guys!