query( "stock", "SELECT * FROM stock WHERE supplier_id = '{$supplier_id}'" ); while ($row = $res->fetch_assoc()) { echo "{$row['code']}~{$row['name']}~{$row['unit_of_measure']}~{$row['retail']}"; }