Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: EdLentz
  • Content: Threads
  • Order by date
  1. EdLentz

    How can I escape $1 and && in a SED command

    I have a sed command that gets most of what I want done with the exception of the '$1' && I haven't figured out how to make it enter the line like I want. Here is my command: sed -i 's/# UserParameter=/UserParameter=systemd.unit.is-active,systemctl is-active --quiet $1 && echo 1 || echo 0/g'...
  2. EdLentz

    Looking for suggestions on how to do this

    I have a mysql query that I want to take the result of and upload/insert it into a different Mysql server. This would be once a day and over the internet. I will have many PCs sending the same info to a commn Mysql DB. I can setup ssh access. Just not sure how to get the info across. Is...
  3. EdLentz

    I need a simple example of how to send a table of info .

    I am trying to put together an email script that includes a html table. Can someone point me to an example of how to do this? I just have a small table with 5 items in a mysql DB. Thanks
    • EdLentz
    • Thread
    • Replies: 8
    • Forum: PHP
  4. EdLentz

    Partial link in email

    Hi I have a php file that I am using to email a html link. I have a variable for the WAN Ip address and then a page link. The link is formed for the WAN IP but for some reason the page isn't included in the link. $message = " <html> <head> <title>Unauthorized Programming</title> </head>...
    • EdLentz
    • Thread
    • Replies: 1
    • Forum: PHP
  5. EdLentz

    How do I use a keyword in a query??

    I have a table with no index and there are only keywords. Here is the layout: So there is a keyword I want the value from I have tried select * from freepbx_settings like %FREEPBX_SYSTEM_IDENT% FREEPBX_SYSTEM_IDENT is the keyword freepbx_settings is the table I know this should be easy...
  6. EdLentz

    Need to compare two tables and list the differences

    I have two identical tables in two different DBs. In the one I will be adding data, once all finished the I need will copy all that data to the other db.table. Later on I want to run a query to see if there has been any additions to the first table. Comparing the two tables seems to me the...
  7. EdLentz

    Insert blank row and update query

    I am not having any luck getting this to work. As far as I can tell I want to create a CRUD system. I have a table with 6 fields, I need a way to a. List all the records b. Provide a way to Insert a new record C. Edit an existing record. Here is what I have so far. I know it is...
  8. EdLentz

    Need help inserting array info into a table

    I have a page that uses several queries and puts the results in a table. The first query gets a list of extensions and the secret, then the next two columns are dropdowns with the options from a query allowing the user to select different options. I have a submit to send the info to a page to...
    • EdLentz
    • Thread
    • Replies: 12
    • Forum: PHP
  9. EdLentz

    How do I use the entries in an array as variables

    I have a page that I need to query a DB, put all the records in an array and then use the row info as variables in a while statement to create files. Here is my code for getting the array info <?php require('/var/www/html/cqadmin/utils/connect.php'); $query = "SELECT * FROM assignments"; if...
    • EdLentz
    • Thread
    • Replies: 4
    • Forum: PHP
  10. EdLentz

    How can I run an arp-scan and put the results in a mysql table

    I am setting up a method to program IP phones. I need a way to query the local network, get the MAC addresses of all the phones. I so far have this to discover the phones I want: arp-scan --interface=eth0 --localnet --retry 1 --timeout 50 --numeric --plain | grep -e 80:82:87 This shows from...
    • EdLentz
    • Thread
    • Replies: 11
    • Forum: PHP
  11. EdLentz

    Need help in how to create a Dropdown from a MySql table

    I have a table that in one column shows the results of a query. There could be many rows built. I need to create a form with this table and add two columns, each cell needs to be a dropdown from another table in the same DB. Basically I am linking the three columns to gether. At some point I...
    • EdLentz
    • Thread
    • Replies: 3
    • Forum: PHP
  12. EdLentz

    Need to know how to get only digit records

    I have a DB that I had an ID field that has numerals and letters in some of the entries. I want to get ONLY the entries with the digits for the id entry. How can I do this?? Here is what I have so far SELECT * FROM `sip` WHERE `keyword` LIKE 'secret' AND `id` like 102 This will pull the...
  13. EdLentz

    Need help with a query

    I have two tables the first I need to get the productid, and the unitprice. I need to insert into a second table the productid , the unit price * 1.25 into a second table. I also, need to insert into the second table (same record) a pricebookid number that I will enter manually. this is what...
  14. EdLentz

    Need help with table export.

    I need to export a table and I can't seem to get it right. Here is what I need: All fields separated by a comma , all fields enclosed by "" and if a field has either a Null of a nothing in it I need some kind of character either a 0 or o. I can get some of what I want using PHPMyAdmin but I...
  15. EdLentz

    This is maddening!

    I admittedly am not a Access programmer. I have an Access DB that I am using as a front End for a MySql DB. Within this Access frontend I have a report that is setup to go to the local dot matrix printer on her machine. She is the only user of this DB. For no apparent reason, the report print...
  16. EdLentz

    Simple emailer

    I need a simple form to send a pdf. I have a mailing list setup to send out a newsletter. I need a form that I can use to select a file to send to the group every so often. The file will change but where it goes (email to the list)who it is from, subject, etc. will stay the same. Basically...
    • EdLentz
    • Thread
    • Replies: 2
    • Forum: PHP
  17. EdLentz

    Can't move data from 1 DB to another

    I have two servers that are running linux with a MySql DB running on each. The old server is running MySql 4.0.20 and the new one is running MySql 4.1.12. What I am trying to do is move all the data from the old to the new. So here is what I have done so far. I used phpmyadmin to dump the...
  18. EdLentz

    Need advice here

    I have two tables They are for inventory. I have fields in each that would be duplicate entries for example: a row in each table that has the same part number, but maybe a different description and price. Then I might have parts in the one table that are not in the other and I would want to...
  19. EdLentz

    Getting #deleted# when updating data to a MySql table

    I am trying to use a MS Access 2000 front end for a MySql DB. I have MDAC ver 2.8, Jet4 SP8, on a WinXP Home mach. trying to update tables to a MySql 4.0.15 server. I have MySql ODBC driver version 3.51.06 (latest is 3.51.11, but from what I have read the .11 is buggy). I have a form that I...
  20. EdLentz

    Best way to do this??

    I have a table with customer information, along with other fields. I have another table that I want to get information (several fields) from the previous table into. Should I use an insert statement, an update statement or a join? TIA Ed

Part and Inventory Search

Back
Top