헷갈리는거요 ;;

Question

qry문에서 id="abc"와같이 큰따옴표로 되어있어야 되잖아요 그런데 아래와같은경우에 "$rid"이런식으로 하면 문제가 생기는거 같은데 이거 해결코드좀 적어주세요 제가 완전생초보라서요

$rid = $_REQUEST[rid];
 
$qry="select num,id,category,date2,star,board from board where num=(select num from keep where id = "$rid")order by num desc;"; 

아름다운세상 · Accepted Answer

쌍따옴표 안에 또 쌍따옴표가 들어가면 안되요~$qry="select num,id,category,date2,star,board from board where num=(select num from keep where id = '$rid')order by num desc"; 또는 $qry="select num,id,category,date2,star,board from board where num=(select num from keep where id = \"$rid\")order by num desc"; 또는  $qry='select num,id,category,date2,star,board from board where num=(select num from keep where id = "$rid")order by num desc';

아키시엘 · Answer

$qry="select num,id,category,date2,star,board from board where num=(select num from keep where id = ".$rid.")order by num desc;";​혹은 [code]$qry="select num,id,category,date2,star,board from board where num=(select num from keep where id = {$rid})order by num desc;";[/code]

헷갈리는거요 ;;

답변 2개

공유하기