hi!
i have little problem with left join
below script working but i want to add restriction
field_id = 16 (any value)
and
user_id = 65 (any value)
pls help me how to do this
id user_id field_id value
<?php
$dbHost = "localhost";
$dbUser = "root";
$dbPass = "123";
$dbName = "family";
$options = '';
$link=mysql_connect("$dbHost","$dbUser","$dbPass");
if(!$link){exit(mysql_error());}
mysql_select_db("$dbName",$link) or exit(mysql_error());
function display_children($value, $level) {
$result = mysql_query("SELECT a.user_id, Deriv1.Count FROM `jos_community_fields_values` a LEFT OUTER JOIN (SELECT value, COUNT(*) AS Count FROM `jos_community_fields_values` GROUP BY value) Deriv1 ON a.user_id = Deriv1.value WHERE a.value=" . $value);
echo "<ul>";
while ($row = mysql_fetch_assoc($result)) {
if ($row['Count'] > 0) {
echo '<li><a>'.$row['user_id'].'</a>';
display_children($row['user_id'], $level + 1);
echo "</li>";
} elseif ($row['Count']==0) {
echo '<li><a>'.$row['user_id'].'</a></li>';
} else;
}
echo "</ul>";
}
echo display_children(0, 1);
print mysql_error();
?>