Now, I need to create a PHP script that will easily add, edit, and delete tables to the MySQL database.
I've created the main table in the MySQL database, like so:
CREATE TABLE wholocations ( id int(11) NOT NULL auto_increment, lat decimal(10,6) NOT NULL default '0.000000', lon decimal(10,6) NOT NULL default '0.000000', description varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM;
Now for adding, editing, deleting that stuff......i'm a little lost.
What i'd like to do is create one page. When the page loads, it shows a list of every entry i've put in. Next to each entry, a check box or radio button for "edit entry" and "delete entry"
At the bottom of the page, a place to put in new information to add to the table.
Hope this makes sence, and I would appreciate the help!