[SOLVED] PHP Newbie needing a little help...

[psyqosis]

Hi. I think I'm missing something simple... any ideas?

 

I keep getting the error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in... on line 39

 

Here's the code in question (line 39 is the IF statement)

<?php

$database= "edited";

$db = mysql_connect(localhost, "edited", "edited");

mysql_select_db("$database", $db);

 

$sql = "SELECT * FROM events;";

$result = mysql_query($sql, $db);

if (mysql_num_rows($result) > 0) {

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

?>

<TR><TD><?php echo $myrow['title']; ?></TD></TR>

<TR><TD><?php echo $myrow['date']; ?></TD></TR>

<TR><TD><?php echo $myrow['desc']; ?></TD></TR>

<?php

}

}

?>

[teng84]

do this

$result = mysql_query($sql, $db) or die (mysql_error());

 

you have invalid query add a mysql_error() to see your error

[psyqosis]

Ok, did that and it says "no database selected." I'm confused though... didn't I already do that in the above code?

[teng84]

LOLOLOLOL

do this

$db = mysql_connect(localhost, "edited", "edited") or die(mysql_error());

mysql_select_db("$database", $db) or die(mysql_error());

 

$sql = "SELECT * FROM events;";

$result = mysql_query($sql, $db)or die(mysql_error());

 

 

we have to check if you are really connecting

[psyqosis]

Ok thanks, now we're getting somewhere!

 

That returns... Access denied for user: 'edit' to database 'edit'

 

However, I'm using the same UN and PW in the mysql_connect function that lets me sign in to my IP control panel and in to MySQL.

[teng84]

are you sure you have that db name ?

[psyqosis]

yes, I've triple-checked the spelling & everything. I can log into my control panel, and click on that DB name and see my tables. This doesn't make any sense to me...!

[psyqosis]

Thanks a million for all your help. Apparently I'm dislexic.

[teng84]

Thanks a million for all your help. Apparently I'm dislexic.

??? ??? ???

[psyqosis]

i had a typo in my DB name. Didn't know about those die statements--they're helpful. thanks again!