BPpXryfC

1<table cellpadding="3" width="100%">
2    <tbody>
3        <tr>
4            <td>Email <span class="required">*</span></td>
5            <td><input type="text" class="text_input" name="email" value=""></td>
6        </tr>
7        <tr>
8            <td>First Name <span class="required">*</span></td>
9            <td><input type="text" class="text_input" name="first_name" value=""></td>
10        </tr>
11        <tr>
12            <td>Last Name</td>
13            <td><input type="text" class="text_input" name="last_name" value=""></td>
14        </tr>
15                    <tr>
16            <td>
17            Subscribed Communication
18            </td>
19            <td>
20                <table>
21                                                <tr>
22                            <td><input type="checkbox" name="group_id[]" value="2" checked></td>
23                            <td>RaceO'Clock Members</td>
24                        </tr>
25                                                                </table>
26            </td>
27        </tr>
28        <tr>
29            <td colspan="2" align="center">
30                <input type="submit" name="submit" value="Subscribe!"> <br/>
31                <em>* required fields</em>
32            </td>
33        </tr>
34    </tbody>
35    </table>
36
37
38    </form> 
39     
40CREATE TABLE IF NOT EXISTS `member` (
41  `member_id` int(11) NOT NULL auto_increment,
42  `first_name` varchar(255) NOT NULL,
43  `last_name` varchar(255) NOT NULL,
44  `email` varchar(255) NOT NULL,
45  `join_date` date NOT NULL,
46  `ip_address` varchar(15) NOT NULL,
47  `unsubscribe_date` date NOT NULL,
48  `unsubscribe_send_id` int(11) NOT NULL,
49  PRIMARY KEY  (`member_id`)
50)  DEFAULT CHARSET=utf8; 
51     
52CREATE TABLE IF NOT EXISTS `member` (
53     `member_id` int(11) NOT NULL auto_increment,
54     `first_name` varchar(255) ,
55     `last_name` varchar(255) ,
56     `email` varchar(255) ,
57      `join_date` date ,
58      `ip_address` varchar(15),
59      `unsubscribe_date` date ,
60      `unsubscribe_send_id` int(11) ,
61     PRIMARY KEY  (`member_id`)
62    )  DEFAULT CHARSET=utf8; 
63     
64INSERT INTO member SET join_date = NOW() , 
65                      first_name = 'John', 
66                       last_name = 'D',
67                           email = 'jd@aol.com' ,
68                      ip_address = '' ,
69                unsubscribe_date = '',
70             unsubscribe_send_id = ''