[RESOLVED] Hide / Show based on value in DB

[phprican]

I have a db table called users, and in table i have a field called app_id. the default value is 0.. the only other value is 1

I have a if statement i just cannot seem to get to work

<?php

    $sql = "SELECT * FROM users WHERE uid = $uid";
    $result = query($sql);

    $app_id = $row['app_id'];


    if ($rct_id == "0") {      

        echo = "this";   /// if app_id returns 0

} else {

        echo = "something else";    /// if app id returns 1
    }
}

?>

[dalecosp]

"$rct_id" isn't the same as "$app_id" ...

[phprican]

rct_id should be app_id

[dalecosp]

OK; make it so. Now, where does $row come from?

[phprican]

The row i was told to put there to get the value of the field in users called app_id

[phprican]

all i am trying to do is when a user logs in and goes to app page if the value in the users table called app_id field is 0 then echo = "this"; /// if app_id returns 0, if the the id is 1 echo = "something else"; /// if app id returns 1

[dalecosp]

I know what you're trying to do. I also know you can't do it if you don't initialize $row 😉

Here are the first 3 lines of your script:

$sql = "SELECT * FROM users WHERE uid = $uid";
$result = query($sql);

$app_id = $row['app_id'];

You've never had $row before that last line, and now you assign $app_id to be the value of something that doesn't exist. Do you see the problem now?

I'm thinking you wanted this:

$sql = "SELECT * FROM users WHERE uid = $uid";
$result = query($sql);

while ($row = some_function_that_makes_rows($res)) {

$app_id = $row['app_id'];

}

Of course, you have another problem. There's no function called [man]query/man, either.

Maybe trying reading a good tutorial?