<?php // ID запрашиваемой категории $id_categor = 1; $r = mysql_query("SELECT * FROM categors, setkas, tovars, machs WHERE categors.id_categor = '". $id_categor."' AND setkas.id_categor = '". $id_categor."' AND tovars.id_categor = '". $id_categor."' AND tovars.id_mach = machs.id_mach"); if(!$r)exit(mysql_error()); while($t = mysql_fetch_array($r)) { echo "<strong>Товар по категории ". $t['categor']. " :</strong> <br>" . $t['mach'].";<br> " .$t['setka'].";<br>"; } ?>