here sir... error upon mysql_num_rows()
<script src="js/jquery-1.5.1.min.js"></script>
<script src="js/jquery-ui.js"></script>
<script src="js/truncate.js"></script>
<script>
$(function() {
$(".news_content").truncate({max_length: 200});
$("#dialog:ui-dialog").dialog("destroy");
$("#product_details").dialog({
autoOpen: false,
height: 370,
width: 300,
modal: true,
buttons: {
Close: function() {
$( this ).dialog( "close" );
}
}
});
});
function show_details(product_id)
{
var myData = "id=" + product_id + "&purpose=" + "product_details";
$.ajax({
type: "POST",
url: "modules/sessionset.php",
data: myData,
cache: true,
success: function(){
$('#product_details').load("modules/methodholder.php");
},
error: function(){
alert('Failed to load.');
}
});
$("#product_details").dialog("open");
}
</script>
<table>
<tr valign="top">
<td colspan="5">
<table>
<tr>
<th class="home_header">News Feed</th>
</tr>
<?php
include ("connect.php");
$sqlQuery = "SELECT * FROM NEWS WHERE status = 'Active' ORDER BY 1 DESC";
$newsdetails = mysql_query($sqlQuery);
$new_ctr = mysql_num_rows($newsdetails);
if ($new_ctr >= 1)
{
while(($row = mysql_fetch_array($newsdetails)) || ($ctr == 5))
{
echo "<tr>";
echo "<td colspan='5'>" . $row['title'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td class='news_content' colspan='5'>" . $row['content'] . "</td>";
echo "</tr>";
}
echo "<tr>";
echo "<td><a href='news.php'>View All</a></td>";
echo "</tr>";
}
else
{
echo "<tr>";
echo "<td>No news update.</td>";
echo "</tr>";
}
?>
</table>
</td>
</tr>
<tr><td colspan="5" width="800"><hr /></td></tr>
<tr valign="top">
<td>
<table>
<tr>
<th class="home_header">New Products</th>
</tr>
<tr>
<?php
include ("connect.php");
$sqlQuery = "SELECT * FROM PRODUCT WHERE date_added >= subdate(curdate(), INTERVAL 7 DAY) AND status = 'Available' ORDER BY date_added DESC LIMIT 10";
$newproduct = mysql_query($sqlQuery);
$new_ctr = mysql_num_rows($newproduct);
if ($new_ctr >= 1)
{
$ctr = 1;
while($row = mysql_fetch_array($newproduct))
{
echo "<td align='center' class='cell'>";
echo "<a onclick='show_details(\"" . $row['product_id'] . "\")'><img height='70px' src='images/products/" . $row['product_code'] . ".jpg' alt='no image' /></a><br/>";
echo "<a onclick='show_details(\"" . $row['product_id'] . "\")'>" . $row['product_code'] . "<br />";
echo $row['model'] . "<br />";
echo $row['price'] . ".00 Php<br />";
echo "</td>";
if($ctr == 5)
{
echo "</tr><tr>";
$ctr = 1;
}
else
{
$ctr++;
}
}
echo "</tr>";
echo "<tr>";
echo "<td><a href='products.php'>View All Products</a></td>";
echo "</tr>";
}
else
{
echo "<tr>";
echo "<td>No new product. <a href='products.php'>View All</a></td>";
echo "</tr>";
}
?>
</table>
</td>
</tr>
<tr><td colspan="5" width="800"><hr /></td></tr>
<tr valign="top">
<td>
<table>
<tr>
<th class="home_header">Updated Products</th>
</tr>
<tr>
<?php
$sqlQuery = "SELECT * FROM PRODUCT WHERE date_updated >= (subdate(curdate(), INTERVAL 7 DAY)) AND (date_updated != date_added) AND status = 'Available' ORDER BY date_updated DESC LIMIT 10";
$updated = mysql_query($sqlQuery);
$updated_ctr = mysql_num_rows($updated);
if ($updated_ctr >= 1)
{
$ctr = 1;
while($row = mysql_fetch_array($updated))
{
echo "<td align='center' class='cell'>";
echo "<a onclick='show_details(\"" . $row['product_id'] . "\")'><img height='70px' src='images/products/" . $row['product_code'] . ".jpg' alt='no image' /></a><br/>";
echo "<a onclick='show_details(\"" . $row['product_id'] . "\")'>" . $row['product_code'] . "<br />";
echo $row['model'] . "<br />";
echo $row['price'] . ".00 Php<br />";
echo "</td>";
if($ctr == 5)
{
echo "</tr><tr>";
$ctr = 1;
}
else
{
$ctr++;
}
}
echo "</tr>";
echo "<tr>";
echo "<td><a href='products.php'>View All</a></td>";
echo "</tr>";
}
else
{
echo "<tr>";
echo "<td>No updated product. <a href='products.php'>View All</a></td>";
echo "</tr>";
}
?>
</table>
</td>
</tr>
</table>
<div id="product_details" title="Product Details">
</div>
by the way sir... everything is working, i tested it in my WAMP Server...
