Siann Beck

First, assuming your ID column is a unique ID, there is no need to specify the user ID. Then your list needs to be in the form 1, 2, 3 -- not an actual array. Then your query will look something like DELETE FROM messages WHERE id IN ($deletelist); ANY time you're constructing a query in a program, and using variables, it's always a good idea to output the query so you can see exactly what the query is, and if you still don't see the problem, submit the query manually via PHPMyAdmin or the MySQL monitor, and see what happens.

Actually, you're already doing a join, just not explicitly, and your join is backward (sort of). But that's beside the point, what you need is the GROUP BY clause. Try this: SELECT poolname, pools.poolid FROM picks, pools WHERE picks.userid = 1 AND pools.poolid = picks.poolid GROUP BY picks.poolid

::sigh:: I'm an idiot. The BBCode parser was converting them. *Siann Beck smacks herself in the forehead.

Does your table have a unique id field? If so, perhaps a sub-query would work for you: SELECT data1, data2, data3 FROM custtable WHERE recordid in ( SELECT recordid FROM custtable WHERE date <= '04/15/2010' GROUP BY customer ORDER BY date DESC) ORDER BY data1, data2, data3

I have to confess I've always been a bit baffled by character encodings, so I'm only assuming it's a database issue, but I have correct data coming from one field and not another, so that's the basis of my assumption. Table definition: [pre]ListingID int(11) DEFAULT NULL, Language char(2) COLLATE utf8_unicode_ci DEFAULT NULL, Title varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, Description text COLLATE utf8_unicode_ci, Search text COLLATE utf8_unicode_ci, UNIQUE KEY ListingID_2 (ListingID,Language), KEY ListingID (ListingID), FULLTEXT KEY Search (Search) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci[/pre] Server version: 5.1.36 When someone enters Japanese characters, the title displays properly, but the description does not. Example: http://www.metaverseexchange.com/listing.php?id=8164&lc=ja