Mysql query

[cd34]

remove the first query and read mysql_num_rows() ?

[ronnie]

Hey, if it works, thats all that counts. Kinda confusing, dont know you db layout, ect, not that I want to know.

I try to keep all my stuff in one table at a time, sure makes queries easier..

ronnie

[swedguy]

Originally Posted by ronnie

Hey, if it works, thats all that counts. Kinda confusing, dont know you db layout, ect, not that I want to know.

I try to keep all my stuff in one table at a time, sure makes queries easier..

ronnie

It works, but it bugs me that I have to do it in two steps. First get the sponsors, then go through each sponsor and check if they have the banners I'm looking for.

Which means: If I have 100 sponsors = 101 queries.

[swedguy]

Originally Posted by cd34

remove the first query and read mysql_num_rows() ?

Same result. But I still have to do the first query, the one to get the sponsors.

[swedguy]

Here's what the full query looks like:

PHP Code:

$uniq_banners = 3;
$query = 'SELECT '.$uniq_banners.' = COUNT(*) FROM ( 
SELECT DISTINCT 1 FROM banners WHERE sponsor LIKE "$sponsor" AND keyword LIKE "horizontal" 
UNION ALL 
SELECT DISTINCT 1 FROM banners WHERE sponsor LIKE "$sponsor" AND keyword LIKE "vertical" 
UNION ALL 
SELECT DISTINCT 1 FROM banners WHERE sponsor LIKE "$sponsor" AND (keyword LIKE "small" OR keyword LIKE "button") 
) AS tbl';

$result = mysql_query("SELECT DISTINCT sponsor FROM table");
$myrow = mysql_fetch_array($result);
if ($myrow and @mysql_num_rows($result)) {
  do {
    $sponsor = $myrow["sponsor"];
    eval("\$use_query = \"$query\";");
    $result2 = mysql_query($use_query);
    $res = mysql_result($result2, 0);
    if ($res == 1)
      // We got a sponsor that has the correct banners
      ;
  } while($myrow = mysql_fetch_array($result));
}