[PHP-users 13866] Like$B8!:w;~$N=hM}$K$D$$$F!#(B
A. T
php-users@php.gr.jp
Mon, 10 Mar 2003 14:37:03 +0900
$B$*@$OC$K$J$C$F$$$^$9!#!!$G$9!#(B
odbc$B@\B3(B Access97 & php4$B$N4D6-2<$K$F:n6H!#(B
Like$B8!:w$K$D$$$F$*J9$-$7$?$$$N$G$9!#(B
$B%i%$%/8!:w$,2DG=$J8!:w2hLL$,$"$C$F!"(B
$B$=$3$G!"(B
$B!!!!(BSELECT Syoyuusya
$B!!!!(BFROM Received
$B!!!!(BWHERE ((Syoyuusya) Like 'N*')
$B$N$h$&$J!"!V(BN$B$r4^$`8eJ}0lCW8!:w(BSQL$B!W$rEj$2$F(B
$B%G!<%?$r<hF@$7$?$$$N$G$9$,!">e5-$N%/%(%j$r(B
MS-Acess$B$N%/%(%j5!G=$G<B9T$9$k$H!"$A$c$s$HCM$r(B
$B<h$C$F$/$k$N$G$9$,!"$3$N%/%(%j$r(Bphp$B$rDL$7$F!"(B
$B<B9T$9$k$HCM$r<hF@$7$F$-$^$;$s!#(B
$B$A$J$_$K!"(B
php$B$N%3!<%I$O!"(B
$conn = db_connect($dsn, "", "");
$sql = "SELECT Syoyuusya ";
$sql.= "FROM Received ";
$sql.= "WHERE ((Syoyuusya) Like 'N*')";
$res = odbc_exec($conn, $sql);
if($res){
$cnt = 0;
while(odbc_fetch_row($res)){
$SyoyuusyaArray[$cnt] = odbc_result($res, 1);
$cnt++;
}
}
$B$H$$$&6q9g$G!"(BLike$B8!:w;~0J30$N(BSQL$B$G$O@5>o$KF0$$$F$$$^$9!#(B
$B2?$+!"(Bphp$B$N@_Dj$,I,MW$J$N$G$7$g$&$+!)(B
$B$I$J$?$+8f65<x4j$$$^$9!#(B
$B$h$m$7$/$*4j$$$7$^$9!#(B
_________________________________________________________________
$B<+Bp$N(B PC $B$G1Q8lNO$r%"%C%W(B MSN $B1Q2qOC(B http://englishtown.msn.co.jp/