PHP - Checkbox Array From Mysql Need To Remember If Checked On Form Self

Hello,

I have been spending over 6 hours trying to square this away and I have looked at some tutorials from PHPFreaks... Maybe I'm missing something.

Basically I rebuilding the form from bottom up and I thought some check boxes would be easier for some part of the form instead of drop-down menu.

Basically this form is submitting query to MySQL:

article_add.php (Basically has the form)
article_insert.php (Basically insert the data to MySQL)

Here is one part of the form where the check box is located:

Here is article_add.php

<form action="article_insert.php" method="post">
<-- 
OTHER INPUT BOXES
-->
<div class="inputfieldtb"><label for="news_cat">News Categories:</label>
    <?
echo "<table>";
echo "<tr>";

$counter = 1;
                            while ($nc = mysql_fetch_array($news_cats)) {
$ncat_id = $nc['ncat_id'];
$ncat_name = $nc['ncat_label'];

echo "<td><div><input type=\"checkbox\" name=\"category[]\" value=\"$ncat_id\" ''/>$ncat_name</div></td>\n";

if (($counter % 4) == 0) {
echo "</tr><tr>";
}
$counter ++;
}
echo "</tr></table>";
                            echo "<br />";
?>
    </div>
<-- 
MORE FORMS
-->
</form>



Here is article_insert.php



// CONNECT TO DATABASE
include("../mods/connect.php");

<--- 
OTHER DATA INSERT IN MYSQL
-->

$news_cat = mysql_real_escape_string(implode(',', $_POST['category'])); // <-- Checkbox Data

<--- 
MORE DATA INSERT IN MYSQL
-->

$query = "INSERT INTO news_articles VALUES ('<--- MORE CONTENT BEING INSERT INTO MYSQL -->,'$news_cat','$news_content',<--- MORE CONTENT BEING INSERT INTO MYSQL -->'')";
mysql_query($query) or die ('Error inserting new data into the data to the database: ' . mysql_error() . '');


The error I'm getting is "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','','3','0','','','')' at line 1";


So what am I doing wrong? 

Once I get this resolved, I would like to learn how to display the checkbox / updated the checkbox as well.

Thank you in advance for your time and your help with this problem.

Hi:

How do I check to see if a checkbox has not been checked? Would the same rules apply to a radiobutton?

This is what I have:

          Code: [Select]
<input name="status[1]" id="approved" value="<?php echo $_POST['approved'] ?>" type="checkbox"  /> <label for="approved">Approved</label>
Code: [Select]
if (isset($_POST['status[1]'])):
$errMsg['status[1]'] = "Must select a status.";
endif;
I tested it out, but it just prints the error message even if I have checked it

I am using the following piece of code to open a new window when a checkbox is checked...

<INPUT type="checkbox" name="name" value="YES" onClick="window.open('/somepage.php?do=something&id=<?php echo $SOMEID["id"] ?>','','width=600,height=350,left=100,top=100,screenX=100,screenY=100')">

The page opens ok when the checkbox is ticked (checked).

PROBLEM:
The page opens again if the checkbox is un-ticked (un-checked).

I just want to open the page if the checkbox is ticked only but not sure how to do this?

OTHER INFO:
Seperate checkboxes are dynamically created on the page for each  id=<?php echo $SOMEID["id"] ?>

hi all

I have 3 checkboxes whose values are getting stored in the database with a comma separator.

Code: [Select]
<input name="color[]" type="checkbox" value="red" id="red" />red 
<input name="color[]" type="checkbox" value="blue" id="blue" />blue
<input name="color[]" type="checkbox" value="green" id="green" />green

values getting stored with comma separator

Code: [Select]
red, blue, green

now i want to show the checkboxes as "checked" to show the customer as which colors they chose lasttime when they submitted the form.

How can i make it possible ?

If it is possible without the comma separator then i can remove the comma.

vineet

What is the best way using php to see if a checkbox is checked or not.

 I see so many different options out there googling, that I am interested knowing the most robust method.

