Hi all,
I have a file with several columns of data, eg:
A B C D
1 2 5 1
2 2 2 2
8 4 4 4
4 2 3 4
10 9 4 4
9 7 1 2
I need to get the values from, say, column B and place them into a string separated by a semicolon, eg:
2;2;4;2;9;7
Does... (4 Replies)
Dear friends,
Below is my program and current output. I wish to have 3 or 4 column output in order to accomodate in single page. i do have subsequent command to process after user enter the number.
Program
COUNT=1
for MYDIR in `ls /`
do
VOBS=${MYDIR}
echo "${COUNT}. ${MYDIR}"
... (4 Replies)
I have file which as 12 columns and values like this
1,2,3,4,5
a,b,c,d,e
b,c,a,e,f
a,b,e,a,h
if you see the first column has duplicate values, I need to identify (print it to console) the duplicate value (which is 'a') and also remove duplicate values like below. I could be in two... (5 Replies)
Hello,
I have an input file like the following:
11_3_4
2_1_35
3_15__
_16989
Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Hi,
I've got a file with 3 columns which ends like this:
...
1234 345 1400
5287 733 1400
8472 874 1400
9317 726 1400
I want to replace the last row of the last column with the value 0. So my new file will end:
...
1234 345 1400
5287 733 1400
8472 874 1400
9317 726 ... (5 Replies)
Hi, I need somebody's help with sorting data with awk.
I've got a file:
10 aaa 4584
12 bbb 6138
20 ccc 4417
21 ddd 7796
10 eee 7484
12 fff ... (5 Replies)
HI Guys,
I have below Input :-
X L1 5
Y L1 10
Z L1 15
X L2 20
Y L2 12
Z L2 15
X L3 100
Y L3
Z L3 300
Output:-
ID L1 L2 L3
X 5 10 15
Y 20 12 15
Z 100 Null 300 (11 Replies)
Discussion started by: pareshkp
11 Replies
LEARN ABOUT PHP
cubrid_num_rows
CUBRID_NUM_ROWS(3) 1 CUBRID_NUM_ROWS(3)cubrid_num_rows - Get the number of rows in the result setSYNOPSIS
int cubrid_num_rows (resource $result)
DESCRIPTION
The cubrid_num_rows(3) function is used to get the number of rows from the query result. You can use it only when the query executed is a
select statement. When you want to know such value for INSERT, UPDATE, or DELETE query, you have to use the cubrid_affected_rows(3) func-
tion.
Note: The cubrid_num_rows(3) function can only be used for synchronous query; it returns 0 when it is used for asynchronous query.
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3), cubrid_query(3) and cubrid_prepare(3)RETURN VALUES
Number of rows, when process is successful.
0 when the query was done in async mode.
-1, if SQL statement is not SELECT.
FALSE when process is unsuccessful.
EXAMPLES
Example #1
cubrid_num_rows(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb", "dba");
$req = cubrid_execute($conn, "SELECT * FROM code");
$row_num = cubrid_num_rows($req);
$col_num = cubrid_num_cols($req);
printf("Row Num: %d
Column Num: %d
", $row_num, $col_num);
cubrid_disconnect($conn);
?>
The above example will output:
Row Num: 6
Column Num: 2
SEE ALSO cubrid_execute(3), cubrid_num_cols(3), cubrid_affected_rows(3).
PHP Documentation Group CUBRID_NUM_ROWS(3)