<?php

require('dbinterface.php');

$company = $_GET['c'];
$company_name = str_replace("_", " ", $company);

$db = new db("localhost", "login", "****", "db");
if ($db = false) {
  die($db->get_error());
}

$q = "SELECT * FROM orders JOIN moodle_enrollment me ON me.orderno=orders.orderno WHERE orders.company = '" . $db->escape($company_name) . "' ORDER BY me.username";

echo $q . "<br />";

$res = $db->run($q);


print_r($res);

?>