Re: [PHP-DB] is SELECT case sensitive

2005-10-06 Thread Koen Wagemans
Select on type varchar is not case sensitive, you can make it case sensitive with the BINARY option: SELECT * FROM table_name WHERE BINARY column LIKE '$searching_criteria'; Koen On 06/10/05, Ron Piggott [EMAIL PROTECTED] wrote: Is SELECT typically case sensitive? Is there a way to make

Re: [PHP-DB] Link Selected

2005-10-17 Thread Koen Wagemans
There are some possibilities: 1) Define a link to the same page in your first combobox (option value/option and execute him when he is selected (with Javascript). Be sure that you take the value off the selected item to the folowing page. Your second combi will be reloaded and here you fill

Re: [PHP-DB] transactions

2005-11-08 Thread Koen Wagemans
Hello MySQL isn't a transactional DB it doesn't know rollback and commit. You can solve the problem probably by locking the tables (LOCK / UNLOCK) Regards Koen On 07/11/05, Bastien Koert [EMAIL PROTECTED] wrote: I don't think you can. Once the script finishes the connections are closed and

[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