Thanks

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=349419.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=349419.0

Hello,

Hope someone can help me cause i been at it all day and google woul'dn't help me.

I been writing a little script which generates a list of numbers you can check and make a list of the numbers that have been checked. Now when i use $_get to the next page everything works but now i need to take the url and use $_get back to the generated check box list and it needs to know by the url which box had been checked and checked that one so the list can be altered. here is my code sofar
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>AH plaatjes.</title>
</head>

<body name="top">
Meer info beneden aan de pagina. <a href="#beneden">Naar beneden.</a>
<p>
  <script language=JavaScript>
function set(n)
{
temp = document.form1.elements.length ;
for (i=0; i < temp; i++)
{ document.form1.elements[i].checked=n;
}
}

function checkall()
{
void(d=document);
void(el=d.getElementsByName('check'));
for(i=0;i<el.length;i++)
void(el[i].checked=1)
}

//invert
function invers(){
temp = document.form1.elements.length ;
for (i=0; i < temp; i++){
if(document.form1.elements[i].checked == 1){document.form1.elements[i].checked = 0;}
else {document.form1.elements[i].checked = 1}
}
}


</script>
</p>
<form id="form1" name="form1" method="get" action="./readlist.php">
<label>Naam eigenaar lijstje:<input name="naam" type="text" /></label>
<label>Lijst van selectie plaatjes<select name="collect">
  <option value="0">selecteer optie!</option>
  <option value="1">in decollectie</option>
  <option value="2">nog niet in collectie</option>
  <option value="3">dubbele collectie</option>
</select></label>
  <p>
  <?php
  //TO Do trying to get the checkboxes checked with get and array
 
  
  /////////////////

  do {
  $i = $i+1;
  echo "
      <input type=\"checkbox\" name=\"checked[]\" id=\"check\" value=\"". $i ."\"/>
      <label for=\"". $i ."\">". $i ."</label>
      <br />
";
if($i > 324){break;}
  }// end do
  while($i < 325);
?>
   
  </p><input name="check" type="submit" value="Print lijst" />
  <input type=button onClick="checkall()" value="selecteer alles" name="button">
  <input name=button onclick="invers()" type=button value=" Keer selectie om ">
      <INPUT name=button onclick=set(0) type=button value=" Reset "> 

</form>
<p><a name="beneden">De geselecteerde nummers komen overzichtelijk in een lijstje. Zo heb je heel overzichtelijk een lijst met de nummers die je al hebt of juist nog niet hebt. Die kan je dan doorsturen selecteren en kopieren met je rechtermuis knop en naar je kennissen of vrienden sturen.</a> ook kan je de url (webadres) kopieren en doorgeven.</p>
<p><a href="#top">Naar boven.</a></p>
</body>
</html>




Now what i need is when you fill out an url like http://localhost/ah/index.php?checked%5B%5D=2&checked%5B%5D=3 it needs to check the same boxes. please help me out thanks in advance

Why is it grouping the checked boxes instead of keeping them in order like area is?
if(isset($_POST['submit'])){
for($i=0; $i<10; $i++){
echo "<br />Ignore = [".$_POST['ignore'][$i]."]";

if($_POST['ignore'][$i]!="true")
echo ", Area = ".$_POST['area'][$i];
}
}
else
{
echo "<form method='post'><table>";
for($i=0; $i<10; $i++){
echo "
 <tr>
  <td><input type='checkbox' name='ignore[]' value='true' /></td>
  <td><input type='text' name='area[]' /></td>
 </tr>\n";
}
echo "
</table>
<input type='submit' name='submit' value='Submit' />
</form>";
}

Input:
Quote

Checked - ignored
Unchecked - a
Checked - ignored2
Unchecked - b
Checked - ignored3
Unchecked - c
Unchecked - d
Checked - ignored4
Unchecked - e
Checked - ignored5


Output:
Quote

