I am currently attempting to build a webpage that displays database records and then gives each record a category of Low Medium or High dependent on a value held in a field.
Ie if Record 1 Field 2 contains a numeric 100 then the Record 1 Field 2 contains the string HIGH.
I have managed to display the records onto a page from the database (mySQL). I have accomplished this using Dream Weaver. But am not sure how to get access to the database attributes to use them in an If statement.
This is what I have at the moment,
<?php
if ($row_rs_sdi['sdi value'] > 100){
$risk = "High";
}
?>
it gives me the following error message.
Notice: Undefined variable: risk in
c:\inetpub\wwwroot\myphp_fmbsite\sdi-view.php on
line 53
