I have two tables: PLATFORMS and MAIN
I want to select the platform id numbers that exist in PLATFORMS
but that have not yet been used in MAIN
In PLATFORMS the platform id number field is platform_id
and in MAIN, if the platform has been used, its id is in platform_no
This gives me ALL the platform names and ids:
$sql_plat = "SELECT platform_id,plat_name FROM PLATFORMS ";
$result_plat = mysql_query($sql_plat) or die("could not find platforms". mysql_error());
but how do I exclude all those already used in MAIN ???
Thanks for advice.
If you want to attract and keep more clients, then offer great customer support
automates the process and gives you a trust seal
to place on your website.
I recommend that you at least take the 30 day free trial