Ignore = [true]
Ignore = [true]
Ignore = [true]
Ignore = [true]
Ignore = [true]
Ignore = [], Area = c
Ignore = [], Area = d
Ignore = [], Area = ignored4
Ignore = [], Area = e
Ignore = [], Area = ignored5

Hi all,

Im creating a simple quiz where some of the questions are checkbox because there is more than one correct answer.  What I would like to be able to do, is run an if statement to check if, say for example, options 1 and 5 out of 6 have been selected, then award the point. However the point is only awarded is both options are selected.

Any suggestions?

Thank you in advance

So I got help from here earlier with one problem and a few more have arisen,  the biggest is for some reason my checkbox and dropdown array won't store the data and when it's supposed to check to verify there is at least 1 selected of each nothing happens...

To be honest the ideal thing would be to have it check to see if the drop down size selection below the checkbox was selected, but I'll do whatever as long as it works.

Thanks ahead of time for the help.

Here's my page code:
Code: [Select]
<html>
<HEAD>
</head>
<body>
<?php
require_once "formvalidator.php";
  $error_hash = 'no';
  $show_form = true;
class MyValidator extends CustomValidator
{
function DoValidate(&$formars,&$error_hash)
{
        if(stristr($formars['comments'],'http://'))
        {
            $error_hash['comments']="No URLs allowed in comments";
            return false;
        }
return true;
}
}
  if ($_SERVER['REQUEST_METHOD'] == "POST") {

      $validator = new FormValidator();
      $validator->addValidation("email", "email", "<B>Email address is invalid.</B>");
      $validator->addValidation("first", "req", "<B>Please provide your First name for invoice.</B>");
      $validator->addValidation("last", "req", "<B>Please provide your Last name for invoice.</B>");
      $validator->addValidation("addr", "req", "<B>Please provide your address for invoice.</B>");
      $validator->addValidation("city", "req", "<B>Please provide your city name for invoice.</B>");
      $validator->addValidation("state", "req", "<B>Please provide your State for invoice.</B>");
      $validator->addValidation("zip", "num", "req", "<B>Please provide your zip for invoice.</B>");
      $validator->addValidation("phone", "num", "<B>Numbers only in phone number.</B>");
      if ($validator->ValidateForm()) {
          $show_form = false;
      } else {
          echo "<center><font color='#CC0000'><B>Validation Errors:</B></font></center>";
          $error_hash = $validator->GetErrors();
          foreach ($error_hash as $inpname => $inp_err) {
              echo "<center><p>$inpname : $inp_err</p></center>\n";
              $show_form = true;
          }
      }
$pic = $_POST['pic'];
if(empty($pic)) 
  {
    echo "<center><font color='#CC0000'><B>Please Select a picture.</B></font></center>";
  } 
  else 
  {
    $r = count($pic);
    for($i=0; $i < $r; $i++)
    {
      echo "picture(s) requested $i was: " . $pic[$i] . "\r\n";
    }
  }

$size = $_POST['size'];
if(empty($size)) 
  {
    echo "<center><font color='#CC0000'><B>Please Select a picture size.</B></font></center>"; 
  } 
  else 
  {
    $r = count($size);
    for($i=0; $i < $r; $i++)
    {
      echo "Sizes(s) requested $i was: " . $size[$i] . "\r\n";
    }
  }
          if ($show_form === false){
          // Grab the form vars
  $Pic = $_POST['pic'] ;
  $Size = $_POST['size'] ;
          $Email = $_POST['email'];
          $Name = $_POST['first'. 'last'];
          $Addr = $_POST['addr'];
          $City = $_POST['city'];
          $State = $_POST['state'];
          $Zip = $_POST['zip'];
  $comments = $_POST['comments'] ;
 


        //message body
        $mail_body .= "$Pic"."\r\n";
        $mail_body .= "$Size"."\r\n";
        $mail_body .= "$Email"."\r\n";
        $mail_body .= "$Name"."\r\n";
        $mail_body .= "$Addr"."\r\n";
        $mail_body .= "$City,". " $State". " $Zip"."\r\n";
        $mail_body .= "$Comments"."\r\n";
        //sending to
        $recipient = "hakarune@gmail.com";
        $subject = "Order Form";
        //Headerfields
        $header = "From: " . $Email . " <" . $Email . ">\r\n";
        //mail command
        mail($recipient, $subject, $mail_body, $header);
                                   
          echo "<div style='width:400px; margin:0 auto; border:1px solid #1e1e1e'>Your order has been sent successfully. <br>An Invoice will be either emailed or mailed to you, thank you for your order.<br>You will be redirected to the home page in 10 seconds...</div>";
                        //page redirect to home
                                         echo "<META HTTP-EQUIV=\"refresh\" content=\"10;URL=buttontest3.php\">";

  }
}
  if (true == $show_form) {
?>

<form name="ordering" action="" method="POST">
<img src="1.jpg" />
<input type="checkbox" name="pic[]" value="1">
<br />
<select name="Type" size="1" name="size[]">
  <option value="">Select Type</option>
  <option value="Original">Original $Price</option>
  <option value="Print Small">300x500 Print $Price</option>
 <option value="Print Medium">800x600 Print $Price</option>
 <option value="Print Large">1200x1280 Print $Price</option>
 <option value="Print XLarge">1282x1400 Print $Price</option>
</select>
<br />
<img src="2.jpg" />
<input type="checkbox" name="pic[]" value="2">
<br />
<select name="Type" size="1" name="size[]">
  <option value="">Select Type</option>
  <option value="Original">Original $Price</option>
  <option value="Print Small">300x500 Print $Price</option>
 <option value="Print Medium">800x600 Print $Price</option>
 <option value="Print Large">1200x1280 Print $Price</option>
 <option value="Print XLarge">1282x1400 Print $Price</option>
</select>
<br />
<img src="3.jpg" />
<input type="checkbox" name="pic[]" Value="3">
<br />
<select name="Type" size="1" name="size[]">
  <option value="">Select Type</option>
  <option value="Original">Original $Price</option>
  <option value="Print Small">300x500 Print $Price</option>
 <option value="Print Medium">800x600 Print $Price</option>
 <option value="Print Large">1200x1280 Print $Price</option>
 <option value="Print XLarge">1282x1400 Print $Price</option>
</select>
<br />
<img src="4.jpg" />
<input type="checkbox" name="pic[]" value="4">
<br />
<select name="Type" size="1" name="size[]">
  <option value="">Select Type</option>
  <option value="Original">Original $Price</option>
  <option value="Print Small">300x500 Print $Price</option>
 <option value="Print Medium">800x600 Print $Price</option>
 <option value="Print Large">1200x1280 Print $Price</option>
 <option value="Print XLarge">1282x1400 Print $Price</option>
</select>
<br />
<img src="5.jpg" />
<input type="checkbox" name="pic[]" value="5">
<br />
<select name="Type" size="1" name="size[]">
  <option value="">Select Type</option>
  <option value="Original">Original $Price</option>
  <option value="Print Small">300x500 Print $Price</option>
 <option value="Print Medium">800x600 Print $Price</option>
 <option value="Print Large">1200x1280 Print $Price</option>
 <option value="Print XLarge">1282x1400 Print $Price</option>
</select>
<br />
<br />
<br />
Information For Invoice: <font color="red">(Required Info = *)</font>
<br />
<input type="text" name="first" Value="First Name" size="25" onfocus="value=''"><font

color="red">*</font>
<input type="text" name="last" Value="Last Name" size="25" onfocus="value=''"><font

color="red">*</font>
<br />
<input type="text" name="phone" Value="phone Number" size="25" onfocus="value=''">
<br />
<input type="text" name="email" Value="E-mail" size="30" onfocus="value=''">
<br />
<input type="text" name="addr" Value="Street Address" size="50" onfocus="value=''"><font

color="red">*</font>
<br />
<input type="text" name="city" Value="city" size="30" onfocus="value=''"><font

color="red">*</font>
<br />
<select name="state" size="1">
<option value="">Select State</option>
<option value="AK">AK</option>
<option value="AL">AL</option>
<option value="AR">AR</option>
<option value="AZ">AZ</option>
<option value="CA">CA</option>
<option value="CO">CO</option>
<option value="CT">CT</option>
<option value="DC">DC</option>
<option value="DE">DE</option>
<option value="FL">FL</option>
<option value="GA">GA</option>
<option value="HI">HI</option>
<option value="IA">IA</option>
<option value="ID">ID</option>
<option value="IL">IL</option>
<option value="IN">IN</option>
<option value="KS">KS</option>
<option value="KY">KY</option>
<option value="LA">LA</option>
<option value="MA">MA</option>
<option value="MD">MD</option>
<option value="ME">ME</option>
<option value="MI">MI</option>
<option value="MN">MN</option>
<option value="MO">MO</option>
<option value="MS">MS</option>
<option value="MT">MT</option>
<option value="NC">NC</option>
<option value="ND">ND</option>
<option value="NE">NE</option>
<option value="NH">NH</option>
<option value="NJ">NJ</option>
<option value="NM">NM</option>
<option value="NV">NV</option>
<option value="NY">NY</option>
<option value="OH">OH</option>
<option value="OK">OK</option>
<option value="OR">OR</option>
<option value="PA">PA</option>
<option value="RI">RI</option>
<option value="SC">SC</option>
<option value="SD">SD</option>
<option value="TN">TN</option>
<option value="TX">TX</option>
<option value="UT">UT</option>
<option value="VA">VA</option>
<option value="VT">VT</option>
<option value="WA">WA</option>
<option value="WI">WI</option>
<option value="WV">WV</option>
<option value="WY">WY</option>
</select>
<br />
<input type="text" name="zip" Value="Zipcode" size="5" onfocus="value=''"><font

color="red">*</font>
<br />
<textarea name="comments" rows="5" cols="20" value="comments" onfocus="value=''">
  </textarea>
<br />
<input type="Submit" value="Submit">
<input type="reset" value="Clear Form">
</form>
<?php
      }//true == $show_form
