What am I doing wrong?

TalonFinsky

Trying to set up a script to add "admins" to a database, but the part where it checks if the username is already taken appears to be fubar. Any help?

  $query = "SELECT * FROM admins WHERE username = ".$_POST['username'];
  $result = mysql_query($query);
  $matches = mysql_num_fields($result);

  if ($matches >= 1 )   

  {
    echo "<h1>Error</h1><br>\n";
    echo "<h3>Username is already taken.  Go back and try again.</h3>\n";
    include("foot.php");
    exit;
  }

The error I am receiving:

"Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /usr/local/www/test.thehellofit.com/public_html/infinitegames/admin.php on line 39"

(line 39 is: " $matches = mysql_num_fields($result);")

Anyone got any ideas?

cgraz

That error always almost always means that there is something wrong with your query. Try changing it to this:

$query = "SELECT * FROM admins WHERE username = '". $_POST['username'] . "'";

Cgraz

TalonFinsky

Originally posted by cgraz
That error always almost always means that there is something wrong with your query. Try changing it to this:
$query = "SELECT * FROM admins WHERE username = '". $_POST['username'] . "'";
Cgraz [/B]

You sir, are a fine, fine man. Thank you, it works.

cgraz

no problem. Anytime you ever run into mysql errors, use mysql_error() and print the query

$query = "select * from your_table where this='that'");
print $query . "<br>";
$result = mysql_query($query) or die(mysql_error());

Then you can delete the print $query part once it's working.

Cgraz