If you go to my website you see a db failure. www.winprizesonline.info Can someone can explain to me where the failure is and what am i doing wrong Thanks
Hi! You should also know how the mysql_pconnect() function works in order to understand what fault might have occured: The mysql_pconnect() function opens a persistent MySQL connection. This function returns the connection on success, or FALSE and an error on failure. You can hide the error output by adding an '@' in front of the function name. mysql_pconnect() is much like mysql_connect(), but with two major differences: This function will try to find a connection that's already open, with the same host, username and password. If one is found, this will be returned instead of opening a new connection The connection will not be closed when the execution of the script ends (mysql_close() will not close connection opened by mysql_pconnect()). It will stay open for future use... Do you know if you already have an open connection to the db? Are you sure you have configured the db connection setting properly? Perhaps you should post the code on the site or tell us more about the circumstances...
Thanks for your listings, maybe i have set up the the .config the wrong way. it must be a simple script but it keeps bugging me with failure, i have set up another db but still no results. Can someone help me with setting this up for me? we can discuss rewards. Let me know.
If you haven't noticed godaddy doesn't use localhost, after you create a db wait a while and go back to your db listings click the edit icon and that will reveal your connection settings
yes thanks for that, but the problem is not solved haha but the error is changed now, a new massages is popping up. Error in Selection Query select winner_url from tbl_adminsettings No database selected anybody can help me with this, is this a error in the file i imported into my database?
Please show us your config file but remove your password and also when you say you imported a file, this was a .sql file correct ? and when you visit your database page, the phpmyadmin page can you see a table called adminsettings ?
<?php /*$config["SiteClassPath"]=$_SERVER['DOCUMENT_ROOT']."/lottery/includes/classes/"; $config["SiteTemplatesPath"]= "templates/"; $config["DBHostName"] = 'svenwarmerdam.db.6070456.hostedresource.com'; $config["DBUserName"] = 'server'; $config["DBPassword"] = 'password'; $config["DBName"] = 'svenwarmerdam'; $config["sitepath"]='/lottery/'; */ $config["SiteClassPath"]=$_SERVER['DOCUMENT_ROOT']."/includes/classes/"; $config["SiteTemplatesPath"]= "templates/"; $config["DBHostName"] = 'svenwarmerdam.db.6070456.hostedresource.com'; $config["DBUserName"] = 'server'; $config["DBPassword"] = 'password'; $config["DBName"] = 'svenwarmerdam'; ?> Yes i have imported the .sql file and in my datase page there is a file called adminsettings. So any idea's i m working on it so let see if the changes i made could have some effect.
I have switched db usersname and dbname and nowthe error is this Error in Selection Query select winner_url from tbl_adminsettings No database selected if i switch back then another error occured. one question, if i look in the phpadmin i see two files, one was already there, i do not know if it has any help deleted this.
Just try reinstalling the Script! Make sure that the the table you're requesting is available in your db or not