?>
</body>
</html>

i have an html form which is a "post"

on it i have an array of checkboxes and a sumbit button, once button is clicked i go to another page where i handle those boxes checked
the problem now is if NO checkboxes are checked and i hit the submit...i get errors on the other page
my code:
 foreach($product_names as $product_row) { ?>
            <tr>
                <td >&nbsp;</td><td width='200px'><?php echo $product_row->getName(); ?></td>
                <td width='200px'><input type="checkbox" name="graphic[]" value="<?php echo  $product_row->getId();?>" /></td>
                <td width='200px'><input type="checkbox" name="text[]"    value="<?php echo  $product_row->getId();?>" /></td>
            </tr>
            <?php }         
            ?>
       </table>
        <table>
            <tr>
                <td>
                <input type='submit' name='submit' value='Submit'> 
                <?php
                    if ( (isset($graphic)) || (isset($text) ))
                    {
                       echo "checkboxes checked";
                      //show submit button
                    }
                    else
                    {
                        //hide submit botton and
                        echo "no boxes check";
                    }
                ?>

the above is NOT working
please help????

Hey guys, how do I send checkbox variables to my e-mail address once a user has checked it on the html form.

Here is my html form:


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>Form</title>
<script type="text/javascript">
//email form validation

function everif(str) {

var at="@"
var punct="."
var lat=str.indexOf(at)
var lstr=str.length
var lpunct=str.indexOf(punct)
if (str.indexOf(at)==-1){
   alert("Valid email must be entered")
   return false
}

if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){
   alert("Valid email must be entered")
   return false
}

