Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001072

Re: [PHP] mysql_query problem (FINALLY FIXED !!!!!!!) From: Brad Wright (bradwright <email protected>)
Date: 07/17/01

Hi all (he says with a sheepish grin:),

To all of those who tried to help with this thread, I thank you from the
bottom of my heart....

Unfortunatly , the problem was not one of syntax, but rather one of gross
stupidity on my behalf. The Field where I had been keeping the (encrypted)
passwords was set to 6 spaces, thus chopping off at least 1/2 of the
encrypted password. So when it was looking for "password('a')" (which is
 60671c896665c3fa  BTW), it was only seeing 60671c in the field.....therefor
NO MATCH.
 What a stupid mistake, delaying me for 1 1/2 days. At least I know I'm not
as crazey as I thought i was going.
I guess the lesson here is to step back once in a while and try looking
'around the edges' of a wall. Its amazing what you may find :).

Once again, thanks to all those kind souls who gave up there own time to try
to help this ol' fool.

Cheers,
Brad

> From: "Christopher Allen" <callen <email protected>>
> Date: Tue, 17 Jul 2001 09:11:05 -0500
> To: "Brad Wright" <bradwright <email protected>>
> Subject: Re: [PHP] mysql_query problem (more suggestions)
>
> not right because this works in a live system:
>
>
>
> $query1 =" SELECT * FROM zip_base WHERE '$zip1' >= zip && '$zip1' <=
> CONCAT(SUBSTRING(zip, '1', LENGTH(zip)-LENGTH(range)), range)"
>
> CONCAT, SUBSTRING and LENGTH are all mysql functions and they work fine in
> this query.
>
> ....
>
>> the problem is (as i understand it), the password function is a mySQL
>> function and not a PHP function, therefor it works in the context of a
>> mysql_query, but not as a PHP function (which your suggested code calls).
>> Unless i have actually defined a function 'password()', calling 'echo
>> password('$password') will (...does, i just double checked) causes a Fatal
>> Error 'Undefined Function'.
>> Nice try tho :)
>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>