Problem with poll script

DenTer

I use tris script for poll

http://www.rodjeni-mostar.com/download/mysql_poll.zip

I use correct database name, correct username, correct password and 'localhost' for host becouse file is on my server.

When i try to insert poll question with admin.php i get this error

Warning: mysql_query(): Access denied for user 'rodjenim'@'localhost' (using password: NO) in /home/rodjenim/public_html/poll2/admin.php on line 17

Warning: mysql_query(): A link to the server could not be established in /home/rodjenim/public_html/poll2/admin.php on line 17

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/rodjenim/public_html/poll2/admin.php on line 42

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/rodjenim/public_html/poll2/admin.php on line 43

I have similar problem with chat script that uses mysql on my new server. But it worked on my old server.

Can you help me.

bodzan

Seems like a stupid question but the second error indicates that the connection to server is failed and I figure lets start with the simplest solution...

acey99

are the permissions set in mysql for the user ?

is the user in the user table?

db: mysql, table: user

privileges are there too.

drew010

well, the guy that made the script either left something out or doesnt have much experience with php and mysql.
he collects the proper info in the config.inc.php but none of those php scripts ever call mysql_connect.
since thats never called, mysql_query will not work.

you could edit config.inc.php after after the variable declarations put

mysql_connect($host, $db_user, $db_pass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());

since the config is incuded by all the files that need it, the db connection will be made every time.

DenTer

drew010 wrote:
well, the guy that made the script either left something out or doesnt have much experience with php and mysql.
he collects the proper info in the config.inc.php but none of those php scripts ever call mysql_connect.
since thats never called, mysql_query will not work.

you could edit config.inc.php after after the variable declarations put
mysql_connect($host, $db_user, $db_pass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());
since the config is incuded by all the files that need it, the db connection will be made every time.

when i insert that code you give me i have this messege. This time just 2 errors.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/rodjenim/public_html/poll2/admin.php on line 42

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/rodjenim/public_html/poll2/admin.php on line 43

drew010

ah i see, he used a resource variable in the function.
change that stuff i gave you before to this:

$conn = mysql_connect($host, $db_user, $db_pass) or die(mysql_error());
mysql_select_db($db, $conn) or die(mysql_error());

DenTer

now i have no errors. Admin panel works well. I insert the question i answers for poll and this works well.

But when i start the poll i have only question. But no answers to click on. Just one empty klick box.