PHP/SQL Help Please

[Raistlin]

Ok, the username and password are correct.....

What error message are you getting now?

I only ask that because I've made a change, it's still not working, and I'm not getting any error messages - I wasn't even getting the one that you were getting

[iron25]

Can't use database : Access denied for user 'catswor_catswort'@'localhost' to database 'catswor_maps'

[Raistlin]

Ok, I've deleted that user and added a new one, then changed the user name and password in the PHP so that they match the new account created.

Still not working and still getting no error messages.....

Is there any chance that there's something not set up quite right somewhere that I don't have access to on the site?

[iron25]

In mysql you will need to give users rights to access certain databases and tables. You can assign the select/update/delete rights for each user for a database & table. I don't know how it works with your provider as I do it from either a linux prompt or webmin.

[Raistlin]

Ok, I think I'm getting somewehere.

Hadn't realised that you have to explicitly grant the user access to each database.....

Done that now and I-Web's admin panel actually supplies the connection strings.

The PHP now appears to be connecting to the database ok but I still get a blank page.

I am now seeing an error message in the source for the page though:

<b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/home/catswor/public_html/maps/example.php</b> on line <b>34

[iron25]

I would suggest that there is a problem with your query section of the code. From the paste of the code you have:

$result = mysql_query("SELECT * FROM 'memberlocations'",$link);

If the memberlocations table exists then you do not need to put quotes around it:

$result = mysql_query("SELECT * FROM memberlocations",$link);

[Raistlin]

It's Working

Thanks for all the help guys, really appreciate it

It'll 404 at the moment though because I'm fiddling, give me a moment and I'll show you the result
__________________

Ok, it's working now.....

Click the balloon

It's the start of a little project that I've been wanting to have a go at for a while

Thanks again for all the help

[iron25]

Originally Posted by Raistlin

Click the balloon

Aaah, ain't that special

[Richard M]

Originally Posted by Paul M

The format of mysql_connect() is this ;

PHP Code:

mysql_connect('server', 'user', 'password') 


You then use the mysql_select_db() statement to connect to your database.

Sorry, just to be annoying here.
The mysql_select_db() function actually does a "use <database>" command.
The mysql_connect() function does establish the connection in the first place.

You can probably test this by using this code:

PHP Code:

<?php
if(!mysql_connect('server', 'username', 'password') {
echo 'I can\'t connect!';
exit;
}
else {
echo 'Connected OK!';
}
?>