Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
100% Quality Score
Upvotes Received
3
Posts with Upvotes
1
Upvoting Members
3
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
0 Endorsements
Ranked #3K
~7K People Reached
Favorite Tags
Member Avatar for minghags

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 …

Member Avatar for Benjamin_11
0
219
Member Avatar for hanvyj

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 …

Member Avatar for hanvyj
0
258
Member Avatar for ankit1122

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

Member Avatar for almostbob
0
175
Member Avatar for iamthwee

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 …

Member Avatar for pritaeas
0
264
Member Avatar for jKidz

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 …

Member Avatar for Benjamin_11
0
177
Member Avatar for chaitu11

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 …

Member Avatar for Benjamin_11
0
3K
Member Avatar for Benjamin_11

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 …

0
117
Member Avatar for Benjamin_11

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 …

Member Avatar for hericles
0
174
Member Avatar for Ritesh_4

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?

Member Avatar for almostbob
0
2K
Member Avatar for Benjamin_11

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, …

Member Avatar for Benjamin_11
0
215
Member Avatar for Benjamin_11

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 …

Member Avatar for iamthwee
0
300
Member Avatar for Benjamin_11

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 …

Member Avatar for diafol
0
149
Member Avatar for Benjamin_11

![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 …

0
94