[RESOLVED] Passing Multiple Values in Form field

[obrienkev]

Hi all,

I have the below checkbox that takes the course_ID value from database table.

I also need to pass the date field value. How do I do this??
$row['date']

echo '<input type="checkbox" name="course[]" id="course[]" value="'.$row['course_ID'].'" />';

So in the form processing I should be able to do this...

$query = "DELETE FROM date WHERE course_ID = '$value' AND date = '$date'";

Thanks guys.

[mrhappiness]

 echo '<input type="hidden" name="date['.$row['course_ID'].']" value="'.$row['date'].'" />'; 

this should help i believe (assuming 1 course_id only has 1 date field)

it should result in sth. like

<input type="checkbox" name="course[]" value="1" />
<input type="checkbox" name="course[]" value="75" />
<input type="checkbox" name="course[]" value="1578" />

<input type="hidden" name="date[1]" value="2005-01-08" />
<input type="hidden" name="date[75]" value="2005-08-13" />
<input type="hidden" name="date[1578]" value="2005-05-25" />

btw: don't use the same value for multiple id-attributes in your html, it's not that good as an id is supposed to be unique

[obrienkev]

OK. I was working on it and got this so far...

echo '<input type="checkbox" name="course[]" id="course[]" value="'.$row['course_ID'].'"&d="'.$row['date'].'" />';

When I view source it works fine - the date is set.
However, when I set the variables it doesn't register.

$course = $_POST['course'];
$date = $_POST['d'];

Why is this?

Using a foreach loop to process...

foreach($course as $key => $value)
{
echo $key. '=>' .$value. '<br />';

// Perform Query
$query = "DELETE FROM date WHERE course_ID = '$value' AND date = '$date'";
echo $query.'<br />';
//$result = mysql_query($query) or die(mysql_error());
}

Doesn't display a value fro $date

[mrhappiness]

my way produced:

<input type="checkbox" name="course[]" value="1" />
<input type="checkbox" name="course[]" value="75" />
<input type="checkbox" name="course[]" value="1578" />

<input type="hidden" name="date[1]" value="2005-01-08" />
<input type="hidden" name="date[75]" value="2005-08-13" />
<input type="hidden" name="date[1578]" value="2005-05-25" />

your way produces:

<input type="checkbox" name="course[]" value="1"&d="2005-01-08" />
<input type="checkbox" name="course[]" value="75"&d="2005-08-13" />
<input type="checkbox" name="course[]" value="1578"&d="2005-05-25" />

why don't you want to use my suggestion?
where from should the browser now that is has to transfer the &d-attribute (which btw doesn't exist) of your input tag?

 foreach($course as $key => $value)
{
echo $key. '=>' .$value. '<br />';

// Perform Query
$query = "DELETE FROM date WHERE course_ID = '$value' AND date = '$date'";
echo $query.'<br />';
//$result = mysql_query($query) or die(mysql_error());
}  

why do you expect $date to have a value using that code?
what's the output of this echo?

[obrienkev]

Didn't use yours because the checkboxes are dynamically assigned values.

this is my query echoes:
DELETE FROM date WHERE course_ID = '5' AND date = ''

[obrienkev]

Got it.

Here's checkbox...

echo '<input type="checkbox" name="course['.$row['course_ID'].']" id="course[]" value="'.$row['date'].'" />';

Then the loop:

foreach($course as $key => $value)
{
echo $key. '=>' .$value. '<br />';

// Perform Query
$query = "DELETE FROM date WHERE course_ID = '$key' AND date = '$value'";
echo $query.'<br />';
$result = mysql_query($query) or die(mysql_error());
}

Thanks mrhappiness. Your posts were a big help!