check for a particular value in a db field
Posted: Sat Jan 17, 2004 1:03 am
newbie here - i simply want to check for a 1 or a 0 in field "free" - if "0" go there, if "1" stay here...
it don't work... (my db connection is good...)
anybody?
thanks ,
glenn
Code: Select all
$sql = "SELECT free FROM user WHERE username = 'glennn' ";
$result = mysql_query($sql);
if ($result == "0"){
print("<script language="javascript">
top.location="test.php";
</script>");
}anybody?
thanks ,
glenn