MySQL num_rows help

[darknuke]

i get this error:
Warning: Supplied argument is not a valid MySQL result resource in /usr/local/plesk/apache/vhosts/darknuke.com/httpdocs/test.php on line 15

from:

<?
$Array["Username"] = trim ($Array["Username"]);
$Array["Password"] = trim ($Array["Password"]);

correct mysql settings are here

$Link = mysql_connect ($hostname, $un, $pa);
$Query = "SELECT FROM $tablename WHERE Username='$Array[Username]' Password='$Array[Password]'";

if ($Array[Username] == "nate") {
$num_rows = mysql_num_rows($Query);
print "$num_rows";
if ($num_rows == "0") {
print "Your username was created";
} else {
print "Username already exists.";
}
} else {
print "error";
}
mysql_close ($Link);

[MrAlaska]

You are not selecting a database, then you are trying to get database results from a string!

You need to actually MAKE the query. There is a good example about halfway down the page of how to access MySql.

http://www.php.net/manual/en/ref.mysql.php

And your query string is not selecting anything either. I would suggest starting from the beginning and learn the basics.

[darknuke]

thanks...