$sql = mysql_query("select name_brand,name_type,name_model
from car,typecar,brand,model
where car.id_brand = brand.id_brand and car.id_type = typecar.id_type and
car.id_model = model.id_model and car.id_type != "" ");
แต่ถ้าต้องการแสดงทั้งหมดก็ไม่ต้องใส่ and car.id_type != "" ค่ะ