Make a table in db

**Adam** · 05-18-2008 04:59 PM

Hey guys,

Back again for more tech help!

I have a database set up on my server, and the guy who usually sorts everything like this out for me is away travelling. So I downloaded this script to put a ratings system on my website, but stumped at the first instruction:

Originally Posted by readme.txt

INSTALLATION:

================================================== ===========================
1. Make your table for the ratings in your db (you should be able to copy
and paste the following SQL)
================================================== ===========================
CREATE TABLE `ratings` (
`id` varchar(11) NOT NULL,
`total_votes` int(11) NOT NULL default 0,
`total_value` int(11) NOT NULL default 0,
`used_ips` longtext,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3;

How do I do this? I thought it might be as simple as uploading something to the server to create this?

Anyone know what I am talking about lol

Thanks again guys

**Ynot** · 05-18-2008 05:39 PM

what you've got there is called a database query
you need to execute it

Do you have phpMyAdmin on your website?

**Adam** · 05-18-2008 05:42 PM

No idea, how would I know that? I have a database, I know that much. Database name is djadamash

**ninja9578** · 05-19-2008 07:29 PM

The database has to be controlled by something, probably a program called oracle. You can take the script and put it into a file. Make the extension on the end be .sql, then SQL will run the entire thing at once. If your DBMS isn't some derivation of SQL then you'll have to convert the code into something else.

**Ynot** · 05-19-2008 07:50 PM

I highly doubt it's an Oracle DB
much more likely to be MySQL

Adam.
Ask your guy to show you how to access the database
(chances are it's accessed through a web-application called phpMyAdmin)
If you're going to be adding features to your site, you need to know how to change and update your database