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)
Check Out this Related Man Page
FBSQL_FETCH_ARRAY(3) 1 FBSQL_FETCH_ARRAY(3)fbsql_fetch_array - Fetch a result row as an associative array, a numeric array, or bothSYNOPSIS
array fbsql_fetch_array (resource $result, [int $result_type])
DESCRIPTION fbsql_fetch_array(3) is a combination of fbsql_fetch_row(3) and fbsql_fetch_assoc(3).
An important thing to note is that using fbsql_fetch_array(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).
o $result_type
- A constant and can take the following values: FBSQL_ASSOC, FBSQL_NUM, or FBSQL_BOTH. When using FBSQL_BOTH, in addition to
storing the data in the numeric indices of the result array, it also stores the data in associative indices, using the field names
as keys.
RETURN VALUES
Returns an 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 the numeric index of the column or make an alias for the column.
select t1.f1 as foo t2.f1 as bar from t1, t2
EXAMPLES
Example #1
fbsql_fetch_array(3) example
<?php
fbsql_connect($host, $user, $password);
$result = fbsql_db_query("database", "select user_id, fullname from table");
while ($row = fbsql_fetch_array($result)) {
echo "user_id: " . $row["user_id"] . "<br />
";
echo "user_id: " . $row[0] . "<br />
";
echo "fullname: " . $row["fullname"] . "<br />
";
echo "fullname: " . $row[1] . "<br />
";
}
fbsql_free_result($result);
?>
SEE ALSO fbsql_fetch_row(3), fbsql_fetch_assoc(3), fbsql_fetch_object(3).
PHP Documentation Group FBSQL_FETCH_ARRAY(3)
how can i display every column in a row individually........
i vauguely remmeber something like echo $1 $2 etc.......but i dont remmeber properly......so is there anything like that?
i tried searching but wasnt able to find......
thanks and regards
vivek.s (2 Replies)
Can anyone help..
I have a .dat file which contains 5 columns of data. I need to select one row containing just 3 of the columns. I'm not sure how to select a single row? I then need perform arithmetic on on two out of the three columns and display the output in a new column.
For example..
... (1 Reply)
Most shells flavors do not have associative arrays a.k.a. maps.
How would you emulate an associative array?
I had this problem once and found a working solution, but I don't want to spoil the game hence I wont tell it.
Wonder if anyone comes up with something better. (5 Replies)
Hi,
I have a file that contains multiple rows and I want to find how often a list of names come up for row #2 (note: all files are tab deliminted):
So the file looks like this:
1212 RICK
9823 JOAN
1221 RICK
1254 JACK
1224 JACK
So I have another file that contains the list of... (5 Replies)
I'm not very good at associative arrays; and working on this PHP code has got me a bit stumped. My goal is to populate a (multidimensional) associative array in a PHP while look after a MySQL query. The code fragment looks like this:
while($campaign_row = mysql_fetch_array($campaigninfo))
{
... (9 Replies)
Hi, I already succeed moving a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla).
But it can't delete the old row. Please help me with the script.
my php script:
INSERT INTO... (2 Replies)
this is the requirement
list.txt
table1
table2
table3
testfile.txt
name#place#data#select * from table1
name2#place2#data2#select * from table 10 innerjoin table3
name2#place2#data2#select * from table 10
output
name place table1
name2 place table3
i tried using awk (7 Replies)
Hi, I have a long file in the format below. I want to delete the consecutive lines that contain the same value in column 1.
I have tried awk '!x++' FS="," filename
This has not worked.
14,MM709_BHP_DM,BHP,BHP_MC709_DM
19,OFFLINE,CHE,CHEV_MC773_DM
20,M33,BP,BP_MIM775_NS_DM ... (2 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)
Hello together,
i make something wrong... I want an array that contains information to associate it for further processing.
Here is something from my bash... You will know, what I'm trying to do.
I have to point out in advance, that the variable $SYSOS is changing and not as static as in my... (2 Replies)
Hello,
I need to find out the minimum and maximum values based on specific column, and then print out the entire row with the max value.
Infile.txt:
scf6 290173 290416 . + X_047241 T_00113118-1
scf6 290491 290957 . + X_047241 T_00113118-2
scf6 290898 290957 . + X_047241 T_00113119-3
scf6... (2 Replies)
Hello.
I have an export of an associative array build using declare -p SOME_ARRAY_NAME > SOME_FILE_NAME.txt.
Producing some thing like declare -A SOME_ARRAY_NAME=( ="some_text" ="a_text" ......... ="another_text" ) in a text file.
I have a stock of functions which are sourced from... (1 Reply)