Bash script array from MySQL query - HELP Please!!!

I'm having problems getting a monitoring script to run. I've put the troublesome bit in a separate script just to test, and it goes like this: declare -a HNdeclares the array HN HN=(`echo SELECT url FROM hosts | mysql --user=netmon --password=n3tm0n --skip-column-names

Re: Bash script array from MySQL query - HELP Please!!!

I would look at the 15th URL to see if there are specials in there that are breaking the hash somehow. On 5/22/07, Ben Benson [EMAIL PROTECTED] wrote: I'm having problems getting a monitoring script to run. I've put the troublesome bit in a separate script just to test, and it goes like

MySQL Query Help Needed

Can anybody help me sort my results in the correct way. My Table description is: +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | id

Re: MySQL Query Help Needed

Not sure I understand what you need? Can you create a dummy output table of what you would like your result to look like? At first glance, from reading your question, it sounds like you simply want this: select * from ppc_keywords where keywords like %job% [group by keywords] order by bid;

Re: MySQL Query Help Needed

I think the most difficult ( if not impossible with just using mysql query) is the part where you apply your logic as to the most relevant keyword. You need to be able to have a mechanism of telling the query which keyword is the most relevant, ie, human logic says, the one that matches the search

mysql query help

Hello, I have the following table structure and need assistance on a mysql query: Members MemberID (unique) Name Address Credits CreditID MemberID Project Title Credit_Images = ImageID CreditID Location Comments Showroom = ShowroomID MemberID Size Comments

mySQL query help please

Greetings: RE: mySQL query help please INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID, Configuration, Equipment_Type, Group_ID, Location, Rack_Location, Network_Status_Name, Creator_ID, Primary_IP_Address FROM Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4

RE: mySQL query help please

[snip] INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID, Configuration, Equipment_Type, Group_ID, Location, Rack_Location, Network_Status_Name, Creator_ID, Primary_IP_Address FROM Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) = Customer.User_ID; The select statement

RE: mySQL query help please

Greetings Jay: RE: mySQL query help please I love rules that don't make sense ;-) So if the end result is to have the records selected appended to the Customer_Equipment table, I have to make a temporary table based on the characteristics of the Customer_Equipment table... then insert from

RE: mySQL query help please

[snip] So if the end result is to have the records selected appended to the Customer_Equipment table, I have to make a temporary table based on the characteristics of the Customer_Equipment table... then insert from that temporary table. Correct? [/snip] BINGO! Goofy rules can be frustrating

Re: Mysql query help needed!!

Hi Chris, On Fri, 2002-06-14 at 02:08, Chris Kay wrote: I have a rather longer query which I would like to get all records past todays date. Here is my query $ttwo = date(YmdGi); snip

Mysql query help needed!!

I have a rather longer query which I would like to get all records past todays date. Here is my query $ttwo = date(YmdGi); $abc = select detail.*, type.type_name, status.status_name, staff.staff_name,

mysql query help

I need some help... The query below runs fine in access, when running it in mysql it tells me the column wrainfo.wuc doesn't exist in the having clause.. can't figure out why its giving me this error. the column is in the select statement... any ideas? The column does exist.. I'm looking at

RE: mysql query help

PROTECTED]] Sent: Thursday, June 06, 2002 7:23 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: mysql query help I need some help... The query below runs fine in access, when running it in mysql it tells me the column wrainfo.wuc doesn't exist in the having clause.. can't figure out why

RE: mysql query help

] To: Scott Raley/LPEC/ASD/SEMCORINC@SEMCOR INC., [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: RE: mysql query help I've not looked over your query in-depth so I may be off-base here. Try removing the parentheses from the FROM clause and see if that makes it work. =C= * * Cal

Re: [PHP-DB] MYSQL query help

It's not the IN, it's the sub-query you cannot use. MySQL doesn't support them and it's just about the main reason I don't like it. Alternatives? You could execute your subquery and return the results to an array. Loop through the array, using the index and the indexed element to drive a

MYSQL query help

I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative that would work? select * from lib_asset_tbl where material_id '' and asset_id in (select asset_id from lib_copy_tbl) Help is appreciated. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc.

Re: MYSQL query help

Harpreet writes: I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative that would work? select * from lib_asset_tbl where material_id '' and asset_id in (select asset_id from lib_copy_tbl) Help is appreciated. Regards, Harpreet Kaur Software Developer Crispin