On Mar 17, 8:51 pm, JerrySchrader <[email protected]> wrote: > > Second of all, this is a link to where I am so > far:http://massage-healthcare.com/phpsqlsearch_genxml.php (useless so > far, shows the error only)
But the error message is the only clue there is to what's going wrong. Errors are not useless. In this case, the error shows thar mysql_connect cannot use your database: mysql_connect() [function.mysql-connect]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/massage/public_html/ phpsqlsearch_genxml.php on line 14 So line 14 of that file must be wrong. There appears to be a connection attempt there, which ignores what you are doing in the connection file: > Third of all, this is my sql connection file: (connections/mysql.php) > <?php > # FileName="" > # Type="MYSQL" > # HTTP="true" > $hostname_mysql = "localhost"; > $database_mysql = "massage_directory"; > $username_mysql = "massage_jerry"; > $password_mysql = "agod1man"; > $mysql = mysql_pconnect($hostname_mysql, $username_mysql, > $password_mysql) or trigger_error(mysql_error(),E_USER_ERROR); > ?> I would suggest getting rid of the block which fails (lines 13 to 17 inclusive in your image) and changing the mysql_pconnect line above to $connection=mysql_connect(...) keeping the content of the brackets the same. That will allow you to connect to the database and use something called $connection as you want to do at the moment. Using pconnect creates persistent connections and requires fairly robust programming to ensure correct disconnection, and mysql_connect is usually fine. Note that although you're following an example which includes a php script, this part of the exercise isn't an API problem: it's an issue with the php code and you might get better help from a php programming group. API errors are the province of this group, of course! Andrew --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
