db confusion
| From: | Jay Fitzgerald | Date: | Fri, 11 Apr 2003 17:57:33 +0000 |
| Subject: | db confusion | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27025@lists.php.net to get a copy of this message | ||
I currently have this in my php file:
<?
for($i = 0; $i <= 13; $i++):
$airday = strtotime("+$i day");
echo '<INPUT TYPE="checkbox" NAME="airdate" VALUE="'. date('Y-m-d',$airday) .'">'. date('l, F j',$airday).'<BR>';
endfor;
?>
which produces this output in a loop for the dates of the next 2 weeks:
<INPUT TYPE="checkbox" NAME="airdate" VALUE="2003-04-11">Friday, April 11<BR>
how should i design my db so that when the end user selects which dates an event happens, they get entered into the db in their appropriate day columns?
i am so confused
Jay Fitzgerald, Design Director - CPW-A, CPWDS-A, CPWDV-A, CECM-A, CWCSB-A
Bayou Internet - http://www.bayou.com
Toll Free: 888.30.BAYOU (22968)
Vox: 318.338.2034 / Fax: 318.338.2506
E-Mail: jayfitz@bayou.com
ICQ: 38823829 / AIM: bayoujf / MSN: bayoujf / Yahoo: bayoujf