[SOLVED] Can someone fix this code please?

[adamjones]

Hi.

 

I have this code;

 

<?php
mysql_connect("localhost", "designby_x", "password") or die(mysql_error());
mysql_select_db("designby_x") or die(mysql_error());

$result = mysql_query("SELECT * FROM members") or die(mysql_error());  

while($row = mysql_fetch_assoc($result)) {
if($row['frozen'] == 'yes' WHERE ($row['username'] == '$myusername' {
   header('location:frozen.php');
}
}

?>

 

And I get this error;

 

Parse error: syntax error, unexpected T_STRING in /home/designby/public_html/clients/home.php on line 14

 

[.josh]

<?php
mysql_connect("localhost", "designby_x", "password") or die(mysql_error());
mysql_select_db("designby_x") or die(mysql_error());

$result = mysql_query("SELECT frozen FROM members WHERE username = '$myusername' AND frozen = 'yes'") or die(mysql_error());  

if (mysql_num_rows($result) > 0) {
   header('location:frozen.php');
}
?>

[adamjones]

Cheers. All working now