please help me cause I am totally lost on this one. I am trying to fetch the results from a database that has the data inserted in a weird way. The IDs are not unique, thus I have multiple values with the same ID in the ID column. I am trying to group these IDs and output the Values for those IDs on a single Row. Right now my code outputs the values aligned in a column associated with their ID. The database was generated by this by one of the client's scripts and it is a huge (limited only …

Member Avatar
Member Avatar
+0 forum 2

Hi everyone, How are you? Starting some thread after long time :) Actually, I have a group of 25 people. I have 20-25 mobile devices in my group. So, I have assigned 1-2 device on each person's name(as an owner). But, people in the group ask each other for the device for some help and promise to return it too. They may need specific device for some work which is a genuine thing. But, they forget to return it & person who gave has to ask on emails or each person where his/her device is. Problem: Asking on emails is …

Member Avatar
Member Avatar
+0 forum 1

how to send mails individually instead of sending to all recipients together? my code is: function SendMail($msg,$subject,$addresses) { require "class.phpmailer.php"; //Fetch from email here foreach($addresses as $key=>$val){ $email = test_input($val); if((trim($email)=='') || (!filter_var($email, FILTER_VALIDATE_EMAIL))){ unset($addresses[$key]); } } $addresses=array_unique($addresses); $row = FetchAllsettingsCustomMailchmp(); //end fetch $mail = new PHPMailer(); $mail->PluginDir = ""; $mail->Host = "localhost"; $mail->From = $row['email_from']; $mail->FromName = $row['sitename']; $mail->Subject = $subject; foreach ($addresses as $address) $mail->AddAddress($address); $mail->MsgHTML($msg); $mail->IsHTML(true); $mail->AltBody ="Order"; $mail->CharSet = 'UTF-8'; $success = $mail->Send(); $try = 1; while((!$success)&&($try<1)&&($mail->ErrorInfo!="SMTP Error: Data not accepted")) { sleep(5); $success = $mail->Send(); $try++; } $mail->ClearAddresses(); if(!$success) return false; else return true; } …

Member Avatar
+0 forum 0

hello all of you, I dont know whether i am putting THIS SUBJECT in the proper place or not. @admin if this is placed at wrong place then just cut and paste to original place. LOGO - I want the new ideas on creating the logos. I have the group which is ccreating the song and showing the video ( RAP ) Now here i am the video editor but I have to design the proper LOGO. My group name is : TDC (The Dreams Connect) We are also on Youtube > just release the first song still but we …

Member Avatar
Member Avatar
+0 forum 4

What are the Benefits of Google Analytics

Member Avatar
Member Avatar
-1 forum 23

We're in the process of upgrading/improving our application framework, and we're currently looking into (application) user groups and roles. We want to implement CRUD rights to our screens. What's in place is a kind of ORM, so there's a class for each table already. Am just looking for ideas on how to get this built as generic as possible.

Member Avatar
Member Avatar
+0 forum 9

Hello, so I was trying few relations between tables and I noted an unexpected behaviour when using `group_concat()`. Let say I have three tables: fruits, fruitstock and fruitprices. These are the structures: create table fruits ( id tinyint unsigned not null auto_increment primary key, name varchar(50) not null, quality varchar(50) not null ) engine = myisam default charset = utf8; create table fruitstock ( id tinyint unsigned auto_increment primary key not null, fruit_id tinyint unsigned not null, quantity tinyint unsigned not null default 0 ) engine = myisam default charset = utf8; create table fruitprices ( id tinyint unsigned not …

Member Avatar
Member Avatar
+1 forum 1

Can any one tell me what are the new trends in e-commerce

Member Avatar
Member Avatar
-1 forum 1

Problem with group box. I had created a groups box. With objects inside it with small spaces between each. But when I run the program. The spaces of the objects inside the group box became large. Picture one shows the design phase. Pcture two shows the running phase.

Member Avatar
Member Avatar
+0 forum 2

Hey guys, New to the site, new to writing SQL queries and have no background in this type of thing. But I've been googling my way to victory for the most part. I'm struggling on probably a very simple problem. I'd like to Sum the contents of a column, if a different value in the row is the same as in another... That was worded horribly - how about an illustration: Seq Unit ID Value 1 1 1000 2 1 100 3 11 300 4 11 1000 5 11 110 6 11 300 7 3 999 8 3 1 9 …

Member Avatar
Member Avatar
+0 forum 10

I have a CTE based query, to which I pass about 2600 4-tuple latitude/longitude values using joins - these latitude longitude 4-tuples have been ID tagged and held in a second table called coordinates. These top left and bottom right latitude / longitude values are passed into the CTE in order to display the amount of requests (hourly) made within those coordinates for given two timestamps).- I am able to get the total requests per day within the timestamps given, that is, the total count of user requests on every specified day. (E.g. user opts to see every Wednesday or …

Member Avatar
Member Avatar
+0 forum 1

I have just set up a server at a local youth club, im fairly new to networking, although i do know alot considering i only started in july. I have set up ADDS on a windows Server 2008 R1 (vista) machine, i have loaded so far, 5 client PC's to the domain, all running Windows 7 Pro. I need to lock an account down, and i made a group policy outlining what i want blocked and whats ok to access, and ive added the users, and the computer to the GP so it *should* go through, but it isnt. All …

Member Avatar
Member Avatar
+0 forum 5

I have a table with these columns: stockNumber, storageID, lastPutDate, qtyOnHand Each stockNumber can have multiple storageID's but only one lastPutDate and qtyOnHand for each storageID. Here is an example of what the rows might look like: stockNumber storageID lastPutDate qtyOnHand ----------- --------- ----------- --------- 100505 R010101 2012-10-18 150.00 100505 R010102 2012-10-17 75.00 100505 R010103 2012-11-10 97.00 100125 R020101 2012-11-12 200.00 100125 R020204 2012-9-17 500.00 30222 R030101 2012-12-2 63.00 I'm trying to figure out the correct query to end with this result: stockNumber storageID lastPutDate qtyOnHand ----------- --------- ----------- --------- 100505 R010101 2012-10-18 150.00 R010102 2012-10-17 75.00 R010103 2012-11-10 97.00 …

Member Avatar
Member Avatar
+0 forum 4

Hi, i have to write/as homework/ a script that shows list of all users ,users belong to group (which is main group for every user has been showed) defined as parameter of script. In the case of -c, show count of those users. TIP: /etc/passwd, /etc/group

Member Avatar
Member Avatar
+0 forum 4

Hi, I am attempting to draw graphics on a PowerPoint slide. Say I draw a line and a rectangle. What code do I add to the function to have those objects group together? Thanks, Ken

Member Avatar
+0 forum 0

Need help with JTable header group : Exception in thread "AWT-EventQueue-0" java.lang.ClassCastException: javax.swing.table.JTableHeader cannot be cast to id.co.aal.common.GroupableTableHeader this is the part of table drawing ..... if(tabledraw) { tabledraw=false; for (int k = 0; k < m_data.getColumnCount(); k++) { TableCellRenderer renderer; if (k==Kehadirantable.COL_ALOKASI) renderer = new CheckCellRenderer(); else { DefaultTableCellRenderer textRenderer = new DefaultTableCellRenderer(); renderer = textRenderer; } TableCellEditor editor; final TableCellEditor comm = null; JComboBox cmb=new JComboBox(CATEGORIES); if (k==Kehadirantable.COL_KODE) { editor = new DefaultCellEditor(cmb); } else if (k==Kehadirantable.COL_ALOKASI) editor = new DefaultCellEditor(new JCheckBox()); else editor = new DefaultCellEditor(new JTextField()); TableColumn column = new TableColumn(k,m_data.m_columns[k].m_width,renderer, editor); tblKehadiran.addColumn(column); tblKehadiran.getColumnModel().getColumn(k).setResizable(false); } TableColumnModel …

Member Avatar
Member Avatar
+0 forum 1

I have a query in which I need to display some group function figures SUM COUNT etc from a joined table. I also need to select the latest version (by datetime) of a matching record from a separate table, which I can do using an ordered subquery in the join. My issue is that the group functions appear to be joining on every row in the subquery (not just the latest one) and thus displaying incorrect inflated results of the SUM/COUNT functions. So I guess what I'm looking for is one of the following: 1) a better way to do …

Member Avatar
Member Avatar
+0 forum 3

Good Morning, I have an ever growing member database that is currently at around 6000 (developed over the past 2 weeks), and expect it to be in the hundreds of thousands within a few more weeks... My problem is that alot of members are using a single email address for multiple members, and I would like to limit the emails that we send out to just 1 per email address to save on the email load and time... Here is my query: SELECT user, pass, email FROM members WHERE mem_status <>'T' ORDER BY email asc"; What do I need to …

Member Avatar
Member Avatar
+0 forum 3

Please advise me, to this following group function in PHP. this works perfectly fine,it groups the airline name and starts with the MIN price, however the problem is that it also shows the season but it is picking the MIN season which is not required. I want it to pick the season for the MIN price which it applies for in the same row. the code is below...all help is much appreciated...thank you in advance: [CODE]$sql="SELECT MIN(price),dep,des,airline,flighttype,baggage,season,cabin,id FROM faresheet WHERE cabin = '".$q."' AND des = 'DEL' GROUP BY airline ORDER BY MIN(price) ASC";[/CODE]

Member Avatar
Member Avatar
+0 forum 5

[CODE]----------------------------------------------------------- chan1 |chan2 |chan3 | captureTime |id ----------------------------------------------------------- 20 |21 |25 | 2011-10-11 00:00:00 |1 ----------------------------------------------------------- 21 |18 |19 | 2011-10-11 00:01:00 |1 ----------------------------------------------------------- .... .... .... ----------------------------------------------------------- 20 |25 |21 | 2011-10-11 00:15:00 |1 ----------------------------------------------------------- 21 |18 |14 | 2011-10-11 00:16:00 |1 .... .... .... ----------------------------------------------------------- 15 |26 |23 | 2011-10-11 23:58:00 |1 ----------------------------------------------------------- 17 |14 |32 | 2011-10-11 23:59:00 |1[/CODE] The table store chan1,chan2 and chan3 value every one minute. I want to get the maximum & minimum values for every 10 minutes and also have the corresponding the captureTime for min/max values. Based on those requirments, How …

Member Avatar
Member Avatar
+0 forum 1

I couldnt find a forum for sql so Im going to post here. If Im in the wrong forum then please move me. I have a table with following data Fields: OID, Product, Condition, QTY DATA: 1, Product A, NEW, 60 2, Product A, B, 60 3, Product A, C, 40 4, Product B, NEW, 30 5, Product B, C, 20 I want to write my procedure so that when I execute it, it will return a table as such. Product Name, NEW, B, C Product A, 60, 60, 40 Product B, 30, 0, 20 [ICODE]SELECT PRODUCT,(CASE WHEN CONDITION LIKE …

Member Avatar
Member Avatar
+0 forum 1

This is homework. I was writing a bash script that accepts a list of group names on the command line and produces a group report detailing the group id and the number of group members identified in /etc/passwd for each group. Output will look like: Group Report Group GID Count ------ ----- ------ css 301 439 faculty 300 78 To try and get this, I use several loops to go through the files and if statements as comparisons. Here is my code: [CODE]#!/bin/bash FILENAME=/etc/passwd FILENAME2=/etc/group UIDMAX=1000 echo -e "\tGroup Report" echo echo "Group GID Count" echo "------- ------- -------" for …

Member Avatar
Member Avatar
+0 forum 2

hey guys.. i have trying for 2 weeks now to connect 2 tables in the way that i need them to print out.. [B]to understand the table structure please see attachment 001[/B] Now... i have managed to join both table but the problem is that each time i insert a new recipe in creates a new completley seperate table and i want all the recipes that belong to "some recipe website" to apear in the same table of the right recipe website. [B]to understand my problem please see atachment 002[/B] in attachment 002 its also clear to see i need …

Member Avatar
Member Avatar
+0 forum 6

I need help. I am very illiterate in Python and the like and I have a chunk of code that checks to see if a page updates and then posts it onto a forum. I need to alter it (hopefully) to check to see if an RRS feed is updated and post it in a different format. So what I need help with is to change it to check to see if an RRS feed is running. Log in to [URL="https://store.steampowered.com/login/"]https://store.steampowered.com/login/[/URL] and once it logs in access a groups announcement page so lets say this url [URL="http://steamcommunity.com/groups/vancouvercanucksregistered/announcements"]http://steamcommunity.com/groups/vancouvercanucksregistered/announcements[/URL], when you are …

Member Avatar
Member Avatar
+0 forum 1

If someone could help, that would be great.... Ok i want the data to be displayed together.... eg. 'week 1' displayed once then all the matches in a single table below, then prints 'week 2' follwed by the matches in the following table rather than continually stating 'week 1' and a new table for every match? Any ideas?[code]$query = "SELECT week, home, away FROM fixtures ORDER BY week ASC"; $results = mysql_query($query); while(list($week, $home, $away)= mysql_fetch_row($results)) { echo " <br> <strong> $week </strong>" ."<table> <tr> <th> Home Team </th> <th> </th> <th> Away Team </th> </tr> <td>$home </td>" . " …

Member Avatar
Member Avatar
+0 forum 3

From help I received yesterday I have this code that will parse through an XML file generating an output from various nodes based on the relationships between them. Example XML [CODE] <gedcom> <INDI ID=@I001@> <FAMC>@F001@</FAMC> ... </INDI> <INDI ID=@I002@> <FAMC>@F002@</FAMC> ... </INDI> <INDI ID=@I003@> <FAMC>@F003@</FAMC> ... </INDI> ... <FAM ID=@F001@> <HUSB>@I002@</HUSB> <WIFE>@I003@</WIFE> ... </FAM> <FAM ID=@F002@> <HUSB>@I004@</HUSB> <WIFE>@I005@</WIFE> ... </FAM> <FAM ID=@F003@> <HUSB>@I006@</HUSB> <WIFE>@I007@</WIFE> ... </FAM> ... </gedcom> [/CODE] The way this data works is an individual [INDI] record is related to a family [FAM] record by the id value of its family child [FAMC] node. The family record then …

Member Avatar
Member Avatar
+0 forum 1

hi, assume data looks like this: cell Bit 0 1 1 X 2 1 3 0 4 X 5 X 6 X 7 X 8 1 9 X 10 0 11 0 12 X 13 X 14 1 15 1 And i want to group 4 bits into each group such as: ROW1=01X1 ROW2=XXXX ROW3=00X1 ROW4=11XX how to do this? thanks

Member Avatar
Member Avatar
+0 forum 12

Hi, I have searched high and low and cant find a similar issue to what i have. I am a beginner so please forgive my clunky query structure. I am trying to: ( have attached screen grab below ) Query the [B]photos table[/B] to get the id based on category id and also start,limit because of pagination. Query the [B]photos tagged table[/B] based on the photo id i just got from the first query. But my problem is that i cant group the tags, some photos have the same tag name. And the output just shows all the tags for …

Member Avatar
Member Avatar
+0 forum 1

I have written the title as “Script to Group Values” for lack of a better title. I want to have a MySQL database that receives value from a form on a webpage. For example, I have people signing up for an event. I want to create something (probably in PHP but I have no idea if it can do it) that can take each of the people who are applying for the event and place them in a room. Each person will have certain requirements or variables that must be met such as who they request to room with, male …

Member Avatar
+0 forum 0

Is there a way to add a user to a group in J2EE dynamically (using glassfish btw)? If so, is there a away to have a user in a group called members to be promoted to an admin group. Thanks in advance

Member Avatar
+0 forum 0

The End.