Newb Question: Submission Tables
Posted: Tue Jun 03, 2008 11:46 pm
Hi, I am very new to MySQL, but I do have a good understanding about PHP. I have a submission form, and I want the data transfered onto a SQL database, so that I could manage later on. What I ask for is the following:
a URL (http://...)
a short description (blah blah blah)
a long description (blah blah blah blah)
some keywords (blah;blah;blah;blah), however I plan on scripting it so that I could store it into an array. How do I use these with MySQL?
a picture (either URL or uploaded)
Those are what I get from the form. However I also want other things, like:
the date submitted
a rating
an ID
a number of hits
How will I create a table for these things? I am especially interested about how to put arrays into tables (with the keywords).
Thank you, and any help will be appreciated.
a URL (http://...)
a short description (blah blah blah)
a long description (blah blah blah blah)
some keywords (blah;blah;blah;blah), however I plan on scripting it so that I could store it into an array. How do I use these with MySQL?
a picture (either URL or uploaded)
Those are what I get from the form. However I also want other things, like:
the date submitted
a rating
an ID
a number of hits
How will I create a table for these things? I am especially interested about how to put arrays into tables (with the keywords).
Thank you, and any help will be appreciated.