How to modify the code to reach the following results: lazygc520 and $ sql2 & nbsp ;=& nbsp; "SELECT & nbsp; stock_no, & nbsp; cust_no, & nbsp; m how to modify the code to achieve the following results
This post was last edited by lazygc520 at 12:00:23
$sql2 = "SELECT stock_no, cust_no, mount FROM `stock_detail` where stock_no = '".$stockno[$j-1]."' ORDER BY arr_time, adress, c_type ASC";
$result2 = mysql_query($sql2);
while($v2 = mysql_fetch_array($result2,MYSQL_ASSOC)) {
$v2[] = array_splice($a[$v2['stock_no']], 0, 13);
$val_1 = implode(",",$v2['0']);
echo $val_1.'
';
}
The result is as follows:
VP3.0 130219001,VP3.0 130219002,VP3.0 130219003,VP3.0 130219004,VP3.0 130219005,VP3.0 130219006,VP3.0 130219007,VP3.0 130219008,VP3.0 130219009,VP3.0 130219010,VP3.0 130219011,VP3.0 130219012,VP3.0 130219013
VP3.0 130219014,VP3.0 130219015,VP3.0 130219016,VP3.0 130219017,VP3.0 130219018,VP3.0 130219019,VP3.0 130219020,VP3.0 130219021,VP3.0 130219022,VP3.0 130219023,VP3.0 130219024,VP3.0 130219107,VP3.0 130219108
How to change:
'VP3.0 130219001','VP3.0 130219002','VP3.0 130219003','VP3.0 130219004','VP3.0 130219005','VP3.0 130219006','VP3.0 130219007','VP3.0 130219008','VP3.0 130219009','VP3.0 130219010','VP3.0 130219011','VP3.0 130219012','VP3.0 130219013'
'VP3.0 130219014','VP3.0 130219015','VP3.0 130219016','VP3.0 130219017','VP3.0 130219018','VP3.0 130219019','VP3.0 130219020','VP3.0 130219021','VP3.0 130219022','VP3.0 130219023','VP3.0 130219024','VP3.0 130219107','VP3.0 130219108'
Share:
------ Solution --------------------
$val_1 = "'".implode("','",$v2['0'])."'";