[PHP-DB] Re: MySQL Query on the Fly

2007-05-12 Thread itoctopus
You have to use an iframe to do what you want. Once the user select something, you referesh the iframe and you pass specific parameters to it based on the user's choice. -- itoctopus - http://www.itoctopus.com ""Todd A. Dorschner"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Good

Re: [PHP-DB] PHP to md5 the $var before it reaches MySQL's gen query log

2007-05-12 Thread Chetanji
Once again sorry to all for indulging you. I have found the answer, plus a little additional security on the this. Here is the code that works with additional encrypting of the md5 from PHP. My syntax was incorrect before. Bedul got me thinking by changing the BLOB to VARCHAR. That led to the a

Re: [PHP-DB] PHP to md5 the $var before it reaches MySQL's gen query log

2007-05-12 Thread Chetanji
Hey Bedul, My mistake as md5 on MySQL side still works. I put an extra ' in the passwords value by mistake. I corrected it. Still no error from MySQL I can not tell the difference from either INSERT in the log as both look the same(except one is binary 32bits and the other md5('text'). Still h

Re: [PHP-DB] PHP to md5 the $var before it reaches MySQL's gen query log

2007-05-12 Thread Chetanji
Hey Bedul, I dropped the table and recreated it with VARCHAR (50) for both. (The reason I like BLOB is when you edit the table all you see is BLOB until you have the permission to open it to binary or text. Here is the log message: 070512 16:36:07 35 Connect [EMAIL PROTECTED] on

Re: [PHP-DB] PHP to md5 the $var before it reaches MySQL's gen query log

2007-05-12 Thread bedul
username BLOB NOT NULL default '', password BLOB NOT NULL default '', do you try username varchar 50, password varchar 50?? i'm just ask.. sry, hope that's can solve your problem - Original Message - From: "Chetan Graham" <[EMAIL PROTECTED]> To: Sent: Saturday, May 12, 2007 4:28 PM Subj

[PHP-DB] PHP to md5 the $var before it reaches MySQL's gen query log

2007-05-12 Thread Chetan Graham
Greetings to All, I am having difficulty in 'md5'ing a $var in a function before it is placed into the ("INSERT INTO table... The whole point is I don't want the MySQL DB logs showing my $var's password and username 'before' it is encrypted by MySQL's md5. When MySQL receives PHP's encrypted $var