Cable Forum - PHP/SQL Help Please

Page 2 of 2

Show 100 post(s) from this thread on one page

Cable Forum (https://www.cableforum.uk/board/index.php)

- Internet Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=25)

- - PHP/SQL Help Please (https://www.cableforum.uk/board/showthread.php?t=32772)

Raistlin

31-07-2005 00:25

Re: PHP/SQL Help Please

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

31-07-2005 00:29

Re: PHP/SQL Help Please

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

Raistlin

31-07-2005 00:32

Re: PHP/SQL Help Please

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

31-07-2005 00:35

Re: PHP/SQL Help Please

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

31-07-2005 00:41

Re: PHP/SQL Help Please

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:

Quote:

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

iron25

31-07-2005 00:43

Re: PHP/SQL Help Please

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

31-07-2005 01:06

Re: PHP/SQL Help Please

:woot:

It's Working :D

Thanks for all the help guys, really appreciate it :tu:

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 :tu:

iron25

31-07-2005 01:54

Re: PHP/SQL Help Please

Quote:

Originally Posted by Raistlin

Click the balloon ;)

Aaah, ain't that special :)

Richard M

01-08-2005 00:18

Re: PHP/SQL Help Please

Quote:

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. :D
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!';

}

?>

All times are GMT. The time now is 14:45.

Page 2 of 2

Show 100 post(s) from this thread on one page