FouLu's query should have worked.
Try it in a MySQL query tool instead of PHP.
But another way to write it is:
SELECT platform_id, plat_name FROM platforms
WHERE platform_id NOT IN (
SELECT platform_no FROM main )
Usually not as efficient as the version FouLu gave you, but it should work.
If it doesn't, then you have a problem in your data.