Checkbox Query

obrienkev

Hi all,

I have a list of files with relevant checkboxes(created by php while loop). How do I ensure that each checkbox is given a unique value?

<input type="checkbox" name="archive[]" id="archive[]" value="" />

thanks,

Kevin.

devinemke

give the file's name as the value, all of the filenames are unique (if they are in the same directory).

obrienkev

So like this...

echo '<input type="checkbox" name="archive[]" value=".$row['file_id']." />';

Cheers.

I want to send a file into its relevant database table - based on whatever checkbox is selected.

So if all 4 checkboxes are selected, 4 different files are inserted into 4 different tables.
e.g. If checkbox 'A' is selected, file 'A' will be inserted into table 'A'

Here is my query...

$query = "INSERT INTO tableA(name, type, size, content, file_date) SELECT name, type, size, content, file_date FROM files WHERE CURDATE() >= DATE_ADD(file_date, INTERVAL 1 DAY)";
$result = mysql_query($query) or die(mysql_error());

Is there any easier way to process each file into its relevant table without repeating the query for each table?

thanks,

Kevin.

obrienkev

Anyone please?

Weedpacket

There are things called "loops".... but if you're doing the same thing to several tables, then it's a sign that maybe you should have one table (with another field to distinguish whatever it is you're distinguishing by having multiple tables).

And please don't bump your threads with meaningless posts like

obrienkev wrote:
Anyone please?

It's considered selfish.