Page 1 of 1

need help about php poll script

Posted: Tue May 30, 2006 3:38 am
by jehzlau
hi, im a newbie in this php stuff, i would like to know how to

I want to install a SimPoll poll from http://www.sim-php.info to my own webserver, one of the instructions is:

Execute these queries on your database:
<?php
# Table structure for table `poll_check`

CREATE TABLE `poll_check` (
`pollid` int(11) NOT NULL default '0',
`ip` varchar(20) NOT NULL default '',
`time` varchar(14) NOT NULL default ''
) TYPE=MyISAM COMMENT='';

# -----------------------------------------

# Table structure for table `poll_data`

CREATE TABLE `poll_data` (
`pollid` int(11) NOT NULL default '0',
`polltext` varchar(50) NOT NULL default '',
`votecount` int(11) NOT NULL default '0',
`voteid` int(11) NOT NULL default '0',
`status` varchar(6) default NULL
) TYPE=MyISAM COMMENT='';

# -----------------------------------------

# Table structure for table `poll_desc`

CREATE TABLE `poll_desc` (
`pollid` int(11) NOT NULL default '0',
`polltitle` varchar(100) NOT NULL default '',
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`votecount` mediumint(9) NOT NULL default '0',
`STATUS` varchar(6) default NULL,
PRIMARY KEY (`pollid`)
) TYPE=MyISAM COMMENT='';

# -----------------------------------------
?>

The problem is, i dont know how to execute this code/queries onto my database.. huhuhu, nid help badly, i really dont know T__T

Posted: Tue May 30, 2006 4:11 am
by twigletmac
Do you have access to something like phpMyAdmin?

Mac

yep

Posted: Tue May 30, 2006 5:40 am
by jehzlau
yep, i do have an access to that so called phpMyAdmin, coz its my own webserver... =), but i dont know how to execute the mentioned queries T___T,, im a newbie in this mysql+php thing...=(

Posted: Tue May 30, 2006 7:15 am
by GM
One way to do it is to open your mySQL console (I assume you are using mySQL), and copy/paste the queries into it.

hmm

Posted: Tue May 30, 2006 6:20 pm
by jehzlau
what is that mysql console thing? is it a folder named mysql_console.php? or .txt? i cant find it T____T :cry:

Re: hmm

Posted: Tue May 30, 2006 10:18 pm
by hawleyjr
jehzlau wrote:what is that mysql console thing? is it a folder named mysql_console.php? or .txt? i cant find it T____T :cry:
Your phpMyAdmin