[PHP-DB] Selecting last row

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

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 passwo

RE: [PHP-DB] MySQL Result Resource

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 The

RE: [PHP-DB] MySQL Result Resource

r() ); $row = mysql_fetch_array($result) ) then do 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. /mt At 02:10 AM 1/11/2002 +1100, Necro wrote: >Yeh, I notice now the MD5 was wrong. > &

RE: [PHP-DB] MySQL Result Resource

where clause Andrew -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 "andr

RE: [PHP-DB] MySQL Result Resource

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

RE: [PHP-DB] MySQL Result Resource

TED]] Sent: Friday, 11 January 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: "

RE: [PHP-DB] MySQL Result Resource

. Andrew -Original Message- From: Miles Thompson [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

RE: [PHP-DB] MySQL Result Resource

63e06103a371fd95b21b4a849bb4b91))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

RE: [PHP-DB] MySQL Result Resource

word, 1 as auth from acl where 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: [PH

RE: [PHP-DB] MySQL Result Resource

n crypted by the PASSWORD call 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 ca

RE: [PHP-DB] MySQL Result Resource

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: