$query = "SELECT * FROM makale ORDER BY date ASC";     how can I add another ORDER after date ...?  I want rows ordered by dates and if same dates will be ordered by name ?  How can I do that?
How do I sort a MySQL table by two columns? What I want are articles sorted by highest ratings first, then most recent date.  As an example, this would be a sample output (left # is the rating, then the article title, then the article date)  +================+=============================+==============+ | article_rating | article                     | article_time | +================+=============================+==============+ | 50             | This article rocks          | Feb 4, 2009  | +----------------+-----------------------------+--------------+ | 35             | This article is pretty good | Feb 1, 2009  | +----------------+-----------------------------+--------------+ | 5              | This Article isn't so hot   | Jan 25, 2009 | +================+=============================+==============+  The relevant SQL I'm using is: ORDER BY article_rating, article_time DESC  I can sort by one or the other, but not both.
I think it would be nice to have a "friends list" on Stack Overflow. This would allow us to be able to follow the questions and answers that are posted by users that we want to watch/monitor.  I suggest it be implemented in the same fashion as DotNetKicks.com; where you can add someone to your "friends list" without them needing to approve you the way that other social networks do it. It should be completely open for us to add anyone to our "friends list" that we like. I was getting the usual 4-8mbps in 12.04 when copying files via usb sticks. However after upgrading to 12.10, I only get 200-300kbps when I try to perform the same operation.   I have tried different usb sticks (which work flawlessly on Windows 7) and still experience the same issue. I experienced the same issue sometime ago on 11.10 but everything was normal when I upgraded to 12.04 so it might be a kernel issue.  Here's the output of dmseg |tail:      mysterio@mysterio-HP-Pavilion-dv6700-Notebook-PC:~$ dmesg |tail   [  871.023093] sdb: sdb1  [  871.026909] sd 5:0:0:0: [sdb] No Caching mode page present  [  871.026920] sd 5:0:0:0: [sdb] Assuming drive cache: write through  [  871.026927] sd 5:0:0:0: [sdb] Attached SCSI removable disk  [ 1036.226206] ISO 9660 Extensions: Microsoft Joliet Level 3  [ 1036.233561] ISO 9660 Extensions: RRIP_1991A  [ 1086.342973] ISO 9660 Extensions: Microsoft Joliet Level 3  [ 1086.343010] ISO 9660 Extensions: RRIP_1991A  [ 1173.971357] ISO 9660 Extensions: Microsoft Joliet Level 3  [ 1173.971441] ISO 9660 Extensions: RRIP_1991A   I have updated my system with the latest updates. What could be wrong? Show that if $n$ is not divisible by $2$ or by $3$, then $n^2-1$ is divisible by $24$.   I thought I would do the following ... As $n$ is not divisible by $2$ and $3$ then $$n=2k+1\;\text{or}\\n=3k+1\;\text{or}\\n=3k+2\;\;\;\;$$for some $n\in\mathbb{N}$. And then make induction over $k$ in each case.$$24\mid (2k+1)^2-1\;\text{or}\\24\mid (3k+1)^2-1\;\text{or}\\24\mid (3k+2)^2-1\;\;\;\;$$This question is in a text of Euclidean Division I'm reviewing, and I wonder if there is a simpler, faster, or direct this way. Which graphics cards are supported by the new AMDGPU driver in Ubuntu 16.04? The new open source AMDGPU driver pre-installed in Ubuntu 16.04 should support all the "Volcanic Islands" cards out-of-the-box. This means that AMD Radeon R9 285, R9 380/380X and R9 Fury/FuryX graphics cards will be supported out-of-the-box if Ubuntu 16.04 LTS is installed.  However I read that the open source AMDGPU driver has an experimental support for the "Sea Islands" graphics cards (HD7790, R7 260, R9 290, R7 360, R9 390). Is this support enabled by default on Ubuntu 16.04, or will these graphics cards use the Radeon driver?  Thanks What is the difference between $* and $@? Consider the following code:  foo () {     echo $* }  bar () {     echo $@ }  foo 1 2 3 4 bar 1 2 3 4   It outputs:     1 2 3 4       1 2 3 4   I am using Ksh88, but I am interested in other common shells as well. If you happen to know any particularity for specific shells, please do mention them.  I found the follwing in the Ksh man page on Solaris:     The meaning of $* and  $@  is   identical  when  not  quoted  or  when  used  as a parameter   assignment value or as a file name. However, when used as  a   command argument, $* is equivalent to ``$1d$2d...'', where d   is the first character of the IFS variable,  whereas  $@  is   equivalent  to  $1 $2 ....   I tried modifying the IFS variable, but it doesn't modify the output. Maybe I'm doing something wrong? I am currently running Ubuntu 11.10 off of a SanDisk 16GB USB. I installed it using a Live USB with the following partition configuration:  6GB Primary /dos   FAT32 5GB Logical /      ext4 5GB Logical /home  ext4   I don't have a hard disk, and don't see myself getting one anytime soon.   I rely solely on this 16GB, and two other 4GB USBs, one of which I used as the LiveUSB. I bring the USBs around, and even use the install at work.   I previously used an install that used a swap file. It functioned fine for the most part, save for a few slow moments, but I came across , and it got me thinking about my USB's life, so I reinstalled with the current config.   My problem now is that it is slower. Applications like Firefox would hang more often. In my previous setup (the automatically partitioned setup), Firefox would start hanging if I was running an unzip or install task on the same partition as /.   Now however, it would hang if I had another window open i.e. the system settings window. My guess is that it may have something to do with the swap file or the install being on a Logical partition rather than a Primary partition, but I don't know.   Any insight as to why it has slowed down? Logitech LS21 recognized as 2.0 system - Windows 8.1 doesn't detect Subwoofer I got my dad a Logitech LS21 system for Christmas. It's a 2.1 system, but it's recognized in Windows 8 as a 2.0 system (it says there is no subwoofer connected).    How would I go about getting the sub recognized?  It plays some sound now, but it's so quiet you can't hear it without putting your ear right next to it. "Access denied" when trying to end a process on Windows 8 What bends fabric of space-time? I know that mass can bend fabric of space-time, which causes gravity by making an object curve around a planet or star but is there anything else that can bend it?  Other energy sources, forces anything? How do file permissions work? Mysql: Select all data between two dates Is GTA Online cross-platform? need a regex to parse a csv file with double quotes in php What is the Unix command to create a hardlink to a directory in OS X? How do you create a hardlink (as opposed to a symlink or a Mac OS alias) in OS X that points to a directory? I already know the command "ln target destination" but that only works when the target is a file. I know that Mac OS, unlike other Unix environments, does allow hardlinking to folders (this is used for Time Machine, for example) but I don't know how to do it myself. How many solutions $X^{10} - I=0$ has in $M_2(\mathbb{R})$? How many solutions $X^{10} - I=0$ has in $M_2(\mathbb{R})$? Where $M_2(\mathbb{R})$ denotes the set of $2 \times 2$ real matrices.  I absolutely have no idea of where I should start from. $I$ and $-I$ solve the equation, but are there any other non-trivial solutions? Are there infinitely many solutions? Why do adult insects have 6 legs? Apparently, there is an advantage to having 6 legs in the insect world. What is that advantage, if anything? Why would such an advantage exist for insects, but not for other, larger land animals?  What do those middle legs do that the front and hind legs cannot, if anything? Are they really essential, or do they just generate more muscle power? I have a file as below:  mime PI Name: ISHO SUCCESS RATE RT, Value: 95.663826 scr  PI Name: RRC Access Failures due to UU, Value: 0.13394141 prog PI Name: RRC Access Failures due to UU, Value: 0.16077702 sch PI Name: RRC Access Failures due to UU, Value: 0.11781933   I want to remove text PI till Value:. I tried   sed '/&lt;PI&gt;/,/&lt;\/Value:&gt;/d'    Any help? I know a lot of female programmers, and I know there are a good number of them out there.  But I don't recall ever having one of my questions answered by, nor have I ever answered a question by a female programmer here at Stack&nbsp;Overflow.  Now I mostly deal in the Delphi tag, and that may make a difference. But I've got the feeling there is something about the programming social network that Stack&nbsp;Overflow is, along with its form of mini-competition (via reputation) that turns most ladies off.  When I go down the first few pages of top users by rep, there is nary a lady to be found.  Go over to Quantcast and . Go down to the Demographics, and you'll see that a full 20% of the visits are by females. So they are here, lurking and using the wonderful info that Stack&nbsp;Overflow provides.  Then why aren't there more of them participating, both with questions and answers?  What can Stack&nbsp;Overflow do to persuade female programmers to participate more?    So after a dozen downvotes offset by a dozen upvotes, and accusations by many that I am a bigot, the bottom line seems to be that Stack&nbsp;Overflow appeals to males more than females.  This is my observation and I believe a proper analysis would support the hypotheses that a much higher percentage of male programmers use Stack&nbsp;Overflow than the percentage of female programmers.    Assuming that is the case, then Stack&nbsp;Overflow is geared more towards the male psyche than the female. If so, I again ask, what can they do about that?      This question was asked in StackOverflow Meta on November 20, 2009. It was made Community Wiki. It was asked in a constructive manner and should be considered an appropriate question for Meta.   Yet it was closed over two years after it was asked as "not constructive" after more than 40 upvotes and 10 favorites and 16 answers.   Now it resides here on Meta StackExchange, still closed. I just shake my head. Idea behind proof that $\frac{21n+4}{14n+3}$ is irreducible for all $n$ I have a proof of $\frac{21n+4}{14n+3}$ being an irreducible fraction for any positive integer $n$. The proof starts with the following: Indeed, from the equality: $$2(21n+4)-3(14n+3)=-1$$ and so on..But how does this equality follow from the fraction? Beamer Tikz-cd Problem