[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/