$sql1 = "SELECT COUNT(*) as views FROM $table WHERE viewed = '1' AND email =
'$row[email]'";
$views = mysql_resutl(mysql_query($sql1,$connection),"views");
maybe?
.bobo
www.elstudion.com/bitbob/ <- not finished though...
----- Original Message -----
From: <Tristan.Pretty@xxxxxxxxxxxxxxxx>
To: "Daniel Clark" <dclark@xxxxxxxxxx>
Cc: <php-db@xxxxxxxxxxxxx>
Sent: Thursday, June 03, 2004 4:43 PM
Subject: Re: Multiple SQL queries...?
> Kinda, but I just wanna count how many views in total...
> Hence my $row1++; bit...
> I'll have a play with your code though...!
> Cheers,
> Tris...
>
>
>
>
> "Daniel Clark" <dclark@xxxxxxxxxx>
> 03/06/2004 14:28
> Please respond to
> "Daniel Clark" <dclark@xxxxxxxxxx>
>
>
> To
> "php-db@xxxxxxxxxxxxx" <php-db@xxxxxxxxxxxxx>,
> "Tristan.Pretty@xxxxxxxxxxxxxxxx" <Tristan.Pretty@xxxxxxxxxxxxxxxx>
> cc
>
> Subject
> Re: Multiple SQL queries...?
>
>
>
>
>
>
> 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
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
