what am i doing wrong??

aevans4e

$db = mysql_connect("host","username","pass");
if(!$db) { echo "Error: Could not connect"; }

mysql_select_db("database", $db);

$query = "select * from database";

$result = mysql_query($query);

$numrows = mysql_num_rows($result);

while ( $row = mysql_fetch_array($result)) {

    echo "<p>Name: " . $row[uName] . "!";

}
?>

that is what im trying to do i just want to be able to grab info from the database... not integrate it all just a simple name from there would be ok but i keep getting errors on my page

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

it doesnt like mysql_fetch_array or mysql_num_rows

can anyone help? plzz

thanks
ae

nnichols

Try this. It should give you useful errors to explain why the script fails -

<? 

$db = mysql_connect('host','username','pass')
	or die('Failed to connect to db server.<br>MySQL error: '.mysql_error());

mysql_select_db('database', $db)
	or die('Failed to select db.<br>MySQL error: '.mysql_error());

$query = "select * from database";

$result = mysql_query($query)
	or die('Query failed.<br>Query: '.$query.'<br>MySQL error: '.mysql_error());

$numrows = mysql_num_rows($result); 

while ( $row = mysql_fetch_array($result)) { 

echo '<p>Name: ' . $row['uName'] . "!\n";
} 
?>

Hope this helps 😉

aevans4e

omg dude ty
that told me where my error was.. and i found a way to get around it but i need help figuring it out so i dont have to use webmin to add mysql users

it was not adding permissions the the user i did
grant all on database to username identified by 'testpass';

when i did that it said in webmins mysql users that that user had no permissions

how can i grant all/ partial ... select, update, delete, etc... certain ones to a user from the mysql> command line

my php/sql book explained that a little and id read it now but its not at home right now...

plzie so close to making all this work!
woot

thx
ae

aevans4e

oh one more thing... when adding user permissions what do i need to put on there to specify the host that that user has permissions to use?

nnichols

to grant all use -

GRANT ALL ON . TO user@localhost IDENTIFIED BY 'password'

this sets up all privs on all tables in all dbs to user 'user'.

To grant specific privs use -

GRANT SELECT,INSERT,UPDATE,DELETE ON test.* TO user@localhost IDENTIFIED BY 'password'

this sets up the specified privs on all tables in db 'test' for 'user'

You should set up all your users with 'localhost' for the Host field in an ideal world, but you may need to have remote access for admin reasons - though you should be able to telent in for admin stuff.

aevans4e

ty so much dude youve helped so much

ty🙂

aevans4e

still one more thing...
the grant statements work for all databases
but when i just do grant all on database to username identified by 'pass'
it tells me that it cannot connect

it just makes a db permission in webmin... the user has no real rights on the db ... it wont work anyway

is there a way to just give that user access to the one db but it work when u connect to db w/ that user name?

hmm im not sure let me try a few things

aevans4e

lol sry to keep posting... keep forgetting this isnt a chat

but i figured it out.. it has to have that .* on the end of db for some reason for it to work like that

thanks

nnichols

The ".*" means all tables in that db. So you can use "test.user" which would only grant the privs on the "user" table in the "test" db.