3 Queries but I know I only need 1... but how?

[Vern1271]

I have 3 queries that pull from the same table. The only different is that in all three queries I pull 2 different types based on what's in the database table.

 

1st Query:

mysql_select_db($database_database1, $database1);

$query_partners1 = "SELECT * FROM partners WHERE par_type = 1 AND partners.par_show != 1 ORDER BY par_name ASC";

$partners1 = mysql_query($query_partners1, $database1) or die(mysql_error());

$row_partners1 = mysql_fetch_assoc($partners1);

$totalRows_partners1 = mysql_num_rows($partners1);

 

As you can see I'm looking for par_type = 1 in this query. Pretty much the same for the other two.

 

I know there is a way to have just one query and slip out the results, but I don't know how.

 

Any help would be appreciated.

[fenway]

What does "slip out" mean?