8 Aug
2002
8 Aug
'02
4:55 p.m.
Hi,
can I assume that the password is always the third field of mysql.user?
Marc
9 Aug
9 Aug
5:12 a.m.
On Thu, 8 Aug 2002, Marc Delisle wrote:
can I assume that the password is always the third
field of mysql.user?
I don't think so.
Why not just specify the fields you want, in the order you want in your
query?
--
Robin Hugh Johnson
E-Mail : robbat2(a)orbis-terrarum.net
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639
8:13 a.m.
Robin Johnson wrote:
On Thu, 8 Aug 2002, Marc Delisle wrote:
Because the goal is to find if the name of the password field in mysql.user
is Password or password, and I wanted to avoid doing a loop for each of the
fields, looking for "assword".
I am implementing the fix in user_details as is, maybe someone will come
with a better solution.
Marc
can I assume that the password is always the third
field of mysql.user?
I don't think so.
Why not just specify the fields you want, in the order you want in your
query?
8:31 a.m.
At 08:12 09.08.2002 -0400, you wrote:
Robin Johnson wrote:
hmm dont know why it would be different (Password or password) but how
about a simple solution *G*
show fields from mysql.user like "%assword"
On Thu, 8 Aug 2002, Marc Delisle wrote:
Because the goal is to find if the name of the password field in mysql.user
is Password or password, and I wanted to avoid doing a loop for each of the
fields, looking for "assword".
I am implementing the fix in user_details as is, maybe someone will come
with a better solution. can I assume that the password is always the third
field of mysql.user?
I don't think so.
Why not just specify the fields you want, in the order you want in your
query? Marc
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
8:47 a.m.
Good idea, thanks :)
"Thomas Bähr [Office]" a écrit :
At 08:12 09.08.2002 -0400, you wrote:
--
Marc Delisle
Robin Johnson wrote:
hmm dont know why it would be different (Password or password) but how
about a simple solution *G*
show fields from mysql.user like "%assword"
>Marc
>
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:ThinkGeek
>Welcome to geek heaven.
>http://thinkgeek.com/sf
>_______________________________________________
>Phpmyadmin-devel mailing list
>Phpmyadmin-devel(a)lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel On Thu, 8 Aug 2002, Marc Delisle wrote:
Because the goal is to find if the name of the password field in mysql.user
is Password or password, and I wanted to avoid doing a loop for each of the
fields, looking for "assword".
I am implementing the fix in user_details as is, maybe someone will come
with a better solution. can I assume that the password is always the third
field of mysql.user?
I don't think so.
Why not just specify the fields you want, in the order you want in your
query? 
1:20 p.m.
New subject: [Phpmyadmin-devel] Re: about mysql.user
----- Original Message -----
From: "Thomas Bähr [Office]" <baehr(a)glaswald.de>
hmm dont know why it would be different (Password or
password) but how
about a simple solution *G*
show fields from mysql.user like "%assword"
Just forget my previous mail, this solution is the better one ;-)
Alexander
1:17 p.m.
New subject: [Phpmyadmin-devel] Re: about mysql.user
----- Original Message -----
From: "Marc Delisle" <DelislMa(a)CollegeSherbrooke.qc.ca>
Robin Johnson wrote:
mysql.user
On Thu, 8 Aug 2002, Marc Delisle wrote:
Because the goal is to find if the name of the password field in can I assume that the password is always the third
field of mysql.user?
I don't think so.
Why not just specify the fields you want, in the order you want in your
query?
is Password or password, and I wanted to avoid doing a
loop for each of
the
fields, looking for "assword".
What about this:
$res = PMA_mysql_query($sql_query, $dbh);
$row = mysql_fetch_array($res, MYSQL_ASSOC);
if (isset($row['Password'])) {
$pw_key = 'Password';
} else if (isset($row['password'])) {
$pw_key = 'password';
} else {
$pw_key = FALSE;
}
$pw_key should now contain the correct column name for the password field or
FALSE is there is neither a "Password" nor a "password" field.
Regards,
Alexander
8077
days inactive
8078
days old
6 comments
4 participants
participants (4)
-
"Thomas Bähr [Office]" -
Marc Delisle -
Rabus -
Robin Johnson