Jump to content

Archived

This topic is now archived and is closed to further replies.

freshrod

Checking a DB field

Recommended Posts

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 wrong
echo "one thing";
} else {
echo "something else";
}

but that's getting me nothing but errors. Help?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.