My query doesn't work. What can I do? I would like to display a &lt;table&gt; with these &lt;th&gt;-s: project title description status start date end date users  The problem is, that my subquery returns more than 1 row. Usually 4 people belong to a project, an owner, a manager, a developer and a tester. The owner can create new projects, so he can see the project table I would like to create, but I can't put the users at the end of the table, because more than one belongs to every row.   This is the query:  SELECT project.id, title, description, status, start,end         FROM project          LEFT JOIN users ON (SELECT userid FROM roles,project WHERE projectid=project.id)=users.id   My tables are:  PROJECT id title description status start end  USERS id name pass email  ROLES id projectid userid rolename
Can I concatenate multiple MySQL rows into one field? Using MySQL, I can do something like:  SELECT hobbies FROM peoples_hobbies WHERE person_id = 5;   My Output:  shopping fishing coding   but instead I just want 1 row, 1 col:  Expected Output:  shopping, fishing, coding   The reason is that I'm selecting multiple values from multiple tables, and after all the joins I've got a lot more rows than I'd like.  I've looked for a function on  and it doesn't look like the CONCAT or CONCAT_WS functions accept result sets.  So does anyone here know how to do this?
rent a car, rent out a car, hire a car English not my native language. I'm trying to understand what would be correct in British English.  If I want to use a car for some time. I can say, "I want to rent a car". But from my knowledge there may be a  misunderstanding. I can say the same words if I want to give a car to someone to use for some time and I want to receive payment.  So what would be correct and not misunderstanding?   1) I want to use a car for some time = "I want to hire a car" 2) I want to give a car to someone to use for some time = "rent out a car"   Is my understanding correct? Is there a command where I can teleport myself to a specific kind of block? I can't find my house and I have specific kind of blocks in it like beacons, enchantment tables, furnaces, stuff like that. I didn't put a bed and I never viewed the coordinates. I remember that the main character is trying to find the group that destroyed his home planet while he was on a mission. His planet was very difficult to live on and the people became expert in martial arts and were the best soldiers in the galaxy. They were mercenaries and often helped against tyrants. There was a very memorable section in at least one book about an initiation task that the main character had to do in that he had to survive in their wilderness for days. He was at some point surrounded in a old building by thousands of poisonous worm/snake creatures that he managed to survive until rescued by the leaders. What is the rule for adjective order? I remember being taught that the correct order of adjectives in English was something along the lines of "Opinion-Size-Age-Color-Material-Purpose."  However, it's been a long time and I'm pretty sure I've forgotten a few categories (I think there were eight or nine). Can anyone fill them in? Ubuntu does not offers me "install alongside Windows" Any of the partitions makes in Windows was not recognised by Ubuntu, or Zorin OS, or LinuxMint. It's like a blank hard disc, 250 gb free. I'm a new Linux user, but what confuses me is that I was able to install Ubuntu alongside Windows on my laptop with no problems, but on PC... no way! Is there a travelling speed of for electric field? If yes, what is it? Consider two circuits containing a battery, bulb, switch and conducting wires but of length 1 meter in one case and 1000KM in other. When switched on at the same time both the bulbs glow instantaneously. I think it is because, electric filed travels from positive terminal of battery to negative terminal through wire almost instantaneously.  My question is there any speed for this electric field? If yes, what is it? By any modification in this circuit is it possible to induce any delay in glowing the bulb? To EAV or not to EAV? create multilingual node programmatically i'm trying to create a multilingual node using a php script.  I'm doing this:   $node = new stdClass();  $node-&gt;title = "Test ".mktime();  $node-&gt;type = "job";  $node-&gt;language = 'de'; // Or e.g. 'en' if locale is enabled  $node-&gt;uid = $user-&gt;uid;   $node-&gt;status = 1; //(1 or 0): published or not  $node-&gt;promote = 0; //(1 or 0): promoted to front page  $node-&gt;comment = 1; //2 = comments on, 1 = comments off  $node-&gt;path = array('alias' =&gt; 'das-ist-ein-test-'.mktime());  $node-&gt;body[$node-&gt;language][0]['value']   = "Body Body Body";  $node-&gt;body[$node-&gt;language] = text_summary("Body Body Body");  $node-&gt;body[$node-&gt;language]  = 'filtered_html';  node_save($node);   As long as i set $node->language to 'und' everything is working fine. But as soon as I set the language to 'de' or 'en' (both languages are activated in my Drupal installation) the body text doesn't get saved.  So my question is: can anybody provide me with a working example of how to store a multlingual node (de,en) into Drupal using program code.  Thank you Where can I find free elevation data for Europe?   The available resolutions and terms of use are important details that I also seek. What is the resolution I need to make a picture to make curves look smooth and not pixelated? When I start up Ubuntu 16.04 some applications take too long to run the first time I open them, including Chrome and any PDF viewer. Others, like nautilus, start up immediately.  The first time I try to use a PDF viewer like okular, it takes too long to open. After it opens a PDF file for the first time, other files open quickly. Even if I close all and open some after a long time, it happens quickly.  How can I speed up these programs opening on the first run? How can I automatically enable large text when logging in to the ubuntu session? Is it possible for a system to have negative potential energy? With respect to both gravity and electromagnetism, to the best of my understanding potential energy is added or subtracted from a system based on the distance between two objects such as charged or massive objects.  Would this then imply that when oppositely charged objects or two massive objects are brought together within a small enough radius that the drop in potential energy would be greater than the combined mass of the two objects making the net mass/energy of the system negative? curlicue letters with mathptmx package How to show letters like  with mathptmx package?  I'm using pdfLaTeX with mathptmx package becasue its gooding looking normal math font letters a-z, A-Z. However, if only with this package, \mathsrc{...} is reported as "undefiend sequence" and \mathcal{...} is curlicue style like the following:  \mathcal{F} shows . If I add \usepackage{mathrsfs}, \mathcal{F} and \mathscr{F} are the same as .  What I expect is \mathcal{F} shows  and \mathscr{F} show the one in previous line.   What should I adjust? I hope mathptmx package is still being used.  Minimal code script goes like that:  % using PdfLaTeX \documentclass[journal]{IEEEtran} \usepackage{amssymb,amsmath,amsfonts} \usepackage{mathptmx}  \usepackage{mathrsfs} \begin{document} $$\mathcal{F}$$ $$\mathscr{F}$$ they are the same \end{document} Active Web Site as Gnome Background Is there a way to put an active website, such as Gmail, as your Desktop background in Gnome, running Ubuntu 10.10 64-bit? MS Win calls it "Active Desktop". I wonder whether there is any automatic way of determining (at least roughly) the Big-O time complexity of a given function?  If I graphed an O(n) function vs. an O(n lg n) function I think I would be able to visually ascertain which is which; I'm thinking there must be some heuristic solution which enables this to be done automatically.  Any ideas?  Edit: I am happy to find a semi-automated solution, just wondering whether there is some way of avoiding doing a fully manual analysis. Is it possible to assign a base class object to a derived class reference with an explicit typecast in C#?.  I have tried it and it creates a run-time error. SQL query to convert columns into rows Here is an interesting piece of code that my fellow team members were just having a slightly heated discussion about...    Dim fred As Integer    If True Then fred = 5 : fred = 3 : fred = 6 Else fred = 4 : fred = 2 : fred = 1   After executing the above code snippet, what is the value of fred?  Try not to cheat and debug the code.  This is a highly contrived code example that started out as an example of using the colon with an If statement, but then someone decided to take it upon themselves to proffer a result for fred.  UPDATE: I would not normally write code like this and this snippet only serves as an example. As it so happens, this question originated from a discussion involving the creation of a coding standards document for our team. I do not have much experience in table design. My goal is to create one or more product tables that meet the requirements below:   Support many kinds of products (TV, Phone, PC, ...). Each kind of product has a different set of parameters, like:   Phone will have Color, Size, Weight, OS... PC will have CPU, HDD, RAM...  The set of parameters must be dynamic. You can add or edit any parameter you like.   How can I meet these requirements without a separate table for each kind of product?