can someone write me a database with the following tables:
date, price, condition, year, silver, gold, weight
I think that's it. this will greatly help me as I don't know much mysql.
thanks,
Andrew
Use phpMyAdmin?? Very simple user interface to make one, just fill in a form.
(02-02-2010, 11:09 AM)MattR Wrote: [ -> ]Use phpMyAdmin?? Very simple user interface to make one, just fill in a form.
yes, I do use phpmyadmin. I'll give it a try.
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.
i use my php admin it helps out alot
I could help you, if still needed.
Pm me.