if (str.indexOf(punct)==-1 || str.indexOf(punct)==0 || str.indexOf(punct)==lstr){
    alert("Valid email must be entered")
    return false
}

 if (str.indexOf(at,(lat+1))!=-1){
    alert("Valid email must be entered")
    return false
 }

 if (str.substring(lat-1,lat)==punct || str.substring(lat+1,lat+2)==punct){
    alert("Valid email must be entered")
    return false
 }

 if (str.indexOf(punct,(lat+2))==-1){
    alert("Valid email must be entered")
    return false
 }

 if (str.indexOf(" ")!=-1){
    alert("Valid email must be entered")
    return false
 }

   return true
}

function evalid(){
var emailID=document.contact_form.mail

if (everif(emailID.value)==false){
emailID.focus()
return false
}

//empty field validation

var naam=document.contact_form.naam
if ((naam.value==null)||(naam.value=="")){
        alert("Fields marqued with * must be entered")
        naam.focus()
        return false
        }

var telefoon=document.contact_form.telefoon
if ((telefoon.value==null)||(telefoon.value=="")){
        alert("Fields marqued with * must be entered")
        telefoon.focus()
        return false
        }
 
var branche=document.contact_form.branche
if ((branche.value==null)||(branche.value=="")){
        alert("Fields marqued with * must be entered")
        branche.focus()
        return false
        }

return true
 }
 </script>

