 |
|
จาโค้ดตรงนี้อ่ะค่ะ วนลูปแล้วมันไม่ได้จำนวนที่ต้องการค่ะ มันได้ 2 จริงๆแล้วมันมากกว่านี้ แก้ยังงัยดีค่ะ ช่วยหน่อยคฃนะคะ
$apDocSql="SELECT DISTINCT useract.user_code,
record_doc.qmr_app,
record_doc.div_app,
record_doc.doc_type,
record_doc.form_name,
record_doc.user_app2,
useract.record_code,
useract.user_code,
useract.useract_act,
useract.useract_date,
useract.useract_time,
useract.useract_pri,
useract.useract_attch,
nuke_users.pn_user_aim
FROM
nuke_users
INNER JOIN useract ON (nuke_users.user_code = useract.user_code)
INNER JOIN record_doc ON (useract.record_code = record_doc.record_code)
Where useract.record_code='$record_code' and useract.useract_pri='$last_useract_pri' and pn_user_aim='$divQmr' and (record_doc.pem101!='' or record_doc.pem102!='' or record_doc.pem103!='' or record_doc.pem104!='' or
record_doc.pem105!='' or record_doc.pmw101!='' or record_doc.pmw102!='' or record_doc.pmw103!='' or record_doc.p200!='' or record_doc.p300!='' or record_doc.p402!='' or record_doc.p500!='' or record_doc.p600!='' or
record_doc.p701!='' or record_doc.p702!='' or record_doc.p800!='' or record_doc.p900!='' or record_doc.ci101!='' or record_doc.coo!='' or record_doc.cao!='' or record_doc.pmwxo!='' or record_doc.cixo!='' or record_doc.ptd!='' ) ";
}
$apDocSr = mysql_query($apDocSql) or die("ไม่สามารถ query ข้อมูลได้");
"<br> gg =".$countAp=mysql_num_rows($apDocSr);
$i=1;
while ($apData2= mysql_fetch_array($apDocSr)){
?>
<tr>
<td height="5"><? //echo $data['copy'];?>
<div align="center"> <? if($doc_type=="doc"){ echo "/"; }?></div></td>
<td height="5"><? // echo $apData['doc_type'];?>
<div align="center"> <? if($doc_type=="pdf"){ echo "/"; } else { echo "/";}?>
</div></td>
<td height="5"><? echo $apData2['pn_user_aim'];?>
<input type="hidden" name="txtuser_[<?=$i?>]" value="<?=$apData2['user_code']?>"></td><td height="5"><? echo $apData2['form_name'];?></td>
<td height="5"><? echo $data['form_no'];?> </td>
<td height="5"> <div align="center"><?
if($edit_to>"0"){
<td height="5" bgcolor="#FF99FF"><? if($data['user_app2']<>"y"){?>
<? //echo pmwrrs;?><? //echo $user_date2;?>
<? }else{ echo suphisara_n;} ?> <? echo $date_app; ?> </td>
</tr>
<?
echo $i=$i+1;
}//===end while ($apData= mysql_fetch_array($apSr),
}
?>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2009-03-09 14:06:56 |
By :
pui_talon |
View :
1047 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
