กระทู้: string mysql ซ้อนเงื่อนไข WHERE เขียนยังไงครับ
ผมทำ php ให้ซีเลทข้อมูล ติดตรงเขียนคำสั่งสติงคิวรี่แบบซ้อนไม่ได้ครับ
<?php
require_once('Connections/mai_inn.php');
$ncount = $_POST['nbox'];
if ($ncount == 0){
exit;
}
$cccount[0]=0;
$foryear[0]="name_subject";
$foryear[1]="id_subject";
$foryear[3]="credit";
for ($i = 0; $i < $ncount; $i++) {
$dsf = "checkbox_".$i;
//echo $_POST[$dsf];
if($_POST[$dsf]){
$cccount[] = $i;
}
}
foreach($cccount as $val){
//echo $val;
mysql_select_db($database_mai_inn, $mai_inn);
$strq="SELECT * FROM vocational_education WHERE id = '".$val."'";
$str_4year_information="SELECT * FROM transferdegree_4year_information WHERE use_boo = '1' AND id = '".$strq."'";
$tracut2 = mysql_query($str_4year_information, $mai_inn) or die(mysql_error());
mysql_query("SET NAMES UTF8");
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
while ($rec = mysql_fetch_assoc($tracut2)){
echo $rec['name_subject'];
echo "<br />";
}
}
?>