[PHP-DB] Advanced search form

2005-11-28 Thread Michelle Konzack
Hello *, I have a search form and I like to add advanced search options like this is a search -XXX Test which mean, 1) this is a search must be in this order 2) -XXXDo not find XXX contents 3) TestAND Does anyone has a

[PHP-DB] PHP encryption

2005-11-28 Thread Koen Wagemans
Hello How can I compare a user password with an old /etc/shadow file from Solaris 7. The crypt function gives an other result! Thanks Koen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] IS_NUMERIC ?

2005-11-28 Thread Bastien Koert
REGEXP? Bastien From: Dwight Altman [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] IS_NUMERIC ? Date: Mon, 28 Nov 2005 10:01:26 -0600 Hello List, Is there an IS_NUMERIC(aCandidateString) function in MySQL that I can run in a query, similar to the various PHP is_* functions?

[PHP-DB] Comma separated JOIN syntax

2005-11-28 Thread Matt Monaco
When using JOINS by the simply supplying a comma separated list of tables in the FROM clause, is the ON argument normally associated with a join intended to be addressed in the WHERE clause, or should ON still be used? // Comma separated join SELECT u.*, a.city FROM users u, addresses a WHERE