Leaderboard

Looking at the screenshot and your code, it seems like the following variable is the one you will use to determine which of the 3 images to display. $checkSqlRow["LEGIT"] Your screenshot suggests this variable will contain one of the following values: weet nie nee ja One option would be to test for those values in an if / elseif statements to determine which image to display. For example, if the green image is to be displayed for "ja" and red for "nee", you could do something like this: <?php $checkSqlRow["LEGIT"] = strtolower($checkSqlRow["LEGIT"]); //make sure the value is lower case before testing if($checkSqlRow["LEGIT"] == 'ja') { echo '<img src="green.gif">'; } elseif($checkSqlRow["LEGIT"] == 'nee') { echo '<img src="red.gif">'; } elseif($checkSqlRow["LEGIT"] == 'weet nie') { echo '<img src="yellow.gif">'; } ?> Note that the image names (and the path) will need to be adjusted to whatever you are using.

Your html code: <?php echo " <tr> <td><b><label for='firstNum1'>$coingecko_name</label></b></td> <td style='color:#EFE1CE'>$COINGECKO_ID</td> <td style='color:#EFE1CE'>{$checkSqlRow["COINGECKO_LEGIT"]}</td> <td style='color:#EFE1CE'>$coingecko_rank</td> "; A few var names that are not defined (to us). And a bit cleaner just by using php to do your output. Now - what is the problem? You did not tell us. And where is your attempt to make some kind of selection of the image you want to be chosen? BTW. Note that I removed your use of the deprecated 'font' tag. Your use of CSS later on is much preferred nowadays.

On a typical Debian/Ubuntu system, website stuff is at /var/www. There's nothing wrong with putting their home directories in there - tons of system accounts do things like that, just check /etc/passwd. And make sure you've disabled logins for those users.

gizmola, again thanks for your response. I am looking for ways to speed the app up so this is clearly something I'm going to have to study and implement. I'll look into Redis and learn what it will take to use it and where in my app it will help. Thanks again.