[RESOLVED] Using checkmarks to 'archive' items in database

martymar69

I skimmed through the topics and didn't see anything that hit my needs.

I am having trouble where i need to make checkboxes that, when checked and submitted, assign a new value to keep the selected info from being displayed. Any questions let me know, i am not sure how to word this or how much info you need.

martymar69

Example:

mysql table includes fields for 'reference' 'region' 'comments' and a new one i created 'archive'

php is set to post the first 3 fields of the table, i want to make the 4th one exclude the results when checked and submitted.

acey99

martymar69 wrote:
Example:

mysql table includes fields for 'reference' 'region' 'comments' and a new one i created 'archive'

php is set to post the first 3 fields of the table, i want to make the 4th one exclude the results when checked and submitted.

if "archive" is set as Enum('y','n') or whatever..

SELECT * FROM mytable WHERE archive='n'

martymar69

Beautiful, i should have figured that part out hehe...never dealt with enum before.

that worked perfect.

do you know how to use checkboxes to change that value to a 'y'?

martymar69

eh, i will just stick to a drop down "yes" and "no" for now...

acey99

martymar69 wrote:
eh, i will just stick to a drop down "yes" and "no" for now...

$myvar= ($_POST['mycheckbox']=="y") ? "y" :"n";

update TABLE SET archive='$myvar' WHERE ....

martymar69

acey99 wrote:
um

$myvar= ($_POST['mycheckbox']=="y") ? "y" :"n";

update TABLE SET archive='$myvar' WHERE ....

ok. So i have on my complete page:

$archive = ($_POST['archive']=="y") ? "y" :"n";

mysql_query("UPDATE wenv SET archive= \"$archive\" WHERE 'ticketnumber' = \"$ticketnumber\" ") or die(mysql_error());

and my display table:

<?php
$wenv_result = mysql_query("SELECT * FROM wenv WHERE archive = 'n' ORDER BY 'ticketnumber'",$db) or die(mysql_error());

$myrow = mysql_fetch_array($wenv_result);

printf("<tr ALIGN=\"center\"><td> %s </td><td> %s </td><td> %s </td><td></td><td></td><td ALIGN=\"center\"><input type = \"checkbox\" name = \"archive\" value = \"%s\"></td></tr>\n", $myrow[1], $myrow[2], $myrow[3], $myrow[4]);

while ($myrow = mysql_fetch_row($wenv_result)) {

printf("<tr ALIGN=\"center\"><td> %s </td><td> %s </td><td> %s </td><td></td><td></td><td ALIGN=\"center\"><input type = \"checkbox\" name = \"archive\" value = \"%s\"></td></tr>\n", $myrow[1], $myrow[2], $myrow[3], $myrow[4]);

}
?>

Sorry to post all this crap, but does it look right? I can't seem to get it to change...