Help with multiple table qry

[wmguk]

Hey,

 

i have a script trying to display all the company names in a database.

 

clients (company names)

contacts (actual member of staff)

 

I need to show all companies who uses PAT as account manager...

 

this is my code:

<?
 include ($_SERVER['DOCUMENT_ROOT'] . "/admin/scripts/connection.php");

$sql = "SELECT contacts.a_accmgr, clients.company, clients.level, clients.active FROM clients, contacts 
WHERE contacts.a_accmgr = 'pat' AND (clients.company LIKE '%') AND clients.level != 'CLOSED' AND (clients.level LIKE '%' OR clients.active LIKE '%') 
GROUP BY clients.company 
ORDER BY clients.company ASC " ;

echo $sql;
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) 
{
echo $row['company'];
echo "<br>";
} ?>

 

but currently the results show all businesses in the database, not just where PAT is accmgr.

 

any ideas where my code is wrong?

[Brian W]

WHERE contacts.a_accmgr = 'pat' AND ...

Does the a_accmgr field in the contacts table limit the clients being returned? I don't believe it would with how you have your query built...

Also, why is there all these "LIKE '%'", that means it could be anything in the field or entirely nothing.