FBSQL_RESULT(3) 1 FBSQL_RESULT(3)fbsql_result - Get result dataSYNOPSIS
mixed fbsql_result (resource $result, [int $row], [mixed $field])
DESCRIPTION
Returns the contents of one cell from a FrontBase $result set.
When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As these
functions return the contents of multiple cells in one function call, they're MUCH quicker than fbsql_result(3).
Calls to fbsql_result(3) should not be mixed with calls to other functions that deal with the result set.
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
o $row
-
o $field
- Can be the field's offset, or the field's name, or the field's table dot field's name (tablename.fieldname). If the column name
has been aliased ('select foo as bar from...'), use the alias instead of the column name.
Note
Specifying a numeric offset for the field argument is much quicker than specifying a fieldname or tablename.fieldname argu-
ment.
RETURN VALUES SEE ALSO
Recommended high-performance alternatives: fbsql_fetch_row(3), fbsql_fetch_array(3), fbsql_fetch_assoc(3), fbsql_fetch_object(3).
PHP Documentation Group FBSQL_RESULT(3)
Check Out this Related Man Page
FBSQL_FETCH_ASSOC(3) 1 FBSQL_FETCH_ASSOC(3)fbsql_fetch_assoc - Fetch a result row as an associative arraySYNOPSIS
array fbsql_fetch_assoc (resource $result)
DESCRIPTION
Calling fbsql_fetch_assoc(3) is equivalent to calling fbsql_fetch_array(3) with FBSQL_ASSOC as second parameter. It only returns an asso-
ciative array.
This is the way fbsql_fetch_array(3) originally worked. If you need the numeric indices as well as the associative, use
fbsql_fetch_array(3).
An important thing to note is that using fbsql_fetch_assoc(3) is NOT significantly slower than using fbsql_fetch_row(3), while it provides
a significant added value.
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
RETURN VALUES
Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows.
If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the
same name, you must use fbsql_fetch_array(3) and have it return the numeric indices as well.
EXAMPLES
Example #1
fbsql_fetch_assoc(3) example
<?php
fbsql_connect($host, $user, $password);
$result = fbsql_db_query("database", "select * from table");
while ($row = fbsql_fetch_assoc($result)) {
echo $row["user_id"];
echo $row["fullname"];
}
fbsql_free_result($result);
?>
SEE ALSO fbsql_fetch_row(3), fbsql_fetch_array(3), fbsql_fetch_object(3).
PHP Documentation Group FBSQL_FETCH_ASSOC(3)
Hallo All, this is my code below. The problem happens under section A because field $9 sometimes does not contain a number it contains a (:) and a number is contained in field $10 as result under sectionC we get a syntax error @
echo "scale=1; $aa+$ee+$ff"|bc > /tmp/pax/c3.txt
So i need to... (5 Replies)
Hi all, I need some help on switching field/column values. For example I have a file name data.txt which contains:
a b
a b
a b
and I want to switch a and b and save it to the same file.
the file data.txt then will have:
b a
b a
b a
The problem is, well, I know how to... (7 Replies)
$db2 connection ...........Q
a=`$db2 -x "select A from tablename where z in (select z from tablename Q where condition fetch first 1 rows only ) with ur"`
b=`$db2 -x "select B from tablename where z in (select z from tablename Q where condition fetch first 1 rows only) with ur"`
$db2... (2 Replies)
pls explain me how this works....
DECODE (SUBSTR (field, 1, 1),'''', '''''' || field || '''','''' || field || '''')
here field is a column in an oracle table.... (7 Replies)
Hello All,
Please if I could get some help on the following, I have data files (due to 3rd party mistake) within each data file on line/row 3 column/field 3 - there is value '1' that need to be changed to '0'.
For example:
HEAD, TYPE OF FILE
NAME,ADDRESS
M,TYPE, 1
Now initially... (4 Replies)
Hi,
I have the below data
ownername/schemaname/tablename/columnname in a file ( 2nd column)
I want to convert everthing to upper case except the column name like below
OWNERNAME/SCHEMANAME/TABLENAME/columnname
do we have a instring function in awk to handle this.
Thx,shruthi (3 Replies)
How do you delete cells from a space delimited text file given row and column number? Letś say the row number is r and the column number is c. Thanks! (5 Replies)
Dear all,
I have been trying to print an entire field, if the first line of the field is matching.
For example, my input looks something like this.
aaa ddd zzz
123 987 126
24 0.650 985
354 9864 0.32
0.333 4324 000
I am looking for a pattern,... (5 Replies)
I'm a newbie to perl and not much of a coder in general, but I must use it at my new task at work. I have two text files that are several hundred MBs large. I need to pull in data from a column in file 2 into file 1. Basically, file 2 is the lookup table and I can key off the unique id column that... (3 Replies)
I saw some recent posts where I thought the terms "field" and "column" were being misused. I work with data a lot, and have my opinions. I'm wondering if those opinions are correct.
***** Rows seem clear - I don't think there is any controversy about what a row is, either for database or text... (10 Replies)
Hello,
I am new to Linux environment , I working on Linux script which should send auto email based on the specific condition from log file. Below is the sample log file
Name m/c usage
abc xxx 10
abc xxx 20
abc xxx 5
xyz ... (6 Replies)
Please help! I figured I would take this one to the experts. I'm working with a field that contains contents such as:
LastName FirstName
For example:
Smith John
I'm trying to take this field and split it so that it is two separate fields (first name and last name). I then need to print... (5 Replies)
Gents,
Please can you help me with this.
When column 49 == 2
Need to do the following changes;
Change previous row field (substr$0,45,4)-1
Change previous row field (substr$0,72,5)+2
Change actual row field (substr$0,40,4)+1
Change actual row field (substr$0,49,1)-1
Change actual... (6 Replies)