NYCPHP Meetup

[Daniel Convissor]

On Tue, Jan 13, 2004 at 11:56:38PM -0500, Bill Wolf wrote:
>  
> The following code runs on my local machine but not on my host.  On the host
> I'm not sure what value to use for the $site variable.  Using the website or
> IP address isn't working.  

Check $php_errormsg when doing mysql_connect() has problems.

Also, chances are $site needs to be 'localhost' rather than the domain 
name.

Also, does the MySQL installation there have all the permissions lined up 
for the host, user, password, database combination.

All of this information should be given to you by your ISP -- or you can 
figure it out if you have access to the 'mysql' database which contains 
all of the priveleges information.

I'm guessing you need to read up on the privileges system:
http://www.mysql.com/doc/en/Privilege_system.html

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409