check box value update problem

[raffael3d]

I have this form:

echo '<form action="' . $cgi . ';action=notify6" method="post">';
while ($row5 = mysql_fetch_assoc($request5))
		{
			($row5['name']);
<input type="checkbox" name="board-' . $row5['ID_BOARD'] . '" value="1" /><a href="' . $scripturl . '?board=' . $row5['ID_BOARD'] . '">' . $row5['name'] . '</a>
<input type="reset" value="' . $txt[329] . '" />&nbsp;&nbsp;&nbsp;<input type="submit" value="' . $txt[417] . '" />

and here it is processed:

function Notify5 ()
{
	global $username, $ID_BOARD, $txt, $HTTP_POST_VARS, $ID_MEMBER, $db_prefix, $doLimitOne;

checkSession();

if ($username == 'Guest') 
	fatal_error($txt[138]);

foreach ($HTTP_POST_VARS as $key=>$value)
	if (substr($key, 0, 6) == 'board-' && $value)
	{
		$board = substr($key, 6);

		$request = mysql_query("
			SELECT notifies
			FROM {$db_prefix}boards
			WHERE (ID_BOARD = $board)
			LIMIT 1") or database_error(__FILE__, __LINE__);

		list ($notification) = mysql_fetch_row($request);
		$notifies = explode(',', $notification);
		$notifications2 = array();

		foreach ($notifies as $note)
			if ($note != $ID_MEMBER)
				$notifications2[]=$note;

		$notification = implode(",", $notifications2);
		$request = mysql_query("
			UPDATE {$db_prefix}boards
			SET notifies = '$notification'
			WHERE ID_BOARD = $board
			$doLimitOne") or database_error(__FILE__, __LINE__);
	}

ShowNotifications();
}

it works perfectly when an entry should be REMOVED. Now I have to change it that an entry is ADDED, how can I do that? which part has to be changed? thanks.

[orangehairedboy]

It's really hard to tell...because I can't make heads or tails what this script is supposed to do...

My first guess would be to change:

if ($note != $ID_MEMBER)

to

if ($note == $ID_MEMBER)

But I doubt myself on that.

If you could please explain what this script does and how [whatever] is added or removed?

Thanks!

Lewis

[raffael3d]

ok

the goal is: the scrips enter a userID into a column of a board (my forum has several boards, that you can subscribe to so you get an email if a message is posted, eveything works fine, except that I can activate my notification for several boards at the same time using the checkboxes)

I have seveal checkboxes like this

<input type="checkbox" name="board-' . $row5['ID_BOARD'] . '" value="1" />

(so the boxes have in the end the name "board-1, board-2. board-3")

that are submitted via a form.
then comes the part I don't know: the values of the ckeckboxes have to be transformed so taht I can use them.

then I get the list of other entries that are already in the column (other member ID's might already be in there:

request = mysql_query("
SELECT notifies
FROM {$db_prefix}boards
WHERE (ID_BOARD = $board)
LIMIT 1") or database_error(FILE, LINE);

so I have the list with the current entries:
list ($notification) = mysql_fetch_row($request);

now I have to add the new memberID to that list.

and all of that has to happen for several boards.

[raffael3d]

the scripts above shows how entries can be removed from the list. I need that script transformed that the entries are ADDED instead.