เกี่ยวกับการ select ข้อมูลใน database คับ ขอความช่วยเหลือหน่อยค้าบ

$sql = "SELECT * FROM city_tbl ORDER BY city_id";
$result = mysql_query($result);
while($rs = mysql_fetch_array($result))
{

    echo $rs[city_name];
    echo "<br>";

    $sql2 = "SELECT * FROM shop_tbl WHERE city_id='$rs[city_id]' ORDER BY shop_id";
    $result2 = mysql_result( $sql2)
    while($rs2 = mysql-fetch_array($result2))
    {

           echo $rs2[shop_name];
           echo "<br>";

    }

 
}

<?php 
		$sql="select * from shop.profile order by shop_city";
		$query=mysql_query($sql) or die ("error=$sql"); 
		$row=mysql_fetch_array($query);
		
		echo "$row[shop_city]<br>";
		
		$sql="select * from shop.profile where shop_city=$row[shop_city]";
		$query=mysql_query($sql) or die("error=$sql");
		while($row=mysql_fetch_array($query))	{
		$name=$row[name];
		
		echo"$name";
		}
		
		?>