04-20-2010, 10:17 AM
Hey there,
If you still did not add a database and still looking for a way to do so, then login to your PHPMyAdmin and switch to the SQL tab. Run this query:
CREATE DATABASE `DbNameHere` ;
That will create a database, make sure you change the name to anything you'd like. Then run this query to create the tables:
CREATE TABLE `DbNameHere`.`DbTableNameHere` (
`date` VARCHAR(20) NOT NULL ,
`price` VARCHAR(20) NOT NULL ,
`condition` VARCHAR(20) NOT NULL ,
`year` VARCHAR(20) NOT NULL ,
`silver` VARCHAR(20) NOT NULL ,
`gold` VARCHAR(20) NOT NULL ,
`weight` VARCHAR(20) NOT NULL
)
There you go, I set them as VARCHAR (aka a text field) and set the maximum length for them as 20. You can edit the number, of course.
Good luck.
If you still did not add a database and still looking for a way to do so, then login to your PHPMyAdmin and switch to the SQL tab. Run this query:
CREATE DATABASE `DbNameHere` ;
That will create a database, make sure you change the name to anything you'd like. Then run this query to create the tables:
CREATE TABLE `DbNameHere`.`DbTableNameHere` (
`date` VARCHAR(20) NOT NULL ,
`price` VARCHAR(20) NOT NULL ,
`condition` VARCHAR(20) NOT NULL ,
`year` VARCHAR(20) NOT NULL ,
`silver` VARCHAR(20) NOT NULL ,
`gold` VARCHAR(20) NOT NULL ,
`weight` VARCHAR(20) NOT NULL
)
There you go, I set them as VARCHAR (aka a text field) and set the maximum length for them as 20. You can edit the number, of course.
Good luck.