is there another way other than this as i can't seem to get it to work.
// log in to database
if (!$db_conn = @mysql_connect('localhost', 'poll', 'poll'))
{
echo 'Could not connect to db<br />';
exit;
};
@mysql_select_db('poll');
below is the table im trying to create in phpmyadmin with difficulty.
create database poll;
use poll;
create table poll_results (
candidate varchar(30),
num_votes int
);
insert into poll_results values
('John Smith', 0),
('Mary Jones', 0),
('Fred Bloggs', 0)
;
grant all privileges
on poll.*
to poll@localhost
identified by 'poll';
can someone explain how i get the insert statement into phpmyadmin?