I think I see it anyway:
ORDER BY tile DESC, sub_title ASC
Each item in the list fields takes ASC/DESC individually. Your statement would
only change the sort order on the second column, not both.
-Original Message-
From: PJ [mailto:af.gour...@videotron.ca]
Sent: Friday, July 17, 200
Please echo the query and show the actual result. We have no way to know what
your program puts in your variables. The problem is often a that a programming
error causes the code to construct a query that's different from what you
assume.
Regards,
Gavin Towey
-Original Message-
From:
Try looking in Control Panel->Administrative Tools-> Services and deleting
all the MySQL services.
You might have to change the collation you are currently using to one
that best match the language of those weird accents you are referring
too. That's part of the reason you may be getting unexpected results
with your ORDER BY statement. Also, can you show us your select
statements?
On Fri, Jul 1
Here's the query:
"SELECT * FROM book ORDER BY $sort $dir LIMIT $offset, $records_per_page";
$sort == 'title, sub_title'; $dir==ASC (or DESC); $offset== (any
multiple of 10); $records_per_page== 10;
I could let the user change these, but I decided it is simpler to keep
it at 10 books/page. Only the
At 04:52 PM 7/16/2009, Todd Lyons wrote:
On Wed, Jul 15, 2009 at 11:58 AM, mos wrote:
>> I have backup all the database files(innodb engine).
>> Now I want to recover it as myisam engine offline.
>> Any suggestions?
>
> Why can't you copy the InnoDb files to another machine and open the
database
The binlogs are closed and reopened every time you do a FLUSH LOGS; command, or
when the server restarts. Is your server crashing continuously? Take a look
at your error log as well.
Regards,
Gavin Towey
-Original Message-
From: Gary Smith [mailto:g...@primeexalia.com]
Sent: Thursday,
From your description of your problem, it's very difficult to understand what
you're doing and what results you're trying to get.
Making some assumtions, I think you might need to use a technique described in
this link to get the results you want:
http://jan.kneschke.de/projects/mysql/groupwise
Hello,
I followed the site instructions but I am still facing the problem... This
issue is driving me crazy... I don't know what else to do...
Is there a way to remove everything related to MySQL from my machine ( a
complete clean up ) ?
I'm asking that because there are lots of softwares instal
Can't find anything on the web that deals with my problem(s).
I have to display thousands of book listings by title, sub_title with 10
books per page. The php/mysql code works fine - except:
ASC or DESC does not change one iota.
I have checked by commandline and find that it is not working at all h
I suffered the same problem, and the following worked for me:
http://www.andy.name.my/2009/03/cannot-create-windows-service-for-mysqlerror0/
Hello,
I've downloaded and installed MySQL 5.1 on the machine where I work.
However, during the server configuration thru MySQL Instance Server Config
Wizard, on the screen "Ready to execute...", the following error occurs in the
"Start service" point: Could not start the service MySQL:Error 0.
I
12 matches
Mail list logo
