Simple news script

[Pino]

$host="localhost";
$user="me";
$password="you";
$database="hello";


$connection = mysql_connect($host,$user,$password)or die ("Error Conecting To DB");
$db = mysql_selectdb($database,$connection) or die ("bad table\db data");

$query = "SELECT * FROM tblnews";
$result = mysql_query($query);

$nrows = mysql_num_rows($result);

for ($i=0;$i<$nrows;$i++)
{
$row = mysql_fetch_array($result);
echo $row;
}


?>

and the error i am getting is

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in path/index.php on line 15

Any ideas on how to fix this?

also if i just wanted to select 3 coloums from the db how would i put my query


$query = "SELECT one two three FROM tblnews"; would that be right?

[Pino]

And i get the same error for this code


$connection = mysql_connect($dbhost, $dbusername, $dbpassword);

$query = "SELECT MAX(id) FROM tblnews";
$result = mysql_db_query($database, $query);
$count = mysql_fetch_array($result,MYSQL_ASSOC);

echo $count

[Pino]

Arghhhhhhh

It was because it should be tblNews and not tblnews thats took me all day that has lol :-/

[The Hobo]

Remember:

or die(mysql_error())

Is your friend. Putting that after mysql_ functions will help get you more specific errors. Such as, putting it after mysql_query() would've told you straight up that the table didn't exist.

Just a heads up.