- Upvotes Received
- 3
- Posts with Upvotes
- 1
- Upvoting Members
- 3
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
13 Posted Topics
 | start your research with "Using jQuery to change classes, properties, etc." http://www.sitepoint.com/change-css-jquery/  |
| | The best wsy to start your DB design is by answering two question: 1. How will the data be queried? 2. have a normalized the data as much as possible (ie. remove duplicates or simplify to the lowest level) If you only need to query the indovudal meters then you … |
| | That is most likely your ftp host name, which is different than your site url and usually like: ftp.xyz.com |
| | Re: losing my mind You may have seen this already in doing your research, but there might be a solution [here](http://stackoverflow.com/questions/9032676/nested-ul-li-to-php-array-incorrect-output-in-array). Ill keep looking.  |
 | I need some clarification, but happy to help. Where do you want to add the message? Are you updating the DB table or writing it to the screen? |
| | Use LOAD DATA INFILE - it has an option to ignore the X number of first lines. http://dev.mysql.com/doc/refman/5.1/en/load-data.html [Example](http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server) |
| | I am using the following query (thank you diafol) to group the top N rows in my data set: SELECT mgap_ska_id,mgap_ska_id_name, account_manager_id, mgap_growth AS growth,mgap_recovery, (mgap_growth+mgap_recovery) total FROM (SELECT mgap_ska_id,mgap_ska_id_name, account_manager_id, mgap_growth, mgap_recovery,(mgap_growth+mgap_recovery) total, @acid_rank := IF(@current_acid = account_manager_id, @acid_rank + 1, 1) AS acid_rank, @current_acid := account_manager_id FROM mgap_orders … |
| | So I have been working with a csv export for a few days now and I have the data almost in the form I need it in. I need some advice on how best to proceed to get to the soltuion I need. Here is the problem: My csv export …  |
 | Ive had this happen differently in different browsers. I do belive the webkit browsers (it might be just then opposite btw) will not print the bgcolor via the dom. |
| | Im using the following query with LOAD DATA INFILE: "LOAD DATA LOCAL INFILE 'file.csv' INTO table mgap_export FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 3 LINES (@dummy,@dummy,@dummy,@dummy,Full_Name,gt_accountMgrID,Email_Address,mgap_ska_id,@gtdashboardLink, @gt_rankingLink, @gt_analyticsLink) SET gtdashboardLink=CONCAT('http://www.url.com/logind.php?id=',gt_accountMgrID), SET gt_rankingLink=CONCAT('http://www.url.com/logind.php?id=',gt_accountMgrID)"; If I remove the last variable the query works just fine, … |
| | I am using the following [sample code](http://www.coderelic.com/2012/01/export-data-from-a-database-to-csv-excel-with-php/) to export a query to a csv file: <?php // Connect and query the database for the users $conn = new PDO("mysql:host=localhost;dbname=mydatabase", 'myuser', 'mypassword'); $sql = "SELECT username, email FROM users ORDER BY username"; $results = $conn->query($sql); // Pick a filename and destination … |
| | I have the following data in a table called 'customers': accmanid custid billone billltwo 1 1 126.9 514.6 1 2 264.73 108 1 3 130.5 514.6 1 4 137.82 514.6 2 10 126.9 514.6 2 11 126.9 375.48 2 12 126.9 117.55 2 13 126.9 261.66 3 19 130.5 117.55 … |
| |  I have cretaed the data set above with a query and now I need to export ONLY a portion of it to a .csv file with PHP. The higlighted portions in the images are what needs to be exported to a .csv file. Basically, each time an account_manager_id … |
The End.