[PHP] Re: MySQL password()

To my knowledge it isn't possible to "decrypt" the PASSWORD function in MySQL (you need to use MySQL ENCRYPT/DECRYPT for that). However, it's possible to use PASSWORD on the user-provided string too. You could try the following code: $query="SELECT * FROM users where username='$PHP_AUTH_USER'

[PHP] fullname

Hey php-general, is there some other easyer way to do in one line than this?: $fullname = $session["f_name"]; $fullname .= " "; $fullname .= $session["l_name"]; P.S the thing is to add line in the middle of the first and last names :) Thanks -- Best regards, Mantas

Re: [PHP] fullname

Is this easier for you? $fullname = $session["f_name"]." ".$session["l_name"]; - Original Message - From: "Mantas Kriauciunas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 30 July, 2002 7:11 PM Subject: [PHP] fullname > Hey php-general, > > is there some other easyer way t

RE: [PHP] MySQL password()

> Mmm.. think you misinterpreted my question... > > > http://www.mysql.com/doc/M/i/Miscellaneous_functions.html > > PASSWORD(str) > how do you unPASSWORD(str) in PHP? Basically, you don't. Instead, what you do is use the password that was provided as user input. You create a suitable

RE: [PHP] fullname

> is there some other easyer way to do in one line than this?: > > $fullname = $session["f_name"]; > $fullname .= " "; > $fullname .= $session["l_name"]; $fullname = $session["f_name"] . " " . $session["l_name"]; CYA, Dave -- PHP General Mailing List (http://www.php.net/) To unsub

[PHP] Auto Increment Problems....

rite, my primary key column ("id") is set to auto_increment as usual which is very handy. But when I delete a row, the auto_increment just keeps incrementing and there's this 'hole' left where I deleted the row! Apart from this looking ugly, it poses another problem. In my PHP script where I can

[PHP] ORDER BY from 2 tables

i assume this is a simple question... how can I SELECT * FROM 2 different tables in the same query, ORDER BYing the 'hits' column, which both tables have. eg, 2 tables i have are similiar and i want to merge them and then select everything ordering by hits -- PHP General Mailing List (http:/

[PHP] Re: ORDER BY from 2 tables

See if your database supports the UNION clause... On Mon, 29 Jul 2002, Georgie Casey wrote: > i assume this is a simple question... > > how can I SELECT * FROM 2 different tables in the same query, ORDER BYing > the 'hits' column, which both tables have. > > eg, 2 tables i have are similiar and

[PHP] Re: ORDER BY from 2 tables

I am not sure what exactly you mean. If you are talking about a regular query then: SELECT tblTable1.hits, tblTable2.hits FROM tblTable1, tblTable2 ORDER BY tblTable1.hits; If you are talking about combining the two tables so that all your 'hits' are in one column then there are a few

<    1   2   3