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!

  • Congratulations Chris Miller 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: *

  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

    Thanks Andrzejek I'll check that out. Thanks Chris, hadn't thought of doing it from the central server to the others, makes more sense. Then I can manage the query activity better.
  3. 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...
  4. EdLentz

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

    I appreciate the help. My last issue was inadvertantly self inflicted. I have it sorted out now. Thanks again
  5. EdLentz

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

    I spoke to soon and maybe it isn't this php file. I added the require and arranged the $htmlbody and ran the php script from the browser. I got the email with the info in a table just like I wanted it. I changed the info and tried again and I get nothing. I am also having issues with my...
  6. EdLentz

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

    Thanks that works out just fine
  7. EdLentz

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

    That sounds like a good idea. I'll give that a try Thanks
  8. EdLentz

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

    Thanks for the reply. No user input, the info is already in a table. I just want to put it in a table format ( 5 columns) and email it. I have a php script that writes it to a browser. I want to change that to email it. <html> <body> <?php $username = ""; $password = ""; $database =...
  9. 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
  10. 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>...
  11. EdLentz

    How do I use a keyword in a query??

    Now all I need to do is get this into a variable that I can use. I wish to use it in an email that I have setup. Seems like it should be easy. :)
  12. EdLentz

    How do I use a keyword in a query??

    I figured it out select `value` from `freepbx_settings` WHERE `keyword`='FREEPBX_SYSTEM_IDENT' Got me what I wanted. Thanks for the help Chriss!
  13. EdLentz

    How do I use a keyword in a query??

    Thanks Chriss I only tried Like because it was suggested in some searches I did select * from `freepbx_settings` WHERE `keyword`='FREEPBX_SYSTEM_IDENT' gives me the whole row of info. I just need the value in that row Thanks
  14. 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...
  15. EdLentz

    Need to compare two tables and list the differences

    I figured out how to use the trigger to update a table, Works sweet. Now to send an email telling of the new record. Thanks!
  16. EdLentz

    Need to compare two tables and list the differences

    Hi feherke Thanks for replying. I briefly looked up triggers. Looks interesting. That would tell me if someone inserted into the table for sure. I would also want to know "What" they inserted. I will try the except and see if I can make that work Thanks again Ed
  17. 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...
  18. 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...
  19. EdLentz

    Need help inserting array info into a table

    I finally got to the point where I get this as an output from my form page Array ( [extension] => Array ( [0] => 100 [1] => 101 [2] => 102 ) [secret] => Array ( [0] => a467ca4044f298eff15a26e59f39fe21 [1] => 0c4275de171ef363b77aa6aae27afff1 [2] => c1951bfb07ed6a833d6d785ff4e19123 ) [phone] =>...
  20. EdLentz

    Need help inserting array info into a table

    That code was something I found and tried to adapt to my situation. Obviously, I am to green at this to know when I should quit.

Part and Inventory Search

Back
Top