[PHP-users 13949] mysql_fetch_array()=?iso-2022-jp?q?=1B$B$N=1B=28BWarning?=

[Yasunari Imado]

$B$O$8$a$^$7$F!"%$%^%I$H?=$7$^$9!#(B

MySQL $B$N(B ENCODE $B4X?t$r;H$C$F0E9f2=$7$?%l%3!<%I$r(B
DECODE $B4X?t$GI|85$9$k$H$-(B mysql_fetch_array() $B$G(B Warning $B$,=P$k(B
$B%l%3!<%I$,$"$k$N$G$9$,$I$&$d$C$F2sHr$9$l$P$$$$$N$G$7$g$&$+(B?
$B<hF@$9$k%l%3!<%I$N%U%#!<%k%I7?$O(BMySQL$B$N%^%K%e%"%k$r8+$F!"(B
BLOB$B$K$7$F$"$j$^$9!#(B

$B0J2<$O%3!<%I$N0lIt$G$9!#(B

$query = "SELECT `passwd` FROM `TEST`";
$result = mysql_query($query);
while ($data = mysql_fetch_array($result)){	
  // $B0E9f2r=|(B
  $crypt_str = $data['passwd'];
  $decode_query = "SELECT DECODE('$crypt_str', '$decrypt_key')";
  $decode_result = mysql_query($decode_query);
  $decrypt_passwd = mysql_fetch_array($decode_result);
.....

Warning$B$,<($99T$O(B
  $decrypt_passwd = mysql_fetch_array($decode_result);
$B$NItJ,$G$9!#(B

$B%"%I%P%$%9$h$m$7$/$*4j$$$7$^$9!#(B

-----
$B%W%m%0%i%_%s%0Nr(B3$B%v7n(B
MySQL 3.23.52
PHP 4.2.2
SuSELinux 8.1

--
=================================================^=====
Yasunari Imado
=09sjv@iris.eonet.ne.jp    (PGP Key ID: 2582B3D6)

[SSJV]   http://ssjv.kir.jp/
=================================================^=====