$result1 = mysql_query("select wr_1  from g4_write_people3 where wr_subject = '{$row[wr_subject]}' and wr_link1 like '{$YM}{$day}'");

$result2 = mysql_result($result1, 0);

$tc1 += $result2; 

위와 같이 했더니 아래와 같은 메세지가 뜹니다

mysql_result() unable to jump to row 0 on mysql result index  

그래서 아래와 같이 했더니 에러는 없는데 느리고 추가로 데이터를 구할 때 또 쿼리문을 넣는 것도 많아질듯하고 그래서 이 쿼리문을 간편하게 만들 수는 없을까요?

$sql2 = mysql_query("select wr_link1 from g4_write_people3 where wr_subject = '{$row[wr_subject]}' and wr_link1 like '{$YM}{$day}'") or die(mysql_error());

$result1 = mysql_query("select wr_1  from g4_write_people3 where wr_subject = '{$row[wr_subject]}' and wr_link1 like '{$YM}{$day}'") or die(mysql_error());

$result3 = mysql_query("select wr_2  from g4_write_people3 where wr_subject = '{$row[wr_subject]}' and wr_link1 like '{$YM}{$day}'") or die(mysql_error());

$result5 = mysql_query("select wr_3  from g4_write_people3 where wr_subject = '{$row[wr_subject]}' and wr_link1 like '{$YM}{$day}'") or die(mysql_error());

if (!$sql2 || !mysql_num_rows($sql2) || !$result1 || !mysql_num_rows($result1) || !$result3 || !mysql_num_rows($result3) || !$result5 || !mysql_num_rows($result5)) {}

else {

$row2 = mysql_result($sql2, 0);

$result2 = mysql_result($result1, 0);

$tc1 += $result2;

$result4 = mysql_result($result3, 0);

$tc2 += $result4;

$result6 = mysql_result($result5, 0);

$tc3 += $result6;

}