- Upvotes Received
- 3
- Posts with Upvotes
- 1
- Upvoting Members
- 3
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
Re:
I need to create 3-4 buttons that are colored when pressed, but when one button is pressed it turns for example red other ones become grey. But this must happen on the same site like selection for example. I didnt maanage to do anything till now, if someone could just … |
|
Re:
A warning: I'm very new to databases! Hopefully this will be a pretty simple question. To simplfy my problem, I have a tree of 'meters' that collect data (Let's say electricity meters). I'd normally structure this with objects in a tree, each with a list or some kind of array … |
|
Re:
hello i use https://netbeans.org/kb/docs/php/remote-hosting-and-ftp-account.html to make changes directly to my website from netbeans but it doesn't work... can anyone tell me about what to fill in hostname?? i used my websites name .....www.gigname.com |
|
|
Re:
Right, I've searched all day long, html2array, html to json, html dom parser blah blah and I am struggling with this seemingly simple code. I have the following html: <ul> <li>menu1</li> <li>menu2 <ul> <li>menu2.1</li> </ul> </li> <li>menu3</li> </ul> And I need to convert them to a parent child relationship. Or … |
Re:
Hi Guys, I am developing a Music Database system. This is a 'Song.php' page. It will be a Detailed page of a each song. Ex : song.php?id=1 <?php if(!empty($_GET['id'])) { $sid = mysql_real_escape_string ($_GET['id']); } // if song id is null, user will redirect to the full song list else … |
|
Re:
I have attached an image file i want to escape first there rows and import data from sudha---- if(isset($_POST['submit'])) { $account_type = $_POST['account_type']; $fname = $_FILES['sel_file']['name']; echo '<center class=green>Uploaded file name is: '.$fname.'</center> '; $chk_ext = explode(".",$fname); if(strtolower(end($chk_ext)) == "csv") { $filename = $_FILES['sel_file']['tmp_name']; $handle = fopen($filename, "r"); fgetcsv($handle); //skip … |
|
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 … |
|
Re:
Hello Am using the window.print function on a page, but it does not print the background color which I've set in my stylesheet for table cells. Any way to fix this issue? |
|
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 … |
|
![c68bc2737304743859f031861c0e27ae](/attachments/large/4/c68bc2737304743859f031861c0e27ae.png "c68bc2737304743859f031861c0e27ae") 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 … |