Comibine a destinct query
Posted: Wed Jul 30, 2003 11:03 am
hi all
i got an query that gets all country from a table a puts it in my form option table
this is the query
$query = mysql_query ("SELECT DISTINCT country FROM ip ORDER BY country",$db) or die("Sites Database SELECT Error");
if 1 of this countrys is used it will be putted in "land from iptable"
How do i tell in the first query to first look if a country is used in "land from iptable" and then output all the countrys from "country from ip" without the used countrys
Can some one help me out?
greetz
gerd
i got an query that gets all country from a table a puts it in my form option table
this is the query
$query = mysql_query ("SELECT DISTINCT country FROM ip ORDER BY country",$db) or die("Sites Database SELECT Error");
if 1 of this countrys is used it will be putted in "land from iptable"
How do i tell in the first query to first look if a country is used in "land from iptable" and then output all the countrys from "country from ip" without the used countrys
Can some one help me out?
greetz
gerd