Not sure if this is strictly a unix issue, but in any case,......
What database are you using? There is likely a date/time function we can call in your query to produce your results straight off the bat.
Your logic of using a where clause based on being like '%/00', thrn '%/01' etc. could generate you spurious values.
Something like:
Might get you started and perhaps use of a trimming function to ignore the minutes value will get the actul result you want straight from the SQL query, but like I say, it depends on the database server you are using.
Wholly untested bit of theory, but I hope that this helps a bit. If you respond with the database software, you may get a complete response. In my opinion you would save processing time to get the database to perform the work within the initial query rather than get the data to a file then post-process it to create the output you want. You can use the to_char function of many databases to give you date/time output in the format you want too.
how would I write a command line that creates a new file named stuff.txt in the current working directory which contains the number of directories in the current working directory, followed by the number of empty files in the current working directory, followed by the name of the working directory? (3 Replies)
Hi
i data looks like this:
student 1
Subject1 45 55
Subject2 44 55
Subject3 33 44
//
student 2
Subject1 45 55
Subject2 44 55
Subject3 33 44
i would like to sum $2, $3 (marks) and divide each entry in $2 and $3 with their respective sums and print for each student as $4 and... (2 Replies)
Hi,
I have an array of strings. Each string has 4 comma separated values. I am binding this array to a SQL where I am required to do an INSERT after grouping.
The binding is done as :
$insertADWSth->bind_param_array(1,A_CONSTANT_STRING);... (1 Reply)
How do you do grouping in grep? Here's how I tried it at first:
egrep 'qualit(y|ies)' /usr/share/dict/words
-bash: syntax error near unexpected token `('
I'm using GNUgrep, and I found this on their site. grep regular expression syntax
So I tried this:
egrep 'qualit\(y\|ies\)'... (2 Replies)
Hi all,
I am using following command:
perl program.pl input.txt output.txt CUTOFF 3 > groups_3.txt
containing program.pl, two files (input.txt, output.txt) and getting output in groups_3.txt:
But, I wish to have 30 files corresponding to each CUTOFF ranging from 0 to 30 using the same... (1 Reply)
Hi Gurus,
I would like to do in a script something that is really easy in sql.
Basically, I have a file with a fomat like the following:
name1_test 501
name 1 33 510
test2 900
name1_test 300
So, I would like to group them as... (3 Replies)
awk 'FNR==NR {a; next} $NF in a' genes.txt refseq_exons.txt > output.txt
I can not figure out how to group the same name in $4 together.
Basically, all the SKI together in separate rows and all the TGFB2. Thank you :).
chr1 2160133 2161174 SKI
chr1 218518675 218520389 TGFB2... (1 Reply)
Hello,
I would like to group/sort a file of records by a particular field and then count how many records belong in that grouping.
For example say I have the following data:
1234|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA
ABCD|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA
EFGH|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|BB... (14 Replies)
Discussion started by: Nik44
14 Replies
LEARN ABOUT PHP
mysqli_use_result
MYSQLI_USE_RESULT(3) 1 MYSQLI_USE_RESULT(3)mysqli::use_result - Initiate a result set retrieval
Object oriented style
SYNOPSIS
mysqli_result mysqli::use_result (void )
DESCRIPTION
Procedural style
mysqli_result mysqli_use_result (mysqli $link)
Used to initiate the retrieval of a result set from the last query executed using the mysqli_real_query(3) function on the database con-
nection.
Either this or the mysqli_store_result(3) function must be called before the results of a query can be retrieved, and one or the other
must be called to prevent the next query on that database connection from failing.
Note
The mysqli_use_result(3) function does not transfer the entire result set from the database and hence cannot be used functions such
as mysqli_data_seek(3) to move to a particular row within the set. To use this functionality, the result set must be stored using
mysqli_store_result(3). One should not use mysqli_use_result(3) if a lot of processing on the client side is performed, since this
will tie up the server and prevent other threads from updating any tables from which the data is being fetched.
RETURN VALUES
Returns an unbuffered result object or FALSE if an error occurred.
EXAMPLES
Example #1
mysqli::use_result example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";
/* execute multi query */
if ($mysqli->multi_query($query)) {
do {
/* store first result set */
if ($result = $mysqli->use_result()) {
while ($row = $result->fetch_row()) {
printf("%s
", $row[0]);
}
$result->close();
}
/* print divider */
if ($mysqli->more_results()) {
printf("-----------------
");
}
} while ($mysqli->next_result());
}
/* close connection */
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";
/* execute multi query */
if (mysqli_multi_query($link, $query)) {
do {
/* store first result set */
if ($result = mysqli_use_result($link)) {
while ($row = mysqli_fetch_row($result)) {
printf("%s
", $row[0]);
}
mysqli_free_result($result);
}
/* print divider */
if (mysqli_more_results($link)) {
printf("-----------------
");
}
} while (mysqli_next_result($link));
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
my_user@localhost
-----------------
Amersfoort
Maastricht
Dordrecht
Leiden
Haarlemmermeer
SEE ALSO mysqli_real_query(3), mysqli_store_result(3).
PHP Documentation Group MYSQLI_USE_RESULT(3)