Checkbox

arstanj · #1 (**permalink**) 09-20-05, 01:15 AM

Hi,
I have this code:

Code:

<form name="form1" method="post" action="">
  <table width="730" border="0" align="center" cellpadding="4" cellspacing="1">
    <tr> 
      <td bgcolor="#999999"><strong>Profitera Credit &amp; Collections Management</strong></td>
    </tr>
    <?
 $sql="select * from files where cat_id = 1";
 $result = mysql_query($sql);
 if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}
if (mysql_num_rows($result) == 0) {
    echo "No category found!";
    exit;
}

while ($row = mysql_fetch_assoc($result)) { 
 ?>
    <tr> 
      <td bgcolor="#CCCCCC"> <input name="<? echo $row["file_id"];?>" type="checkbox" id="a" value="checkbox"> 
        <?
	echo $row["file_title"];
	echo "<br>". $row["description"];
	?>
        <input name="file<? echo $row["file_id"];?>" type="hidden" value="<? echo $row["file_id"];?>"> 
      </td>
    </tr>
    <?
}

mysql_free_result($result);
?>
  </table>
</form>

Database structure:

CREATE TABLE `file_cat` (
`category_id` int(12) NOT NULL auto_increment,
`cat_name` varchar(120) NOT NULL default '',
PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

CREATE TABLE `files` (
`file_id` int(12) NOT NULL auto_increment,
`cat_id` int(12) NOT NULL default '0',
`file_pwd` varchar(120) NOT NULL default '',
`file_title` varchar(120) NOT NULL default '',
`description` varchar(200) NOT NULL default '',
PRIMARY KEY (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

Basically, my idea is to make a download tracker, where a user should provide me a valid email address to which the script will send an URL of the file. That URL should expire within 10 days after it is sent.

Now, my problem is I can display those files, but when I try to get to the "provide an email" page I get stuck. How do I get the values of those checkboxes and say "Hey man, you wanted to download this files"?

regards,
Arstan