radio buttons and mysql results

[23style]

i have a table called tasks structured like so:

task_id - auto_increment primary key
project_id - project which the task applies to
task_description
status - either complete or incomplete

on an html page that displays the tasks

if status is complete..the radio button for complete is checked else the incomplete radio button is checked.

i can display the results fine...my problem is submitting the data to the database.

if the radio buttons could have 2 values (task_id and status) it would be so much easier...then i could update status = 'Complete' where task_id = '$task_id'

can anyone suggest a way i could accomplish this?

thanks 😃

[craigh]

use arrays as names for the form elements

name = task[id]

name= task[status]

[Pig]

NO, that will not work. Radio buttons only work if their name are the same. Otherwise they are treated as seperate entities, and should be checkboxes, not radio buttons.

Give each option a different value, not name.

name=same_name value=value1
name=same_name value=value2

[craigh]

Excuse me, what I meant was to name each GROUP of radio buttons with an array-type name with different values...

using the array names keeps all the groups together if you have multiple sets on the same page...

[mo0ness]

Like...

<input name="radio" name="radio[name_1]" value="value[value_1]">

Do u mean like that?

[craigh]

Originally posted by mo0ness
Like...

<input name="radio" name="radio[name_1]" value="value[value_1]">

Do u mean like that?

no,

I mean like this:
<input type="hidden" name="task[45][id]" value=45>
<input type="radio" name="task[45][status]" value="complete">
<input type="radio" name="task[45][status]" value="incomplete">

[23style]

ill give that a try

thanks!

[23style]

i can display the results that are in the databsae fine ( i set some value up in there for testing) with this:

$query = "select * from task_list";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

echo "<form action='update_tasks.php' method='POST'>";

echo "<table width='100%' cellPadding='0' cellSpacing='0'>";
echo "<tr><td width='100'><b>Task Id</b></td>";
echo "<td width='200'><b>Description</b></td>";
echo "<td><b>Incomplete</b></td>";
echo "<td><b>Complete</b></td></tr>";
echo "<tr><td>&nbsp;</td></tr>";

for ($i=0; $i<$num_results; $i++) {
	$row = mysql_fetch_array($result);
	$task_id = $row['task_id'];
	$task_description = $row['task_description'];
	$status = $row['status'];

echo "\n\n<tr><td>$task_id</td>\n";
echo "<td>$task_description</td>\n";

echo "\t<td><input type='radio' name='task[$task_id]' value='0'";

if ($status == 0) {
	echo "checked>";
}

echo "</td>\n";

echo "\t<td><input type='radio' name='task[$task_id]' value='1'";

if ($status == 1) {
	echo "checked>";
}

echo "</td>\n</tr>\n";

}

echo "</table>";

but im not sure how to update the values in the database when the user selects different radio button values.

how do i tell php which value corresponds to which task_id. it would be easy if i could just roll down the for loop using the i as a counter...but some tasks will be deleted by users so the auto_increment task_ids will change.

[23style]

nevermind...i figured it out 😃

thanks for the help everyone!

[trooper]

Its great that you figured it out

But can you post your solutions to this thread - the reason being that other people in the future may be having the same problem as you. And if they get to the end of the thead and see you statement

"i figured it" the'll want to know how / what you figured out

Cheers

GM

[23style]

of course, thats a great idea!

i made use of an earlier suggestion to use a hidden field...this is so i could associate a task_id with a value (either 0 for incomplete or 1 for complete)

for ($i=0; $i<$num_results; $i++) {
	$row = mysql_fetch_array($result);
	$task_id = $row['task_id'];
	$task_description = $row['task_description'];
	$status = $row['status'];

echo "\n\n<tr><td>$task_id</td>\n";
echo "<td>$task_description</td>\n";

echo "<input type='hidden' name='task_ids[$task_id]' value='$task_id'>\n";

echo "<td><input type='radio' name='status[$task_id]' value='0'";

if ($status == 0) {
	echo "checked>";
}

echo "</td>\n";

echo "<td><input type='radio' name='status[$task_id]' value='1'";

if ($status == 1) {
	echo "checked>";
}

echo "</td>\n</tr>\n";

}

// then, in the update script

foreach($task_ids as $value) {
	$query = "update task_list set status='$status[$value]' where task_id  = '$value'";
	$result = mysql_query($query);
}