Finally got it!
Cheers for all your help...
it was the group by Emial that was the clincher...
I didn't know that it acted like distinct()
Live and learn...!
Cheers everyone!
Gavin Amm [EMAIL PROTECTED]
04/06/2004 00:16
To
[EMAIL PROTECTED]
cc
Subject
RE: [PHP-DB] Multiple SQL queries
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
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
PROTECTED] [EMAIL PROTECTED]
cc
Subject
Re: [PHP-DB] 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
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 03, 2004 4:43 PM
Subject: Re: [PHP-DB] 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 [EMAIL
OK, how about this?
$sql = SELECT DISTINCT(email) FROM $table;
$result = mysql_query($sql,$connection) or die(Couldn't execute query
0.);
while ($row = mysql_fetch_array($result)) {
echo $row[email] ;
$sql1 = SELECT * FROM $table WHERE viewed = '1' AND email =
'$row[email]';
]
[EMAIL PROTECTED]
Subject
Re: [PHP-DB] Multiple SQL queries...?
OK, how about this?
$sql = SELECT DISTINCT(email) FROM $table;
$result = mysql_query($sql,$connection) or die(Couldn't execute query
0.);
while ($row = mysql_fetch_array($result)) {
echo $row[email] ;
$sql1
Not tested... how about something like this?
SELECT t1.email, t2.count(*)
FROM $table t1
LEFT JOIN $table t2 ON (t1.email = t2.email and t2.viewed = '1')
GROUP BY EMAIL
Nope...
HHmmm, this is really getting to me...
I can do distinct, I can count, but I can't combine the two?
Can't be that
Have you tried - GROUP BY email - ?
Nope...
HHmmm, this is really getting to me...
I can do distinct, I can count, but I can't combine the two?
Can't be that hard ;-)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database
I am new this.
I have a page that has multiple queries on it, I want to do doing the
following:
Query a mysql db multiple times in the same page, but i must be missing
something, I keep getting these AFTER the first queryis successful:
Warning: mysql_fetch_array(): supplied argument is not a
10 matches
Mail list logo