Fetching single record from Database using php.

 

 This will pull single `value` column data from row. 

*Note: $con is DB connection object.

$settingsQuery = mysqli_query($con,"select value from settings WHERE name='coinCalPer' LIMIT 1");

$settingsRow = mysqli_fetch_array($settingsQuery);
echo  $settingsRow['value'];