I’m able to retrieve records but not add or delete
When I add for a second it show the row but disappears.
When I change the submit to delete it crosses out the selected record, but then oddly reappears like nothing happened.
What am I missing?
(I did some minor editing of my example below so I could publish it, but it’s basically copy and past from the browser and I am seeing a row of data)
TIA
-D
source
Add Delete Selected Rowtable (tried with reminder_id as autoincrement too)
CREATE TABLE reminders
(
reminder_id
int(11) NOT NULL,
date_due
date DEFAULT NULL,
user_id
int(11) DEFAULT NULL,
date_set
date DEFAULT NULL,
priority
char(1) DEFAULT NULL,
reminder_title
varchar(45) DEFAULT NULL,
division
varchar(2) DEFAULT NULL,
canceled
int(1) DEFAULT NULL,
ical_flag
int(1) DEFAULT NULL,
email_flag
int(1) DEFAULT NULL,
notes
varchar(245) DEFAULT NULL,
PRIMARY KEY (reminder_id
)
)
mysql> select * from reminders\G
*************************** 1. row ***************************
reminder_id: 2
date_due: 2012-01-01
user_id: NULL
date_set: 0000-00-00
priority: 1
reminder_title: new title
division:
canceled: 0
ical_flag: 0
email_flag: 0
notes: NULL
1 row in set (0.00 sec)