freshrod Posted May 4, 2006 Share Posted May 4, 2006 I don't know why I can't figure this out... but I haven't yet. Basically I have a value in a DB field that I want to check. The column is set up like this:'alumInfo enum ('0','1') NOT NULL default='0',I query it like this:$sql = mysql_query("SELECT alumInfo FROM users WHERE username='$username' AND password='$password'");what I want to do next is where the problem lies (at least I think it is). I want to check what the value is. If it's 0 I want to print one thing, if it's 1 I want to print something else. I've tried something like this:$row = mysql_fetch_array($sql);if({$row['alumInfo']} == 1) { // I've tried writting this several ways... apparently all wrongecho "one thing";} else {echo "something else";}but that's getting me nothing but errors. Help? Link to comment https://forums.phpfreaks.com/topic/9031-checking-a-db-field/ Share on other sites More sharing options...
.josh Posted May 4, 2006 Share Posted May 4, 2006 if($row['alumInfo'] == '1') { Link to comment https://forums.phpfreaks.com/topic/9031-checking-a-db-field/#findComment-33201 Share on other sites More sharing options...
freshrod Posted May 4, 2006 Author Share Posted May 4, 2006 argh! so close...Thanx again Violent. Link to comment https://forums.phpfreaks.com/topic/9031-checking-a-db-field/#findComment-33204 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.