OK, this one should be pretty simple. I'm just now starting to write my own scripts, but beings I'm only a few days into learning PHP (and get stuck learning switch commands and further
), I'm going to start off with this script to help me learn. I'm trying to write a script so that I can put up a project sheet kind of like what Sicloan has at
http://www.missionsix.net only I want to make it dynamic and to be able to work with it through both PHP and MySQL.
First off, I'm going to make a database called cprophet_jd and insert my info with the following query, if it's incorrect, please help me:
Code:
CREATE TABLE project (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name TEXT,
disc TEXT,
datestart DATE NOT NULL,
datecomp DATE,
comp TEXT
);
One thing I want to know how to do with that query is make it so that "comp" can only be either a "y" or a "n"...haven't learned that far though =/
Well, I want my index.php to create a new row if it reads any new rows in the database (while still reading my CSS file so that the color's don't lose their status)
I also want an admin panel where it can allow me to insert querys such as:
Code:
INSERT INTO project SET
name = "New Skin",
disc = "New skin for CursedProphets",
datestart = "2004-11-11";
Again, I'm not sure if I did that right. I'm not sure if I would need to be able to run DELETE commands...so if I do need to add that in I could just do it myself if I can learn what I'm wanting to out of this.
Oh yeah, I also want to be able to insert completion date and if it's completed or not in the database...perhaps something where I can supply a link of the product?
Help?
