"; echo " ID BRAND MODEL SHORT DESCRIPTION "; while($row=mysql_fetch_array($result)){ echo ""; echo "".$row['b_id'].""; echo ""; $brandName = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='".$row['b_id']."'"),0); echo $brandName; echo ""; echo "".$row['m_name'].""; echo "".$row['m_desc'].""; echo ""; } echo ""; exit(); } ?>