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

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
add the output of a query to a variable to be used in another query

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Redirect Query o/p to variable	Swapna173	UNIX for Dummies Questions & Answers	2	08-01-2008 07:48 AM
need help in reading a output of a sql query in unix script	pharos467	Shell Programming and Scripting	8	07-01-2008 02:00 AM
To spool output from a database query	Jess	Shell Programming and Scripting	0	04-07-2008 12:23 AM
script variable within a sql query	Sherry_Run	Shell Programming and Scripting	1	12-12-2007 05:15 AM
sql query variable not exactly unix	MizzGail	Shell Programming and Scripting	5	12-10-2002 03:03 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

03-24-2009

hazno

Registered User

Join Date: Mar 2009

Location: Tokyo

Posts: 21

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?

PHP Code:


			
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
        echo $row["host"],"\n";
}
odbc_close($connect);
?>

This will output hostnames:

host1 host2 host3

I would like to add the output to the variable $hosts something like this:

$hosts = "host1,host2,host3"

I plan to use $host in another query further down in the script.

thanks & regards

Bookmarks

« Read/write file with scripting | Extract IP addresses »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 02:47 AM.