[PHP-DB] query and count

I have two tables, the first one I query like : $query = SELECT * FROM xp_topics WHERE artist_count='artist' AND topictext LIKE 'B%' ORDER BY artist_count DESC limit 0,5; $req = mysql_query($query); $res = mysql_num_rows($req); if ($res == 0) { echo /p pbSorry

Re: [PHP-DB] query and count

Hi, I hate to simply refer to other sources in a response, but cross-tabulations are a large and rich subject which are too large for the time I have to write this email. I would suggest reading this article: http://www.devshed.com/Server_Side/MySQL/MySQLWiz which is a pretty good source