Is this what you want ??
$sql = "SELECT DISTINCT(email) FROM $table";
$result = mysql_query($sql,$connection) or die("Couldn't execute query 0.");
$row1 = 0;
while ($row = mysql_fetch_array($result)) {
echo $row[email] ;
$sql1 = "SELECT * FROM $table WHERE viewed = '1' AND email = '$row[email]'";
$result1 = mysql_query($sql1,$connection) or die("Couldn't execute query 1.");
if (mysql_num_rows($result1) >= 1) {
echo 'Viewed' ;
} else {
echo '' ;
}
}
echo $row1 ;
>>Right, todays fun dilema... ;-)
>>I've a user capture system set up for downloads on our site.
>>Each time a user downloads a file, their info is captured (so we'll have
>>multiple entries for each email address).
>>Also in the table, is a field to state if the result has been viewed by my
>>boss. (Just a 1/0 value)
>>
>>So, what my boss wants me to do now, is to show her, the total No of
>>people captured, and how many she's viewed.
>>Using the 'email' field, from the table, I've done a distinct() sort in
>>MySQL to ensure that I have a list of emails(users) and no duplicates.
>>My prob is this:
>>I want to take each email, and see if at any point, there's a '1' in the
>>viewed field.
>>if there is, I want to add one to the total of $row1
>>So I can output the num_rows from the distinct request, and then show the
>>total of $row1...
>>So I'll have total No of users, and total No of viewed... as I've
>>mentioned above.
>>What am I doing wrong?
>>
>><?
>>$sql = "SELECT DISTINCT(email) FROM $table";
>>$result = mysql_query($sql,$connection)
>> or die("Couldn't execute query 0.");
>>
>>$row1 = 0;
>>
>>while ($row = mysql_fetch_array($result)) {
>>
>>$sql1 = "SELECT * FROM $table WHERE viewed = '1' AND email =
>>'$row[email]'";
>>$result1 = mysql_query($sql1,$connection)
>> or die("Couldn't execute query 1.");
>> if (mysql_num_rows($result1) >= 1) {
>> $row1++;
>> }
>>}
>>?>
>><?=$row1 ?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
