i can connect to mysql but not get data

mickfuzz

hi there --

i'm hoping one of you helpful members out there will be able to point me in the right direction.

i'm working an office server to test my site on.

i can't seem to get queries working alright?

apache is working ok, and is working with the debian set up fine - mysql works great from the command line

php works fine and by connecting to
http://10.0.0.20/beyondtv/
the site looks great

I can connect to the mysql database ok, i've got the following script for my queries -

$connection = mysql_connect("localhost", "mickfuzz", password")
or die ("couldn't connect to server");
$db = mysql_select_db("btv23org", $connection) or die ("couldn't select databass");
$sql= "select username, password from btv_userdetails where username = '$username'";
$result= mysql_query($sql,$connection) or die ("couldn't execute main query");

so i don't get a connection error or a an error electing the database, it's only the final instruction that gives an error.

i've had a look a the permissions and they are set at read for all -

the same errors are generated site wide, and i've checked a few of them by connected by the command line,

any ideas?

Norman_Graham

You need to post the actual error message, Mickfuzz. Remove your line:

or die ("couldn't execute main query")

and copy the error message that appears to this forum.

Norman

mickfuzz

thanks for that -
ok the message is

Warning: Supplied argument is not a valid MySQL result resource in /var/www/beyondtv/php3/input/pre/pre_login.inc on line 34

line 34 is: $row = mysql_fetch_array($result);

any idea why this would arrive?

mickfuzz

ok i decided to turn my brain on and read a bit more

when i turned on the mysql_error function i got this

query failed, error message = select command denied to user: 'mickfuzz@localhost' for table 'btv_userdetails'

but if i look at the files in the data area on the server they are set to be read for all three groups -

what should the permissions be? are there other permissions that i need to look at?

mickfuzz

ok i got it to work if i log in as root
i guess i just need to read more about granting myself different privaledges

cya
mick

cgraz

I'd suggest using mysql_error() with your queries. It would've let you know the problem instead of you trying to guess it.

$result = mysql_query($query) or die(mysql_error());

your or die statement just lets you know there was an error in your query, but you have no idea what it is.

Cgraz

matt_4013

I would suggest NOT using mysql_error() when your site comes out of development, unless you're writing it to a log or database, because it will give a malicious user information about your database structure. This isn't good, makes it easier for them to start playing with sql injections.

Norman_Graham

Originally posted by mickfuzz
Warning: Supplied argument is not a valid MySQL result resource in /var/www/beyondtv/php3/input/pre/pre_login.inc on line 34

line 34 is: $row = mysql_fetch_array($result);

any idea why this would arrive?

There seem to be a few problems flying around here. This particular problem simply indicates that your query found no matches or that the query was faulty - could just be a syntax error. Make sure your query matches up with the fields and data of your table - I've often tried to pick up data which I'd forgotten to insert in the first place or had called something else.

Norman

mickfuzz

hi there,

thanks for the pointers,

in the end mysql_error() was very helpful,

what i had done was grant myself privaledges on the whole database but not on the indivual tables.

so thanks