Warning:mysql_num_rows at database.php on line 103

Agron · August 13, 2006

Initially I installed Separate price per customer 4.14 and I got the error below, so I uninstalled it and installed SPPC 4.13, I got the same error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in .../public_html/includes/functions/database.php on line 103

This error appears depending on how many items I have in the basket. I tried with 3 items and it appeared 3 times on top of the page and 3 times together with item listing, just above Continue button. It starts appearing when I reach these pages:

catalog/shopping_cart.php

catalog/checkout_shipping.php

I know that I did not modify these pages at all.

Also some images do not appear in Specials, since I installed this contribution.

I dont know which file to look for the first error.

See the specials.php below for the second problem with images:

Help would be appreciated. Thanks

<?php

/*

$Id: specials.php,v 1.49 2003/06/09 22:35:33 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

require('includes/application_top.php');

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_SPECIALS);

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_SPECIALS));

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<?php require(DIR_WS_INCLUDES . 'meta_tags.php');?>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<tr>

<?php

if(!tep_session_is_registered('sppc_customer_group_id')) {

$customer_group_id = '0';

} else {

$customer_group_id = $sppc_customer_group_id;

}

$specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' and s.customers_group_id = ". (int)$customer_group_id." order by s.specials_date_added DESC";

$specials_split = new splitPageResults($specials_query_raw, MAX_DISPLAY_SPECIAL_PRODUCTS);

// EOF Separate Price Per Customer

$specials_split = new splitPageResults($specials_query_raw, MAX_DISPLAY_SPECIAL_PRODUCTS);

if (($specials_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) {

?>

<tr>

<tr>

<td class="smallText"><?php echo $specials_split->display_count(TEXT_DISPLAY_NUMBER_OF_SPECIALS); ?></td>

<td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $specials_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>

</tr>

</table></td>

</tr>

<?php

}

?>

<tr>

<tr>

<?php

$row = 0;

$specials_query = tep_db_query($specials_split->sql_query);

$no_of_specials = tep_db_num_rows($specials_query);

while ($specials = tep_db_fetch_array($specials_query)) {

$specials[] = $_specials;

$list_of_prdct_ids[] = $_specials['products_id'];

} // end while ($_specials = tep_db_fetch_array($specials_query))

// a line needed for the selection of the products_id's

$pg_list_of_prdct_ids = "products_id = '".$list_of_prdct_ids[0]."' ";

if ($no_of_specials > 1) {

for ($n = 1 ; $n < count($list_of_prdct_ids) ; $n++) {

$pg_list_of_prdct_ids .= "or products_id = '".$list_of_prdct_ids[$n]."' ";

}

// now get all the customers_group_price's

$pg_query = tep_db_query("select products_id, customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where (".$pg_list_of_prdct_ids.") and customers_group_id = '" . $customer_group_id . "'");

// put all the info in an array called new_prices

while ($pg_array = tep_db_fetch_array($pg_query)) {

$new_prices[] = array ('products_id' => $pg_array['products_id'], 'products_price' => $pg_array['customers_group_price']);

}

// we already got the results from the query and put them into an array, can't use while now

// while ($specials = tep_db_fetch_array($specials_query)) {

for ($x = 0; $x < $no_of_specials; $x++) {

$row++;

if(!empty($new_prices)) {

for ($i = 0; $i < count($new_prices); $i++) {

if( $specials[$x]['products_id'] == $new_prices[$i]['products_id'] ) {

$specials[$x]['products_price'] = $new_prices[$i]['products_price'];

}

} // end if(!empty($new_prices)

$product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$specials['products_id'] . "' and language_id = '" . (int)1 . "'");

$product = tep_db_fetch_array($product_query);

$new_products['products_description'] = $product['products_description'];

echo '

<tr><td height=33 valigne=middle colspan=2><a class=ml2 href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials[$x]['products_id']) . '">' . $specials[$x]['products_name'] . '</a></td></tr>

<tr><td width=110 valign=top><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $specials[$x]['products_image'], $specials[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td>

<tr><td height=45 valigne=middle class=ch8>'.preg_replace('/\s\S*$/i', '', substr($new_products['products_description'], 0, 35)).' ...</td></tr>

<tr><td height=35 valigne=middle><span class=ch9>Price:</span> <span class=ch10><s class=ch10 style="color:#7F7F7F;font-size:11px">'.$currencies->display_price($specials[$x]['products_price'], tep_get_tax_rate($specials[$x]['products_tax_class_id'])) . '</s><br><span class=ch10>' . $currencies->display_price($specials[$x]['specials_new_products_price'], tep_get_tax_rate($specials[$x]['products_tax_class_id'])) . '</span></span></td></tr>

<tr><td><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials[$x]['products_id']) . '">' . tep_image_button('small_view.gif') . '</a></td></tr>

<tr><td><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $specials[$x]['products_id']) . '">' . tep_image_button('button_in_cart.gif') . '</a></td></tr>

</table>

</td></tr>

</table>

</td>

' . "\n";

if ((($row / 2) == floor($row / 2))) {

?>

</tr>

<tr>

<?php //middle coln space

}else echo '

';

}

?>

</tr>

</table>

</td></tr>

</table>

</td>

</tr>

<?php

if (($specials_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) {

?>

<tr>

<tr>

<td class="smallText"><?php echo $specials_split->display_count(TEXT_DISPLAY_NUMBER_OF_SPECIALS); ?></td>

<td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $specials_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>

</tr>

</table></td>

</tr>

<?php

}

?>

</tr>

</table>

</td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Warning:mysql_num_rows at database.php on line 103

Recommended Posts

Agron

Link to comment

Share on other sites

Join the conversation

Browse

Activity