two values with one query

[ilmaggy]

Hi all,

I want to get two values with one query:
the country_name that belongs to country_id_1 and,
the country_name that belongs to country_id_2.

I used this query:
(SELECT name FROM countries WHERE country_id = '1')
UNION
(SELECT name FROM countries WHERE country_id = '2')

But it didn't work with mysql_fetch_row / mysql_fetch_array.
Does anyone know how to do this?
Thanking you in advance,
Ruben.

 

[sleipnir214]

Oh, I certainly wouldn't use a union for something that simple.

Something like:

SELECT name FROM countries WHERE country_id IN (1, 2)

or

SELECT name FROM countries WHERE coutnry_id = 1 OR country_id = 2

will do it.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[jpadie]

I agree ...

...but i think the query should work

$sql = "SELECT `name` FROM countries WHERE country_id = '1'
       UNION 
       SELECT `name` FROM countries WHERE country_id = '2'";
$result= mysql_query($sql) or die (mysql_error());
while ($row=mysql_fetch_assoc($result)):
  echo $row['name']. "<br/>";
endwhile;

 

[sleipnir214]

<facetious>
I'm sure the query would work. But why would you want to use it?
</facetious>



Want the best answers? Ask the best questions! TANSTAAFL!

 

[jpadie]

quite!