ขอความกรุณาผู้เชี่ยวชาญช่วยดัดแปลงโค๊ดนี้ให้เป็น asp หน่อยนะคะ มีความจำเป็นที่จะต้องนำไปใช้นะคะ อันแรกติดตรงที่ $row_object = mysql_query("Select Found_Rows() as rowcount");
$row_object = mysql_fetch_object($row_object);
$actual_row_count = $row_object->rowcount;
Code
1. <?php
$con = mysql_connect("localhost", "root", "1234");
mysql_select_db("member");
$result = mysql_query("select SQL_CALC_FOUND_ROWS * from member order by id asc limit 12");
$row_object = mysql_query("Select Found_Rows() as rowcount");
$row_object = mysql_fetch_object($row_object);
$actual_row_count = $row_object->rowcount;
?>
===================
Code
2. <script type="text/javascript">var actual_count = "<?php echo $actual_row_count; ?>";</script>
===========
3. นี้ติดตรงนี้นะคะ $set_limit = (($requested_page - 1) * 2) . ",2";
Code
<?php
$requested_page = $_POST['page_num'];
$set_limit = (($requested_page - 1) * 2) . ",2";
$con = mysql_connect("localhost", "root", "1234");
mysql_select_db("member");
$result = mysql_query("select * from member order by id asc limit $set_limit");
$html = '';
while ($row = mysql_fetch_array($result)) {
$html .= "<div><img src='image?id=".$row['f']."'width='70'height='70'align='middle' /></div>";
}
echo $html;
exit;
?>
Tag : ASP
