[Resolved] Search using form to give result

cody44

I am trying to set up a form that will show catagories from the database. These catagories have a checkbox next to them with the number of sub_catagories. All information here has been brought into the form from the database. This part seems to work okay. The problem being is trying to send the information 'ticked' in the checkbox from the results_1.php into the 'results_1.php page.
Have been working on this for days and seem to be getting nowhere !!!!!!!!!!
Can anyone help me out with this code. below is the first part which works okay.

 <?php require_once('Connections/Connection_1.php'); ?>
<?php
mysql_select_db($database_Connection_1, $Connection_1);
$query_rsCount = "SELECT catagory, count(*) as count FROM papers GROUP BY catagory ORDER BY catagory ASC";
$rsCount = mysql_query($query_rsCount, $Connection_1) or die(mysql_error());
$row_rsCount = mysql_fetch_assoc($rsCount);
$totalRows_rsCount = mysql_num_rows($rsCount);
?>

This is where I think ive got major problems.

  <form action="results_1.php" method="get" name="search" id="search">
  <table width="620" border="0" align="center">
    <tr>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><div align="center">
        <?php do { ?>
          <input <?php if (!(strcmp($row_rsCount['catagory'],"catagory"))) {echo "checked";} ?> type="checkbox" name="checkbox" value="catagory">          

          <span class="style1"><?php echo $row_rsCount['catagory']; ?></span> (<span class="style1"><?php echo $row_rsCount['count']; ?></span>)
          <?php } while ($row_rsCount = mysql_fetch_assoc($rsCount)); ?> 
      </div></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><input type="submit" name="Submit" value="Submit"></td>
    </tr>
  </table>
  <div align="center"></div>
</form>
</body>
</html>
<?php
mysql_free_result($rsCount);
?>

Anyone who can help me out id be happy to make a donation to you via paypal if you have one or another method !!

Many thanks in advance

Mark

mrculinary

First off I think you want to POST instead of GET as you are posting the results from your first page to your details page?, correct or not?

Second, when you filter your results in Dreamweaver make sure you are filtering based on your form variables of the check feild from the first form page, ie. if your check box is called papers_resume_id make sure when you pass your variables to the results page or POST them :-) make sure your results page is filtering based on the papaer_resume_id variable being sent over.

ezample, I am sending the results page my sub category of papers
papers_resume_id in a check box called papers_resume_id

you must filter the results of that check box based on the id of the check box.

Hope this helps.

cody44

Thanks mrculinary,

Working on it and will have a go.

id10t

Don't have my notes in front of me atm, but some form elements will come thru with a null value, others will not come thru at all in the post if they have no value in the form.

Also, you may want to use a session and set teh form action to the php-self, and use the session to see if they've properly completed the form or not, and if it is all correct then process it, etc.

Edit - check boxes with the same name and different value will not come thru as an array, but you can reference them as name="foo[]" and then they will become an array in the post vars.

mrculinary

HOw is it coming