Code: Select all
<?php
$connection = @mysql_connect($host, $user, $pass) or die ("Unable to connect to database");
mysql_select_db($db) or die ("Unable to select database: $db ");
$query = "SELECT DISTINCT cal_group_id
FROM cal_user_group
WHERE cal_user_id = '$cal_user_id'";
$result = mysql_query ($query);
while ($r = mysql_fetch_array($result)) {
$cal_group_id = $r['cal_group_id'];
}
$connection = @mysql_connect($host, $user, $pass) or die ("Unable to connect to database");
mysql_select_db($db) or die ("Unable to select database: $db ");
$query = "SELECT DISTINCT cal_user_id
FROM cal_user_group
WHERE cal_group_id IN ($cal_group_id)";
$result = mysql_query ($query);
while ($r = mysql_fetch_array($result)) {
$cal_group_user_id = $r['cal_user_id'] ;
}
$connection = @mysql_connect($host, $user, $pass) or die ("Unable to connect to database");
mysql_select_db($db) or die ("Unable to select database: $db ");
$query = "SELECT DISTINCT user_id, forename, surname
FROM users
WHERE user_id IN ($cal_group_user_id)";
$result = mysql_query ($query);
while ($r = mysql_fetch_array($result)) {
echo "<option value="$r['user_id']">$r[forename] $r[surname]</option>";
}
?>