Re: inverse function

2001-04-17 Thread phobo
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

Re: Need it ASAP

2001-04-11 Thread phobo
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

Re: [MySQL] User name/password

2001-04-10 Thread phobo
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

Bad Select Syntax workaround?

2001-04-08 Thread phobo
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