User levels

[techker]

hey guys im doing a dealership script for my body and i have a user section.now when we creat a user i set levels.

 

like 1 is full dealer price

      2 is retail price

      3 is retail -

 

so now im wondering how can i do it that it can check the level(thats ok with a querry)

 

$sql = "SELECT Level FROM $tbl_name WHERE ID = $ID";
$result = mysql_query($sql);

 

now i have my php echo

 

echo $info['Retail_price']

 

can i do something like

 

//echo (empty($row['d'])? "empty": "not empty"); //result not empty

 

but for level?

[AdRock]

like this?

 

$message = (empty($row['Level'])) ? "Empty" : "Not empty";

echo $message

[techker]

but this example is for if the table is empty.now i have numbers

[premiso]

$level = (empty($row['Level'])) ? $row['level'] : 0;

 

If you want to test if the level is = 0 or null then you would change the empty logic. But empty checks if $row['level'] is 0 or "" etc. So it is still valid. It does not check null variables though. If it can be null use is_null.

[techker]

but what if there is a 1 0r 2?

[conker87]

if ($row['Level'] == 1) { /* do full price */ }
else if ($row['Level'] == 2) { /* do retail */ }
else if ($row['Level'] == 3) { /* etc */ }

[techker]

if ($row['Level'] == 1) { /* do full price */ }
else if ($row['Level'] == 2) { /* do retail */ }
else if ($row['Level'] == 3) { /* etc */ }

 

thx for the help!i will try it out.