2 queries into 1 query

netfrugal

I'm not expecting this to be possible, but I thought I'd ask.

I have 2 queries that I want to make into 1.

"SELECT email FROM email_list"

"SELECT COUNT(email) FROM email_list"

So everyone knows what I'm trying to do, I have a simple php mail() script that selects the email address (based on the WHERE statement), and then I count the # of emails that were emailed (using the second query).

Is there a way to converge those 2 queries into one statement?

thanks

dagon

run the first query, then use mysql_num_rows

laserlight

netfrugal wrote:
So everyone knows what I'm trying to do, I have a simple php mail() script that selects the email address (based on the WHERE statement), and then I count the # of emails that were emailed (using the second query).

If you want to count the number of emails that were sent then you should use a counter in PHP and test the return value of mail() as you loop and send the emails. Of course, just because the emails were sent does not mean they were received.

dagon wrote:
run the first query, then use mysql_num_rows

Aside from the fact that the MySQL extension is not necessarily in use, the problem with that is that gives a count of how many database table rows were retrieved, not a count of how many emails were sent.

dagon

laserlight;10897888 wrote:
Aside from the fact that the MySQL extension is not necessarily in use, the problem with that is that gives a count of how many database table rows were retrieved, not a count of how many emails were sent.

as does his 2nd query :p