Felix Geerinckx wrote:
On 24/11/2005, Lowell Allen wrote:
but I'm looking for a way to convert the short hash values into
comparable long hash values.
This is (fortunately) *not* possible.
Apparently the upgrade procedure can successfully convert
short-to-long hash values for MySQL
-to-long hash values for MySQL
user passwords ("user" in the sense of a MySQL user accessing the
database itself), so surely there's a way to convert short hashed values
to long hashed values for use within a PHP application. Any practical
advice greatly appreciated.
--
Lowell A
.net/> -- in hopes of providing a link to that
recommendation, but could not find anything. However, I've seen it mentioned
several times on the PHP general discussion list.
HTH
--
Lowell Allen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ntax for what I am trying to achieve?
>
Assuming the field "date" is of type datetime:
WHERE (TO_DAYS(CURDATE()) - TO_DAYS(date)) = 1
HTH
--
Lowell Allen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e "get a clue."
I think this tutorial by Kevin Yank is excellent. I printed it and went
through it several times. It was recently expanded and published as a book,
and since I found it so helpful, I immediately ordered the book.
s, ProductsCategories, Items " .
"WHERE Categories.ParentID=$MainCatID " .
"AND Categories.ID=ProductsCategories.CategoriesID " .
"AND ProductsCategories.ProductsID=Products.ID " .
"