</head>

<body>

 <form name="contact_form" method="post" id="contactform" action="doeactie.php" onSubmit="return evalid()">
<table border="0">
<tr>
   <td><label for="bedrijfsnaam">Company name</label></td>
    <td colspan="2"><input name="bedrijfsnaam" type="text" class="text" size="30" /></td>
  </tr><tr>
    <td><label for="naam">Name *</label></td>
     <td colspan="2"><input name="naam" type="text" class="text" size="30" /></td>
   </tr><tr>
     <td><label for="mail">E-mail *</label></td>
     <td colspan="2"><input type="text" name="mail" class="text" size="30" /></td>
   </tr><tr>
     <td><label for="adres">Address</label></td>
     <td colspan="2"><input name="adres" type="text" class="text" size="30" /></td>
   </tr><tr>
     <td><label for="plaatsnaam">City</label></td>
     <td colspan="2"><input name="plaatsnaam" type="text" class="text" size="30" /></td>
   </tr><tr>
     <td><label for="postcode">Zip</label></td>
     <td colspan="2"><input type="text" name="postcode" class="text" size="10" /></td>
   </tr><tr>
     <td><label for="branche">Niche *</label></td>
     <td colspan="2"><input name="branche" type="text" class="text" size="30" /></td>
   </tr><tr>
     <td><label for="telefoon">Phone *</label></td>
     <td colspan="2"><input name="telefoon" class="text" type="text" size="30" /></td>
   </tr><tr>
     <td><label for="bericht">Question or Comment</label></td>
     <td colspan="2"><textarea name="message" class="text" onkeyup="return limitarelungime(this, 255)"  cols="35" rows="5"></textarea></td>
</tr>
</table>

       <table cellpadding="0" cellspacing="0" border="0">
   <tr>
   <td></td>
<td height="25"></td>
  </tr>
  <tr>
   <td></td>
<td height="30" valign="top"><font face="arial" size="2"><b>I would also like to receive information about :</b></font></td>
  </tr>
  <tr>
   <td><input type="checkbox" name="emailmarketing" id="emailmarketing" value="emailmarketing" /></td>
<td height="25"><font face="arial" size="2">E-mail Campaign</font></td>
  </tr>
  <tr>
   <td><input type="checkbox" name="zoekmachopt" id="zoekmachopt" value="zoekmachopt" /></td>
<td height="25"><font face="arial" size="2">SEO</font></td>
  </tr>
  <tr>
   <td><input type="checkbox" name="socialmedia" id="id" value="socialmedia" /></td>
