ฐานข้อมูล outputที่ผิดพลาด code php
โค้ด: เลือกทั้งหมด
$s1 = explode('-',$search);
$a = $s1[0];
$b = $s1[1];
$min = request_var('min', $a);
$max = request_var('max', $b);
$start = request_var('start', 0);
$limit = request_var('limit', (int)5);
$data = 'SELECT * FROM '.OFFING_TABLE.' as o,'.USERS_TABLE. ' as u
where u.user_id = o.name and o.sa_total between abs("'.$min.'") and abs("'.$max.'") order by o.search_id DESC';
$row = "SELECT COUNT(*) AS sumrow FROM ".OFFING_TABLE.' as o,'.USERS_TABLE. ' as u
where u.user_id = o.name and o.sa_total between abs("'.$min.'") and abs("'.$max.'")';
$result = $db->sql_query($row);
$total_data = (int) $db->sql_fetchfield('sumrow');
$result = $db->sql_query_limit($data, $limit, $start);
while($show = $db->sql_fetchrow($result)){
$x = ($show[pic] == 0) ? true : false;
$date1 = $user->format_date($show['date']);
$template->assign_block_vars('somerow1', array(
'VAR1' => "$show[username]",
'VAR2' => "$show[sa_m]",
'VAR3' => "$show[sa_f]",
'VAR4' => "$show[age_m]",
'VAR5' => "$show[age_f]",
'VAR6' => "$show[status_l]",
'VAR7' => "$show[status_c]",
'VAR8' => "$show[status_ma]",
'VAR9' => "$show[status_f]",
'VAR10' => "$show[status_ceo]",
'VAR11' => "$show[time]",
'VAR12' => "$show[money]",
'VAR13' => "$show[ip]",
'VAR14' => "$show[search_id]",
'VAR15' => "$x",
'VAR16' => "$show[user_id]",
'VAR17' => "$date1",
));
}
$pagination_url = append_sid($phpbb_root_path . 'calculate_dowry.' . $phpEx."?search=".$search,'');
$template->assign_vars(array(
'PAGINATION' => generate_pagination($pagination_url, $total_data, $limit, $start),
'PAGE_NUMBER' => on_page($total_data, $limit, $start),
));
โค้ด: เลือกทั้งหมด
<table class="tablebg" width="100%" cellspacing="1" >
<tr class="row2" align="center" style="color:#FFA34F; white-space: nowrap;padding: 7px 5px;font-weight: bold;background-color: #006699;background-image: url('./images/cellpic3.gif');font-size: 1.1em;">
<td >{L_NAME}:</td>
<td>{L_SA_M}:</td>
<td>{L_SA_F}:</td>
<td>{L_AGE_M}:</td>
<td>{L_AGE_F}:</td>
<td>{L_STATUS_L}:</td>
<td>{L_STATUS_C}:</td>
<td>{L_STATUS_MA}:</td>
<td>{L_STATUS_F}:</td>
<td>{L_STATUS_CEO}:</td>
<td>{L_TIME}:</td>
<td>{L_MONEY}:</td>
<td>{L_IP}:</td>
<td>{L_DATE}</td>
<td>{L_PIC}</td>
</tr>
<!-- BEGIN somerow1 -->
<tr class="row2" style="white-space: nowrap;" align="center">
<td><span class="rank-img"><a href="memberlist.php?mode=viewprofile&u={somerow1.VAR16}">{somerow1.VAR1}</td>
<td>{somerow1.VAR2}</td>
<td>{somerow1.VAR3}</td>
<td>{somerow1.VAR4}</td>
<td>{somerow1.VAR5}</td>
<td>{somerow1.VAR6}</td>
<td>{somerow1.VAR7}</td>
<td>{somerow1.VAR8}</td>
<td>{somerow1.VAR9}</td>
<td>{somerow1.VAR10}</td>
<td>{somerow1.VAR11}</td>
<td>{somerow1.VAR12}</td>
<td>{somerow1.VAR13}</td>
<td>{somerow1.VAR17}</td>
<!-- IF somerow1.VAR15 -->
<td><a href="calculate_dowry_showpicture.php?id={somerow1.VAR14}">{L_NOPIC}</td>
<!-- ELSE -->
<td><a href="calculate_dowry_showpicture.php?id={somerow1.VAR14}">{L_PIC}</td>
<!-- ENDIF -->
</tr>
<!-- END somerow1 -->
</table>