MySQL Queries..

Ravenous

Here's my code:

<?php
	$username = $HTTP_POST_VARS['username'];
	$password = $HTTP_POST_VARS['password'];
	$db		  = mysql_connect("localhost", "root");

mysql_select_db("bhiclients",$db);
$result = mysql_query("SELECT * FROM users WHERE username=$username");
$row = mysql_fetch_array($result, MYSQL_ASSOC);

echo '<html><head></head><body>';

echo '</body></html>';
?>

Here's the error message I get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\clientadmin\login.php on line 8

WTF?!

Any help is appreciated.. 🙂

kevinsequeira

$query ="SELECT * FROM users WHERE username='".$username."'";
echo $query;
$result = mysql_query($query);
if(mysql_error()){
  echo mysql_error();
}
if(mysql_num_rows($result)<1){
  echo "no results";
}else{
$row = mysql_fetch_array($result); 
.
.
.
.
}

reg
kevin