Hello. I have a table title_views with each row being a "view" with a user_id, title_id, prog_id, date, and id. I want to gather just the user_ids without it returning duplicate user_ids. Right now I'm receiving duplicate user_id. Any help is appreciated. Thank you.
PHP Code:
<?PHP
include("db.php");
$qry= mysql_query("SELECT * FROM programs")
or die (mysql_error());
while($row = mysql_fetch_array($qry)){
$prog_titles = $row['titles'];
$prog_titles = explode(',' , $prog_titles);
$prog_id = $row['prog_id'];
array_shift($prog_titles);
foreach($prog_titles as $prog_title){
$trimmed = trim($prog_title);
$qry= mysql_query("SELECT DISTINCT user_id FROM title_views WHERE title_id = '$trimmed' and prog_id = '$prog_id' ")
or die(mysql_error());
$row = mysql_fetch_array($qry);
echo $row['user_id'] . "<br />";
} // end foreach
} //end while
?>