| Platinum
include("db/dbinfo.inc.php");
mysql_connect($databasehost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * FROM (SELECT name as name ,sum(price) as total FROM procedures GROUP BY name) AS sub WHERE sub.total>=1000 ORDER BY sub.total DESC";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo $num;
?>
| |
|
if($num != 0)
{
$i=0;
while ($i < $num)
{
echo mysql_result($result,$i,"name");
if($i<$num-1) echo " ";
$i++;
}
}
?>
| |
| | | |
|
| Gold
$query = "SELECT * FROM (SELECT name as name ,sum(price) as total FROM procedures GROUP BY name) AS sub WHERE sub.total>=500 AND sub.total<1000 ORDER BY sub.total DESC";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo $num;
?>
| |
|
if($num != 0)
{
$i=0;
while ($i < $num)
{
echo mysql_result($result,$i,"name");
if($i<$num-1) echo " ";
$i++;
}
}
?>
| |
| | | |
|
| Silver
$query = "SELECT name FROM (SELECT name as name ,sum(price) as total FROM procedures GROUP BY name) AS sub WHERE sub.total>=200 AND sub.total<500 ORDER BY sub.total DESC";
$result=mysql_query($query);
mysql_close();
$num=mysql_numrows($result);
echo $num;
?>
| |
|
if($num != 0)
{
$i=0;
while ($i < $num)
{
echo mysql_result($result,$i,"name");
if($i<$num-1) echo " ";
$i++;
}
}
?>
| |
| | | |
|
list updated on echo date('d-m-Y');?>
|