Need help with checkboxes and sql

[rxwepn]

Hi all, im sorta stuck...

I have successsfully interrogated an sql database, and created a loop that prints each row of the table:

while ( $a_row = mysql_fetch_row( $result ) ) {
print "</tr>\n";
foreach ($a_row as $field )
print "\t<td>$field</td>\n";
print "<td><input type=\"Checkbox\"></td>\n";
print "<td><input type=\"text\" maxlength=\"1\" size=\"5\"></td>\n";
print "</tr></div>\n";

It works fine, however, i need to actually make the checkbox function (as it is, it only prints a checkbox, but does nothing). The checkbox is to correspond to a shopping cart with php sessions, any help is greatly appreciated, thanks.

[the_Igel]

what do you mean by "i need to actually make the checkbox function"? If you click it, it becomes checked or unchecked - isn't it supposed checkbox functionality? 🙂

Seriously, it's not too easy to understand what do you mean. When printing out, there's not a lot to do except to print or to print not. The functionality comes to scene when you proccess the form data after submittion. You can put checkboxes like

<input type=checkbox name="something[]" value="123">

and then after submission you will have $something array with values for those boxes checked.

Not sure it helps, 'cause I don't know what you need 🙂

[rxwepn]

OK, sorry for the confusion..

As you can see, theres a checkbox and a text box output to screen. What i need to do is when a checkbox is checked, the corresponding textbox is enabled, so when i press the 'submit' button, it sends the input textbox number to another page..

hope that clarified things

[the_Igel]

You need some javascript.

smth like

<input type=checkbox
onChange="if (this.checked) document.all.input123.disabled = false;
else document.all.input123.disabled = true;">
<input name=input123>

I'm not very good in JS, still i hope this would work.
You'd rather write a function, that takes care of text inputs...