sql구문
wr_item_code 변수에 아래와 같이 연결할 수 없습니까?
$list[$i][wr_item_code] = $row['wr_item_code_1'] $row['wr_item_code_2'] $row['wr_item_code_3']
$sql = "select * from g4_write_sales where (wr_shipment_day like '%$name2%') OR (wr_item_code_1 like '%$name2%') OR (wr_item_code_2 like '%$name2%') OR (wr_item_code_3 like '%$name2%') order by wr_shipment_day desc";
$result = sql_query($sql);
$search_count = 0;
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$list[$i][wr_purchase_date] = $row['wr_shipment_day']; // 발송일
$list[$i][wr_item_code] = $row['wr_item_code_1'] ; // 코드
$list[$i][wr_item_code] = $row['wr_item_code_2'] ; // 코드
$list[$i][wr_item_code] = $row['wr_item_code_3'] ;
$search_count++;
}
$list[$i][wr_item_code] = $row['wr_item_code_1'] $row['wr_item_code_2'] $row['wr_item_code_3']
$sql = "select * from g4_write_sales where (wr_shipment_day like '%$name2%') OR (wr_item_code_1 like '%$name2%') OR (wr_item_code_2 like '%$name2%') OR (wr_item_code_3 like '%$name2%') order by wr_shipment_day desc";
$result = sql_query($sql);
$search_count = 0;
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$list[$i][wr_purchase_date] = $row['wr_shipment_day']; // 발송일
$list[$i][wr_item_code] = $row['wr_item_code_1'] ; // 코드
$list[$i][wr_item_code] = $row['wr_item_code_2'] ; // 코드
$list[$i][wr_item_code] = $row['wr_item_code_3'] ;
$search_count++;
}
|
댓글을 작성하시려면 로그인이 필요합니다.
댓글 4개
$list[$i][wr_item_code] = $row['wr_item_code_1'],$space. $row['wr_item_code_2'] .$space.$row['wr_item_code_3'];
데이터가 있으면 BR을 넣고 없으면 공백으로 하고자 합니다.
if ($list[$i][wr_item_2]== '') { echo ''; } else { echo '<br>'; }
데이터가 없을 경우 공백라인이 많이 발생합니다.