PHP problem with query result

Question

i have a problem with a query in a php file. I have a query that retrieves an e-mail address, it works about right, but when it sends the email, the address is added twice.

SELECT email FROM jos_users WHERE id=$i

$i is a number that auto increments.

i have a for to check each user id to see if a email should be sent.

Any ideas?

thanks, Sebastian

Can you post the code in the file... Describing it is a lot less helpful than showing it... — ircmaxell
– ircmaxell, Commented Aug 20, 2010 at 14:08
The query isn't the issue. How are you iterating through the results? — Fosco
– Fosco, Commented Aug 20, 2010 at 14:09

soulmerge · Accepted Answer · 2010-08-20 15:05:04Z

2

If your list of ids is not too long, you could use something like this:

SELECT DISTINCT email FROM jos_users WHERE id IN (5, 18, 24, ...);

If you get a packet too long error, you can either increase the packet size, use a temporary table or keep track of the emails in your PHP application. Here is an example using temporary tables:

CREATE TEMPORARY TABLE tmp (id INT);
/* insert first 50 values (or 100, or 1000, whichever fits into your packet size)*/
INSERT INTO tmp (id) VALUES (5), (18), (24) ...;
/* insert next 50 values */
INSERT INTO tmp (id) VALUES (105), (118), (124) ...;
/* more inserts until you have a temporary table containing all ids */
INSERT INTO tmp ...
INSERT INTO tmp ...
/* select */
SELECT DISTINCT email FROM jos_users INNER JOIN tmp USING (id);

edited Aug 20, 2010 at 15:05

answered Aug 20, 2010 at 14:10

soulmerge

76.2k20 gold badges121 silver badges160 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP problem with query result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related