<!DOCTYPE html>
<html>

<body>
<?php
$q = $_GET['q'];
include 'config.php';
mysqli_select_db($connection,"newcourses");
$sql="SELECT * FROM newcourses WHERE unit = '".$q."' order by id asc limit 1";
$result = mysqli_query($connection,$sql);

while($row = mysqli_fetch_array($result)) {
    $retrieve=$row['registration_fees'];
    echo "<label>Make payment for registration fees, kshs ". $retrieve. ". Ensure you have kshs ". $retrieve . " in your Mpesa account plus transaction costs. Keep the phone unlocked. Enter the phone number and click Pay Now.<br> A prompt will appear in you mobile phone asking you to enter Mpesa PIN</label>";
  session_start();
  $_SESSION['superhero'] = "$retrieve";
}
mysqli_close($connection);
?>
</body>
</html>