In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] 
says...
> hi,
> i want to encode a string that users enter with mysql password function. but
> sometimes this code works sometimes don't. mysql warns me:
> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
> resource in ........
> 
> the code is:
> 
> $result=mysql_query("select password(".$_POST['password'].")");
>   while ($p = mysql_fetch_array($result, MYSQL_ASSOC)):
>   $pswrd=$p['password('.$_POST['password'].')'];
>   endwhile;
> 
> thanks...

Normally that error indicates a problem with the syntax of your sql query. 
If you add the line 

echo mysql_error();

after your mysql_query line you'll get a useful error message from mysql, 
which should indicate more precisely where your problem lies.


-- 
David Robley
Temporary Kiwi!

Quod subigo farinam

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to