02-17-2010
My experience is that you should know the nature of the MySQL query, i.e. number and size of rows and columns before deciding on how to format the output.
Generally, we should read most queries into an array first, or an array of arrays and then print the output in loop where we can format the output properly.
Simply adding a newline to a row with large fields, blobs, and or many columns, will be messy.
There should be some structure to the query unless the query is trivial like getting only a few small fields.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i need to grep date in the format year-month-day,,,,,,,
actually i need to grep those dates other than current date..........
can anyone help me in this...........i need a format of date which would grep previous date except current date (1 Reply)
Discussion started by: ali560045
1 Replies
2. Shell Programming and Scripting
Hi all, I'd like to capture the output from the 'top' command to monitor my CPU and Mem utilisation.Currently my command isecho date
`top -b -n1 | grep -e Cpu -e Mem` I get the output in 3 separate lines.Tue Feb 24 15:00:03
Cpu(s): 3.4% us, 8.5% sy .. ..
Mem: 1011480k total, 226928k used, ....... (4 Replies)
Discussion started by: new2ss
4 Replies
3. Shell Programming and Scripting
I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column.
I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this?
Sample input
02/27/09,23:52:31
02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies
4. UNIX for Dummies Questions & Answers
I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd.
The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4".
This is what I use to change the format:
sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies
5. Shell Programming and Scripting
Hi guys,
I'm doing a project now and extracting tables from a webpage to MySQL table format.
I dumped the webpage with lynx and it is like this
id
Spec
524543
Developed especially for seniors
Spec
No
Java
Spec
Yes
Java MIDP
Spec
... (4 Replies)
Discussion started by: Johanni
4 Replies
6. Shell Programming and Scripting
Good afternoon!
I have been lurking in this forum for awhile now. I have just recently started posting. I think this is a really good site. With that being said, I don't like to just run and get an answer before I try my best first.
I have poured some blood, sweat and tears into... (4 Replies)
Discussion started by: brianjb
4 Replies
7. UNIX and Linux Applications
On psql
select titolo,lingua from titolo where titolo ~* 'brivid';
titolo | lingua
------- + ------
Brivido | 1
On Sqlplus/gqsql
SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%';
TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies
8. UNIX for Dummies Questions & Answers
Hi Friends,
Am new to Unix world and this is my first post in this forum.
I was stuck in displaying the content.
while displaying the content the below points to be taken care
1 ) The header format is repeating
2) To display the value in table format... (2 Replies)
Discussion started by: rocky2013
2 Replies
9. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
10. UNIX for Advanced & Expert Users
I am stuck with values in existing program perl script...
my $format ="a40a9a*";
please help me to understand what is the value of "a40a9a*".
Thanks in advance! (3 Replies)
Discussion started by: Vijay_Data
3 Replies
LEARN ABOUT PHP
ifx_fetch_row
IFX_FETCH_ROW(3) 1 IFX_FETCH_ROW(3)
ifx_fetch_row - Get row as an associative array
SYNOPSIS
array ifx_fetch_row (resource $result_id, [mixed $position])
DESCRIPTION
Fetches one row of data from the result associated with the specified result identifier.
Subsequent calls to ifx_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.
PARAMETERS
o $result_id
-$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).
o $position
- An optional parameter for a "fetch" operation on "scroll" cursors: NEXT, PREVIOUS, CURRENT, FIRST, LAST or a number. If you
specify a number, an "absolute" row fetch is executed. This parameter is optional, and only valid for SCROLL cursors.
RETURN VALUES
Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows.
Blob columns are returned as integer blob id values for use in ifx_get_blob(3) unless you have used ifx_textasvarchar(1) or ifx_byteasvar-
char(1), in which case blobs are returned as string values.
EXAMPLES
Example #1
Informix fetch rows
<?php
$rid = ifx_prepare ("select * from emp where name like " . $name,
$connid, IFX_SCROLL);
if (! $rid) {
/* ... error ... */
}
$rowcount = ifx_affected_rows($rid);
if ($rowcount > 1000) {
printf ("Too many rows in result set (%d)
<br />", $rowcount);
die ("Please restrict your query<br />
");
}
if (! ifx_do ($rid)) {
/* ... error ... */
}
$row = ifx_fetch_row ($rid, "NEXT");
while (is_array($row)) {
for (reset($row); $fieldname=key($row); next($row)) {
$fieldvalue = $row[$fieldname];
printf ("%s = %s,", $fieldname, $fieldvalue);
}
printf("
<br />");
$row = ifx_fetch_row($rid, "NEXT");
}
ifx_free_result ($rid);
?>
PHP Documentation Group IFX_FETCH_ROW(3)