Whats wrong with this code?

[duncan_cowan]

Hi please could someone tell me what is wrong with this code:

<?phpinclude("db_connect.php");$query = mysql_query("SELECT * FROM armies WHERE username=".$_SESSION['username']."");while($row = mysql_fetch_array($query))  {  }?>

When i run it it says:"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/i04wasp/public_html/protected/armyhome.php on line 10"Thankyou...

[skym]

Most probably an SQL error. Use$query = mysql_query("SELECT * FROM armies WHERE username=".$_SESSION['username']."") or die('SQL error: '.mysql_error());to see what the error is.

[justsomeguy]

You probably left out the quotes around the username:

$query = mysql_query("SELECT * FROM armies WHERE username='".$_SESSION['username']."'");

[Guest nelly]

Change this:while($row = mysql_fetch_array($query))To this:while($row = @mysql_fetch_array($query))

[yubaraj]

Your SQL Statement is wrong. You have left Quote in the sql command.For simplicity, do the following$ses_username = $_SESSION['username'];$query = mysql_query("select * from armies where username='$ses_username'");