Displaying data from using check boxes

[MitchEvans]

I want my users to choose from several of my check boxes, once they submit these I want details to be displayed which are held in my database. For example if they choose "1" and "5" I want the text field relevant to "1" and "5" to be shown. Any ideas or help would be great!

Below is my code:

$connection=mysql_connect($host,$user,$password)
or die("couldn't connect to server");
$db=mysql_select_db($database,$connection)
or die ("Couldn't select database");
$query = "Select distinct Paragraph from paragraph order by Paragraph";
$result = mysql_query($query)
or die ("Couldn't execute query.");

echo "<div style='margin-left:.5in'>
<p>&nbsp;
<p><b>Which paragraphs do you want?</b>
<p>Choose as many paragraphs as you like:\n";

/form for checkboxes/
echo "<form action='index.php' method='POST'>\n";

while ($row=mysql_fetch_array($result))
{
extract($row);
echo"<input type='checkbox' name='check[$Paragraph]'
value='$Paragraph'>$Paragraph\n";
echo"<br>\n";
}
echo "<p><input type='submit' value='Submit final documentation'>
</form>\n";
foreach ($_POST as $field =>$value)
{
echo "$field, $value<br>";
}
?>
</div></body></html>

Cheers,

Mitch.

[cgraz]

Assuming your checkboxes are named id[]

$query = mysql_query("SELECT * FROM your_table WHERE id IN ('" . implode("','", $_POST['id']) . "')") or die(mysql_error());

[MitchEvans]

Does this query replace my orignal one? And also what needs to go in the speech marks("')?

[cgraz]

You would generate your checkboxes like this:

$query = "SELECT DISTINCT Paragraph, id FROM paragraph ORDER BY Paragraph";
$result = mysql_query($query) or die ("Couldn't execute query.");

$form = '<div style="margin-left: 0.5in">';
$form .= '<form method="post" action="index.php">';
$form .= '<p><b>Which paragraphs do you want?</b>.</p>' . "\n";
$form .= '<p>Choose as many paragraphs as you like:</p>' . "\n";

while($row = mysql_fetch_assoc($query))
{
	$form .= '<input type="checkbox" name="id" value="' . $row['id'] . '" /><br />' . $row['Paragraph'] . "\n";
}

$form .= '<input type="submit" name="submit" value="Submit final documentation" />' . "\n";
$form .= '</form>';
$form .= '</div>';


print $form;

Then on index.php (the script that processes this form, you would add in the SELECT query from my previous post. Fetch the query results into an array and use print_r() to see what it returns based on your selections. Then format it however you'd like.

[MitchEvans]

I already have the check boxes running fine. It's how I write the php so you can tell which ones have been chosen that's my problem. My code at the top is what i'm working with. Do you know what to do in order to get these results with this code. I need to use this code as it's looking at MySQL code, thankyou so much for your time and help

[cgraz]

the code i gave you will do just that, using mysql.

$POST['id'] will hold an array of the checkboxes that were selected, and each of their values will correspond with a value in the database. The query

SELECT * FROM your_table WHERE id IN ('" . implode("','", $_POST['id']) . "')

will pull all of the information from each of the rows corresponding to the id's (or checkboxes) selected by your user.

So if they selected 1, 3, and 5, you will have a mysql results holding all of the information for those three rows. Then to display, you use mysql_fetch_assoc and print $row['Paragraph'] or $row['whatever'] to display the information to them.

Unless I'm missing something, isn't that how you want this to work?