[Resolved] invalid argument

[fuzic]

I have the following script, which used to work for me, but recently I switched servers, and on the new server every time this script is called, I get the error:

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

The code is as follows;

$db = mysql_connect(localhost, "username", "password");
mysql_select_db(markar_nu-users,$db);
$query = 'SELECT * FROM users';
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$numrows = $row['count'];
mysql_close();

Any suggestions?

[Krait]

Um, you need to quote the first parameter to mysql_select_db().

[superwormy]

You also need to quote "localhost", as it's a string as well.

Also, always do queries as:

mysql_query (" YOUR QUERY HERE ") or die (mysql_error());

So that you can see if your MySQL query dies.