<td height="25"><font face="arial" size="2">Social Media</font></td>
  </tr>
  <tr>
   <td><input type="checkbox" name="videomarketing" id="videomarketing" value="videomarketing" /></td>
<td height="25"><font face="arial" size="2">Video Marketing</font></td>
  </tr>
  <tr>
   <td><input type="checkbox" name="webshop" id="webshop" value="webshop" /></td>
<td height="25"><font face="arial" size="2">Webshop</font></td>
  </tr>
  <tr>
   <td><input type="checkbox" name="cms" id="cms" value="cms" /></td>
<td height="25"><font face="arial" size="2">Content Management System</font></td>
  </tr>
  <tr>
   <td><input type="checkbox" name="grafisch" id="grafisch" value="grafisch" /></td>
<td height="25"><font face="arial" size="2">Graphic Design</font></td>
  </tr>
     <tr>
     <td></td>
     <td align="left"><br /><input type="submit" name="Submit" value="Send"></td>
<td align="right"></td>
     </tr>
  </table>
       </form>

</body>
</html>




and this is the PHP script that processes this.
Everything works except for the checkbox part.


<?php session_start();
if(isset($_POST['Submit'])) {
$youremail = 'blabla@gmail.com';
$fromsubject = 'Request from form';
$bedrijfsnaam = $_POST['bedrijfsnaam'];
$naam = $_POST['naam'];
$mail = $_POST['mail'];
$adres = $_POST['adres']; 
$plaatsnaam = $_POST['plaatsnaam']; 
$postcode = $_POST['postcode']; 
$branche = $_POST['branche']; 
$telefoon = $_POST['telefoon']; 
$message = $_POST['message']; 
$to = $youremail; 
$mailsubject = 'Bericht ontvangen van'.$fromsubject.' Actie Pagina';
$body = $fromsubject.'

Bedrijfsnaam:  '.$bedrijfsnaam.'
Naam Contact Persoon:  '.$naam.'
E-mail: '.$mail.'
Adres: '.$adres.'
Plaatsnaam: '.$plaatsnaam.'
Postcode: '.$postcode.'
Branche: '.$branche.'
Telefoonnummer: '.$telefoon.'

vraag of Wens: 
 '.$message.'



|---------End Message----------|'; 
echo "thank you for your request we will contact you asap."; 
mail($to, $subject, $body);
 } else { 
echo "Error Please <a href='form.html'>try again</a>"; 
}
?> 



Any help would be great!
Thanks guys

Hello,   I want to show checkbox is checked when there is entry of that id in a table in my database.    I have 2 tables page and access_level. I am getting data from page table and displays it in <ul><li> tag with checkbox to select all or only few. After selecting the checkbox, i will store only selected checkbox value in access_level table along with table id. Page link and page name details will be stored in page table.    Now if i want to edit , i should display all the pages which is there in page table and i should also mark checked to those which are already stored in access_level table.   I am using LEFT OUT JOIN, It displays all the pages. But it is not displaying the check mark to those which are already selected.   Here is my code

<?php $s1 = mysql_query("SELECT pages.page_id, pages.code, pages.page, pages.href, access_level.aid, access_level.page_id as pgid, access_level.department, access_level.position, access_level.active FROM pages LEFT OUTER JOIN access_level ON pages.page_id=access_level.page_id WHERE access_level.department=".$department." AND access_level.position=".$position." AND pages.code='sn'") or die(mysql_error());
				while($s2 = mysql_fetch_array($s1)) { ?>
				<tr><td><li><?php echo $s2['page']; ?>  </td><td><input type="checkbox" name="sn[]" value="<?php echo $s2['page_id']; ?>"  
                <?php if($row['pgid'] === $s2['page_id']) echo 'checked="checked"';?> />

here is my pages table     pages.JPG   26.55KB   0 downloads   access_level  access_level.JPG   19.09KB   0 downloads   In access_level table i do not have page ids 8 and 9. But i want to display that also from pages table and for 1 to 7 and 10 i should display check mark.    How i can achieve this? Please Help