I need to filter input file according to following
All rows with the following conditions should be removed
1) If in a row, the number of 'N's starting col 2 exceeds 2 (3 or more)
OR
2) If a row is duplicated with the same value, starting col 2,
A value 'N' is considered missing value and shouldnt be considered
in this step. If a row has 4 'C's and and 2 'N's , it is considered a duplicate
row.
I have an Employee with EID, ENAME and ESTATUS as columns in SQL.
I want to extract the status of an employee and update the details if the status is 'A'.
Can anyone help in writing the shell script. (1 Reply)
Dear Forum,
I would like to know how could I found every result from one column at a table based at two table.
Exemplo:
Table:
Red 4
Red 5
Red 10
Black 33
Black 44
Black 5
Green 2
Green 55
Green 78
I would like to have every color with the lower result... (12 Replies)
Hi,
I am connecting to oracle database using perl.
I am able to connect but i am not able to get all the rows from the table.
Here is the code.
#!/usr/bin/perl
use DBI;
my $dbh=DBI->connect("DBI:Oracle:student","class","welcome") or die "Couldnot connect oracle Database";... (1 Reply)
I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work.
Basically I wrote code like this:
select * from `Test_DC_Trailer` HAVING max(DR_RefKey);
Where the DR_RefKey is a unique numeric field that is auto iterated (like a primary key)... (7 Replies)
Hello,
I have two files of same structure except some rows are missing randomly in each file. How do I fill the missing rows to have the exact ID column (S01 ~ S96) and rest columns filled with "0" with awk? The purpose of this step is to join the two files side by side. The closest thread is... (17 Replies)
Hi All,
I am trying to select the rows in a fixed width file based on values in the columns.
I want to select only the rows if column position 3-4 has the value AB
I am using cut command to get the column values. Is it possible to check if cut -c3-4 = AB is true then select only that... (2 Replies)
Hello All,
I have visited many pages in Unix.com and could find out one solution for merging the HTML cells in the 1st row.
(Unable to post the complete URL as I should not as per website rules).
But, however I try, I couldn't achieve this merging to happen for all other rows of HTML... (17 Replies)
Dear Forum,
I have to filter (e.g. PF=0.8) a text file according to some measured and recorded values for different fields (sensor). The files can be large and the recorded data points (ID) could differ in length. I have worked out a solution but it is very messy and not flexible. Does anybody... (4 Replies)
Hello
I've four fields . They are First Name, Last Name, Age, Country. So when I run a Unix command, I get below output with these fields comes every time in different order as you can see. Some times first name is the first row and other time last name is first row in the output and etc etc..... (9 Replies)
Discussion started by: rprpr
9 Replies
LEARN ABOUT PHP
msql_fetch_row
MSQL_FETCH_ROW(3)MSQL_FETCH_ROW(3)msql_fetch_row - Get row as enumerated arraySYNOPSIS
array msql_fetch_row (resource $result)
DESCRIPTION msql_fetch_row(3) fetches one row of data from the result associated with the specified query identifier. The row is returned as an array.
Each result column is stored in an array offset, starting at offset 0.
Subsequent call to msql_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.
PARAMETERS
o $
result -The result resource that is being evaluated. This result comes from a call to msql_query(3).
RETURN VALUES
Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
msql_fetch_row(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_row($result)) {
echo $row[0] . ': ' . $row[1] . "
";
}
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_object(3), msql_data_seek(3), msql_result(3).
PHP Documentation Group MSQL_FETCH_ROW(3)