BrianAustin

$per_page = 5; $page_query = mysql_query("SELECT COUNT(*) FROM product"); $pages = ceil(mysql_result($page_query, 0) / $per_page); $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1; $start = ($page - 1) * $per_page; $query = mysql_query("SELECT * FROM product p JOIN category c ON p.category_ids = c.category_id LIMIT $start, $per_page"); while($query_row = mysql_fetch_assoc($query)){ echo "<tr align=center>"; echo "<td>"; echo"<img src='".$row['product_image']."'/>"; echo "<td>" .$row['product_name']. "</td>"; echo "<td>" .$row['product_description']. "</td>"; echo "<td>" .$row['product_price']. "</td>"; echo "<td>" .$row['product_stok']. "</td>"; echo "<td>" .$row['category_name']. "</td>"; echo "<td><input type=button value=delete name='delete' onClick = lemparproduct('".$row['product_id']."')></td>"; echo "<td><input type='hidden' id='idproducthidden' value='".$row['product_id']."'> <input type=button value=update name='updates' onClick = wew('".$row['product_id']."')></td>"; echo "</tr>"; } if($pages >= 1 && $page <= $pages){ for($x=1; $x<=$pages; $x++){ echo ($x == $page) ? '<b><a href="?page='.$x.'">'.$x.'</a></b> ' : '<a href="?page='.$x.'">'.$x.'</a> '; } } HI there sory for that plain code....can u teach me ...why that error happen? sorry i'm newbie Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\coba\view\product_view.php on line113 // $pages = ceil(mysql_result($page_query, 0) / $per_page); Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\coba\view\product_view.phpon line 117 // while($query_row = mysql_fetch_assoc($query)){

i'm sorry im newbie of php... i found this... http://forums.phpfreaks.com/topic/181256-solved-warning-mysql-fetch-array-expects-parameter-1-to-be-resource/ but in my case i didn't use $result in my while....why it doesnt work? somebody help me...thx before ERROR on line 17coba.php $total_record = mysql_fetch_array(mysql_query('SELECT COUNT(`product_id`) AS rows FROM `product`' )); //ERROR $total_record=$total_record['rows']; $total_page=ceil($total_record/$per_page); if($page>$total_page) $page=$total_page; $query_exec = get_all_product(); echo "<table align='center'>"; echo "<tr align=center>"; echo"<th>Image</th><th>Name</th><th>About</th><th>Price</th><th>Stoks</th><th>Category</th>"; echo "</tr>"; while ($row = mysql_fetch_assoc($query_exec)){ echo "<tr align=center>"; echo"<td><img src='".$row['product_image']."'/><td>"; echo "<td>" .$row['product_name']. "</td>"; echo "<td>" .$row['product_description']. "</td>"; echo "<td>" .$row['product_price']. "</td>"; echo "<td>" .$row['product_stok']. "</td>"; echo "<td>" .$row['category_name']. "</td>"; echo "<td><input type=button value=delete name='delete' onClick = lemparproduct('".$row['product_id']."')></td>"; echo "<td><input type='hidden' id='idproducthidden' value='".$row['product_id']."'> <input type=button value=update name='updates' onClick = wew('".$row['product_id']."')></td>"; echo "</tr>";} echo "</table>"; echo 'page : <select onchange="window.location=\'?p=\'+this.value">'; for($i=1;$i<=$total_page;$i++) echo '<option' . ( $i==$page ? ' selected' : '' ) . '>' . $i . '</option>'; echo '</select><br>';