[PHP-DB] Selecting last row

2001-12-21 Thread Necro
What query can I use to select the last row in a table?? Andrew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
Lo all, Slight problem on an auth script... Warning: Supplied argument is not a valid MySQL result resource in d:\htdocs\infekt\packages\auth.inc on line 104 Line 26: define( DATABASE, imanager ); Line 103: $arg = select password, 1 as auth from acl where username='$username' and

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
argument is not a valid MySQL result resource in d:\htdocs\infekt\packages\auth.inc on line 104 Andrew -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:05 AM To: Necro; [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Result Resource

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
whatever processing you need with the array $row. Miles PS Just reply to the list, if you reply directly to me I have one more message to delete. g /mt At 02:10 AM 1/11/2002 +1100, Necro wrote: Yeh, I notice now the MD5 was wrong. But I still get the same error on line 104. If I try and replace

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
-Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:08 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Can you try this puppy at the MySQL console? I'd dearly love to know where andrewd is coming from, it sounds

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
Same error... select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna))1109 : Unknown table 'andrewd' in where clause Andrew -Original Message- From: George Pitcher [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:10 AM To: Necro; [EMAIL

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
2002 3:28 AM To: Necro Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Result Resource try this : select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna)); - Original Message - From: Necro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
[mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:29 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource LIGHT just came on!!! Why does ittake so long. MD5(andrew.madonna) - I think you're goint to have to do this $passhash = $username . $password and use MD5

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
))1064 : You have an error in your SQL syntax near 'a371fd95b21b4a849bb4b91))' at line 1 Does that help give any idea at all as to what the problem is? Andrew -Original Message- From: Necro [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 3:35 AM To: [EMAIL PROTECTED] Subject: RE: [PHP

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
username='andrewd' and password = 'PASSWORD(madonna)'Resource id #2 Any ideas? Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 8:56 AM To: Necro; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL Result Resource Addressed to: Necro

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
either. Andrew -Original Message- From: Daniel Barton [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:40 PM To: Necro Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Result Resource Andrew: Don't put quotes around your MySQL function call. i.e. PASSWORD($password

RE: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Necro
http://www.hotscripts.com/Detailed/4219.html --- that is the script But I cannot use crypt() on a winodws system. So I tried MD5, now I try PASSWORD. Any one got any idea how to make the script work with either of those?? Andrew -Original Message- From: Necro [mailto:[EMAIL PROTECTED