use the ORDER BY clause with the SELECT
SELECT * FROM table ORDERBY fieldname ASC
(or replace ASC with DESC for descending order)
Siggy
- Original Message -
From: "Michael M. Ocana" <[EMAIL PROTECTED]>
To: "Mysql Lists" <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 2:55 PM
Subjec
for 'asap' things like this, go use a chatroom / IRC type scenario. Or look
up
What you're asking has NOTHING to do with databases.
siggy
- Original Message -
From: "Mike Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 6:49 AM
Subject: Need it ASAP
can't you just try logging in using different logins?
why not login as "root", and make a new account?
if you can access the mysql database, look at the user table ... ?
siggy
- Original Message -
From: "Tim Thorburn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2
I have a (dumb!) program that performs SELECT statements with a quote around
the table and the fieldname; see the portion from the trace log below:
Cardfivefffe35e1:fffed875 EXIT SQLExecDirect with return code -1
(SQL_ERROR)
HSTMT 0x00cf17ac
UCHAR * 0x00ae6