Sponsored Content
Full Discussion: Query in CENTOS
Special Forums UNIX and Linux Applications Query in CENTOS Post 302889099 by shobana praveen on Wednesday 19th of February 2014 04:48:29 AM
Old 02-19-2014
Thank you

---------- Post updated at 04:48 AM ---------- Previous update was at 12:12 AM ----------

Thanks for your reply............it was helpful.

But I have another query like how to fetch only particular data from database (MYSQL)(for ex: user and msg) for every 2hrs and convert into an .xls format.

How to write script for the below query?
Code:
$arrAcc="SELECT accountID FROM account";
$Accountid=$DB->Execute($arrAcc);

for($i=0;$i<=length($Accountid);$i++)
{
$arrDevice="SELECT deviceID FROM device";
$Deviceid=$DB->Execute($arrDevice); 
for($j=0;$j<=length($Deviceid);$j++)
{
$arrEvent="SELECT * FROM eventdata WHERE accountID=$i and deviceID=$j";
$EventData=$DB->Execute($arrEvent);  
}
$j++;
}
$i++;

Thanks,
Shobana

Last edited by Franklin52; 02-19-2014 at 06:33 AM.. Reason: Please use code tags
 

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1... (0 Replies)
Discussion started by: hazno
0 Replies

2. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

3. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

4. UNIX Benchmarks

2-cpu centos 5.7

BYTE UNIX Benchmarks (Version 3.11) System -- Linux centos1 2.6.18-274.17.1.el5xen #1 SMP Tue Jan 10 18:06:37 EST 2012 x86_64 x86_64 x86_64 GNU/Linux Start Benchmark Run: Fri Mar 2 19:42:41 EST 2012 2 interactive users. Dhrystone 2 without register variables 6929864.9 lps (10 secs,... (0 Replies)
Discussion started by: ppchu99
0 Replies

5. Red Hat

How to Upgrade Centos 5.7 using Centos 5.8 ISO image on Vmware workstation

Dear Linux Experts, On my windows 7 desktop with the help of Vmware workstation (Version 7.1), created virtual machine and installed Centos 5.7 successfully using ISO image. Query : Is this possible to upgrade the Centos 5.7 using Centos 5.8 ISO image to Centos version 5.8?.. if yes kindly... (2 Replies)
Discussion started by: Ananthcn
2 Replies

6. Red Hat

RH V Centos

Hi, I have built out a new virtual production environment (VMWare, HA enabled, VMotion... all the bells & whistles) using RHEL5 VM's. I have got another ESX host that I plan to use as a pre-prod environment. To save some costs on RH subs I was thinking about installing this environment... (5 Replies)
Discussion started by: Duffs22
5 Replies
PSTOPS(1)						      General Commands Manual							 PSTOPS(1)

NAME
pstops - shuffle pages in a PostScript file SYNOPSIS
pstops [ -q ] [ -b ] [ -wwidth ] [ -hheight ] [ -ppaper ] [ -dlwidth ] pagespecs [ infile [ outfile ] ] DESCRIPTION
Pstops rearranges pages from a PostScript document, creating a new PostScript file. The input PostScript file should follow the Adobe Doc- ument Structuring Conventions. Pstops can be used to perform a large number of arbitrary re-arrangements of Documents, including arranging for printing 2-up, 4-up, booklets, reversing, selecting front or back sides of documents, scaling, etc. pagespecs follow the syntax: pagespecs = [modulo:]specs specs = spec[+specs][,specs] spec = [-]pageno[L][R][U][H][V][@scale][(xoff,yoff)] modulo is the number of pages in each block. The value of modulo should be greater than 0; the default value is 1. specs are the page specifications for the pages in each block. The value of the pageno in each spec should be between 0 (for the first page in the block) and modulo-1 (for the last page in each block) inclusive. The optional dimensions xoff and yoff shift the page by the specified amount. xoff and yoff are in PostScript's points, but may be followed by the units cm or in to convert to centimetres or inches, or the flag w or h to specify as a multiple of the width or height. The optional parameters L, R, U, H and V rotate the page left, right, or upside-down, and flip (mirror) page horizontally or vertically. The optional scale parameter scales the page by the fraction specified. If the optional minus sign is specified, the page is relative to the end of the document, instead of the start. If page specs are separated by + the pages will be merged into one page; if they are separated by , they will be on separate pages. If there is only one page specification, with pageno zero, the pageno may be omitted. The shift, rotation, and scaling are performed in that order regardless of which order they appear on the command line. The -w option gives the width which is used by the w dimension specifier, and the -h option gives the height which is used by the h dimen- sion specifier. These dimensions are also used (after scaling) to set the clipping path for each page. The -p option can be used as an alternative, to set the paper size to a3, a4, a5, b5, letter, legal, tabloid, statement, executive, folio, quarto or 10x14. The default paper size is a4. The -b option prevents any bind operators in the PostScript prolog from binding. This may be needed in cases where complex multi-page re- arrangements are being done. The -d option draws a line around the border of each page, of the specified width. If the lwidth parameter is omitted, a default linewidth of 1 point is assumed. The linewidth is relative to the original page dimensions, i.e. it is scaled up or down with the rest of the page. Pstops normally prints the page numbers of the pages re-arranged; the -q option suppresses this. EXAMPLES
This section contains some sample re-arrangements. To put two pages on one sheet (of A4 paper), the pagespec to use is: 2:0L@.7(21cm,0)+1L@.7(21cm,14.85cm) To select all of the odd pages in reverse order, use: 2:-0 To re-arrange pages for printing 2-up booklets, use 4:-3L@.7(21cm,0)+0L@.7(21cm,14.85cm) for the front sides, and 4:1L@.7(21cm,0)+-2L@.7(21cm,14.85cm) for the reverse sides (or join them with a comma for duplex printing). AUTHOR
Copyright (C) Angus J. C. Duggan 1991-1995 SEE ALSO
psbook(1), psselect(1), pstops(1), epsffit(1), psnup(1), psresize(1), psmerge(1), fixscribeps(1), getafm(1), fixdlsrps(1), fixfmps(1), fix- macps(1), fixpsditps(1), fixpspps(1), fixtpps(1), fixwfwps(1), fixwpps(1), fixwwps(1), extractres(1), includeres(1) TRADEMARKS
PostScript is a trademark of Adobe Systems Incorporated. BUGS
Pstops does not accept all DSC comments. PSUtils Release 1 Patchlevel 17 PSTOPS(1)
All times are GMT -4. The time now is 11:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy