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 Chriss 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. DANDARSMASH

    Exporting to Excel using PHP

    @jpadie- I tried the first one, i don't think I tried the second. I'm not saying that it didn't work, it's just that I came across a different way that worked. Thanks for the help. "Any sufficiently advanced technology is indistinguishable from magic" [Arthur C. Clark]
  2. DANDARSMASH

    Exporting to Excel using PHP

    I was finally able to get it to work thanks to the code found Here. Thanks for all the help, I really appreciate it. "Any sufficiently advanced technology is indistinguishable from magic" [Arthur C. Clark]</td></tr></table>
  3. DANDARSMASH

    INTO OUTFILE Directory

    Hello. I'm doing an SQL query and converting it to XLS. When I run the query on the localhost DB, The file outputs to the specified location at C:/tmp/myfile.csv. However, when I run the query on the live DB, it outputs to the DB server at /home/mysql/csv/myfile.csv. As result, I can only...
  4. DANDARSMASH

    concatenate in SQL query

    As an independent query, the following works fine. It does not work when i plug it into my query in the previous post. SELECT CONCAT('/tmp/',DATE_FORMAT(curdate(), '%Y-%m-%d'),'letters.csv') AS your_date; "Any sufficiently advanced technology is indistinguishable from magic" [Arthur C...
  5. DANDARSMASH

    concatenate in SQL query

    Hello. I'm making a routine to run daily in SQL Workbench. I want the exported file to have curdate() added to the name for organizational purposes. SELECT d.emailaddress, d.fullname, d.address, d.city, d.state, d.zip, d.makepayabletoname, d.makepayabletoaddress...
  6. DANDARSMASH

    Exporting to Excel using PHP

    OK, I've found an even simpler way to do this. I can send an SQL query directly to a CSV file with the following PHP code. Problem is, I can't seem to get the syntax right. the lines ESCAPED BY '\\' and LINES TERMINATED BY '\n' have some special characters that i do not know how to escape...
  7. DANDARSMASH

    Exporting to Excel using PHP

    ugh... OK, it turns out that i was referencing a different export.php file that was already in the directory. This export.php gives me a whitescreen both with and without printing to excel. <table width="300" border="0"><tr><td><img src="http://3dgstudios.com/images/gorilla.jpg"></td><td>"Any...
  8. DANDARSMASH

    Exporting to Excel using PHP

    I checked the query in mySQL workbench, it works fine. That is passed as a value for 'query'. I removed the stripslashes() because it didn't seem necessary. Still getting nothing in the excel export except "
  9. DANDARSMASH

    Exporting to Excel using PHP

    Hello all- I'm trying to export to excel from a php mysql_query. It opens excel, but all i get is "  " in Cell A1. <?php $str='select d.emailaddress, d.fullname, d.address, d.city, d.state, d.zip, d.makepayabletoname, d.makepayabletoaddress, d.makepayabletocity, d.makepayabletostate...
  10. DANDARSMASH

    Exporting to Excel

    @jpadie- yes, thanks. We decided to go with a slightly different method; pulling directly from the DB to excel. It cut out several languages that didn't need to be there.
  11. DANDARSMASH

    Exporting to Excel

    @jpadie- that opens up the excel application, so thanks. @Diancecht- no yellow warning at all.
  12. DANDARSMASH

    Exporting to Excel

    I am not getting any error, clicking the link does nothing at all. Here is a screenshot, all of the settings are at their lowest.
  13. DANDARSMASH

    Exporting to Excel

    I'm trying this in firefox, chrome, and ie. I'm running Windows 7. Excel is installed, and I am an administrator (all permissions)
  14. DANDARSMASH

    Exporting to Excel

    Hello, I modified the code from here but i can't get it to work on my site. the only thing i changed was the id of the table: tbl2013-06-03 function write_to_excel() { str=""; var myTable = document.getElementByID('tbl2013-06-03'); var rows = myTable.getElementsByTagName('tr')...
  15. DANDARSMASH

    JavaScript Expand/Collapse

    The issue has been resolved. I converted my echo statements to html; making php the exception rather than the rule. <td colspan="1"><a href="javascript:toggle_visibility('<?php echo $tblName;?>' , '<?php echo $lnkName;?>');"> <div align="right" id="<?php echo $lnkName; ?>" name="<?php echo...
  16. DANDARSMASH

    JavaScript Expand/Collapse

    Thank you Feherke. Please excuse the bad code, I pulled that from a website somewhere. tr style="display: none" does hide the rows as intended, but the expand/collapse link doesn't work. Any suggestions?
  17. DANDARSMASH

    JavaScript Expand/Collapse

    Hello. I'm trying to implement this into my site. function toggle_visibility(tbid,lnkid) { if (document.getElementsByTagName) { var tables = document.getElementsByTagName('table'); for (var i = 0; i < tables.length; i++) { if (tables[i].id == tbid){ var trs =...

Part and Inventory Search

Back
Top