PHP error

Anon

I'm having difficulty running the following 2 blocks of code on my server.

<?php
$sql = "SELECT * FROM newsItems";
mysql_connect();
$rs = mysql_db_query("a00yvrak",$sql);
?>

<?php
while ($row = mysql_fetch_object($rs))
{
$id = $row->id;
$title = $row->title;
printf("<a href=\"displayarticle.php?id=%s\">%s</a><br>",$id,$title);
}
?>

I get the following error "Warning: Supplied argument is not a valid MySQL result resource in /xxxxx/xxxxx/listnews.php on line 14" which is the start of my while loop. All database names are correct. Does anyone have an idea what I am missing? I know it is hard to say anything with limited info, but if I can get a push in the right direction it would be appreciated. The server is running PHP4 and MySQL 3.23.21-beta.

Thanks,
Chris

Anon

<?php
$dbhost = "";
$dbuser = "";
$dbpass = "";
$dbname = "";
$db = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname,$db);
$sql = "SELECT * FROM newsItems";
$rs = mysql_query($db,$sql);
?>

<?php
while ($row = mysql_fetch_object($rs))
{
$id = $row->id;
$title = $row->title;
printf("<a href=\"displayarticle.php?id=%s\">%s</a><br>",$id,$title);
}
?>

Anon

Are those pieces of code from the same script or from seperate scripts?

Anon

The pieces of code are indeed from the same script. Thanks to Louie, I figured out the problem. I was using mysql_connect() with no arguments. The defaults were not working. Once I obtained the appropriate values it worked correctly.

Thanks for the help guys, obviously I'm a newbie here. I have no experience working with dbase's but do have some experience with various scripting languages.

Thanks again,

Chris