MSQL_RESULT(3)MSQL_RESULT(3)msql_result - Get result dataSYNOPSIS
string msql_result (resource $result, int $row, [mixed $field])
DESCRIPTION msql_result(3) returns the contents of one cell from a mSQL 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 are often much quicker than msql_result(3).
Recommended high-performance alternatives: msql_fetch_row(3), msql_fetch_array(3), and msql_fetch_object(3).
PARAMETERS
o $
result -The result resource that is being evaluated. This result comes from a call to msql_query(3).
o $row
- The row offset.
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 field offset is much quicker than specifying a fieldname or tablename.fieldname.
RETURN VALUES
Returns the contents of the cell at the row and offset in the specified mSQL result set.
PHP Documentation Group MSQL_RESULT(3)
Check Out this Related Man Page
MSQL_FETCH_OBJECT(3)MSQL_FETCH_OBJECT(3)msql_fetch_object - Fetch row as objectSYNOPSIS
object msql_fetch_object (resource $result)
DESCRIPTION msql_fetch_object(3) is similar to msql_fetch_array(3), with one difference - an object is returned, instead of an array. Indirectly, that
means that you can only access the data by the field names, and not by their offsets (numbers are illegal property names).
Speed-wise, the function is identical to msql_fetch_array(3), and almost as quick as msql_fetch_row(3) (the difference is insignificant).
PARAMETERS
o $
result -The result resource that is being evaluated. This result comes from a call to msql_query(3).
RETURN VALUES
Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
msql_fetch_object(3) example
<?php
$con = msql_connect();
if (!$con) {
die('Server connection problem: ' . msql_error());
}
if (!msql_select_db('test', $con)) {
die('Database connection problem: ' . msql_error());
}
$result = msql_query('SELECT id, name FROM people', $con);
if (!$result) {
die('Query execution problem: ' . msql_error());
}
while ($row = msql_fetch_object($result, MSQL_ASSOC)) {
echo $row->id . ': ' . $row->name . "
";
}
msql_free_result($result);
?>
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.0.4 | |
| | |
| | A bug was fixed when retrieving data from col- |
| | umns containing NULL values. Such columns were |
| | not placed into the resulting array. |
| | |
+--------+---------------------------------------------------+
SEE ALSO msql_fetch_array(3), msql_fetch_row(3), msql_data_seek(3), msql_result(3).
PHP Documentation Group MSQL_FETCH_OBJECT(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)
pls explain me how this works....
DECODE (SUBSTR (field, 1, 1),'''', '''''' || field || '''','''' || field || '''')
here field is a column in an oracle table.... (7 Replies)
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
I have . dat file which contains data in a specific format:
0 3 892 921 342
1 3 921 342 543
2 4 817 562 718 765
3 3 819 562 717 761
i need to compare each field in a row with another field of the same column but different row and cont the... (8 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)
Hi everyone..
I have a list of values in a file...
1.2345e-1
2.282828e+
3.2341e-1
1.1223445e-1
I am interested in converting this column to a row..
1.2345e-1 2.282828e+ 3.2341e-1 1.1223445e-1
can anyone pls help?? I am a liunx newbie..
Thanks.. (7 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)
There are some duplicate field on description column .I want to print duplicate row along with highest version of number and corresponding description column.
file1.txt
number Description
=== ============
34567 nl21a00is-centerdb001:ncdbareq:Error in loading init
34577 ... (7 Replies)
Hi Unix Forum,
I have a relatively easy question i suppose for which, however, until now i could not find a solution.
I am working with a program that will give me an output file similar to the following:
A
1
2
3
4
B
1
2
3
4
C
1 (9 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)
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)