Go Back   Cyber Tech Help Support Forums > Software > Web Development & Graphic Design

Notices

Web Development & Graphic Design Problem Solving for Graphic Design, PHP, ASP, Perl, MySQL, SQL, XML, HTML issues

Reply
 
Topic Tools
  #1  
Old July 15th, 2008, 09:07 AM
avatar462's Avatar
avatar462 avatar462 is offline
New Member
 
Join Date: Oct 2006
Posts: 22
Question oscommerce help

Hi,
Can anybody help me fix this Oscommerce code so that when I click on products_new (cell phones) category it only opens up specific categories, not all of
them?! At the moment all the products on the site display in products_new link, I would only like to display new phones, since there are used phones and equipment too. I know that cpath pulls these products from the database, but I would only like to pull certain products not all of them..

Any help would be greatly appreciated!

CODE products_new.php:
PHP Code:
<?php
/*
$Id: products_new.php,v 1.27 2003/06/09 22:35:33 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions
[url]http://www.oscommerce.com[/url]

Copyright © 2003 osCommerce

Released under the GNU General Public License
*/

require('includes/application_top.php');

require(
DIR_WS_LANGUAGES $language '/' FILENAME_PRODUCTS_NEW);

$breadcrumb->add(NAVBAR_TITLEtep_href_link(FILENAME_PRODUCTS_NEW));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET?>">
<title><?php echo TITLE?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER HTTP_SERVER) . DIR_WS_CATALOG?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="col_left">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</td>
<!-- body_text //-->
<td width="100%" class="col_center">

<?php /* require(DIR_WS_BOXES . 'panel_top.php'); */ ?>

<? tep_draw_heading_top();?>

<? new contentBoxHeading_ProdNew($info_box_contents);?>

<? tep_draw_heading_top_3();?>

<?php
$products_new_array 
= array();

$products_new_query_raw "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " TABLE_PRODUCTS " p left join " TABLE_MANUFACTURERS " m on (p.manufacturers_id = m.manufacturers_id), " TABLE_PRODUCTS_DESCRIPTION " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id "' order by p.products_date_added DESC, pd.products_name";
$products_new_split = new splitPageResults($products_new_query_rawMAX_DISPLAY_PRODUCTS_NEW);

if ((
$products_new_split->number_of_rows 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '2'))) {
?>
<?php 
echo tep_draw_result_top_1(); ?>
<table border="0" cellspacing="0" cellpadding="0" class="result">
<tr>
<td><?php echo $products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW); ?></td>
<td class="result_right"><?php echo TEXT_RESULT_PAGE ' ' $products_new_split->display_links(MAX_DISPLAY_PAGE_LINKStep_get_all_get_params(array('page''info''x''y'))); ?></td>
</tr>
</table>

<?php echo tep_draw_result_top(); ?>
<?php 
echo tep_draw_result_bottom_1(); ?>

<?php
}
?>
<?php
if ($products_new_split->number_of_rows 0) {
$products_new_query tep_db_query($products_new_split->sql_query);









$row 0;
$col 0;
$info_box_contents = array();
while (
$products_new tep_db_fetch_array($products_new_query)) {

$product_query tep_db_query("select products_description, products_id from " TABLE_PRODUCTS_DESCRIPTION " where products_id = '" . (int)$products_new['products_id'] . "' and language_id = '" . (int)$languages_id "'");
$product tep_db_fetch_array($product_query);

$p_desc substr($product['products_description'], 0MAX_DESCR_1);
$p_id $product['products_id'];
$p_pic '<a href="' tep_href_link(FILENAME_PRODUCT_INFO'products_id=' $products_new['products_id']) . '">' tep_image(DIR_WS_IMAGES $products_new['products_image'], $products_new['products_name'], SMALL_IMAGE_WIDTHSMALL_IMAGE_HEIGHT) . '</a>';
$p_name '<a href="' tep_href_link(FILENAME_PRODUCT_INFO'products_id=' $products_new['products_id']) . '">' substr$products_new['products_name'],0,MAX_DESCR_NAME) . '</a>';



if (
$new_price tep_get_products_special_price($products_new['products_id'])) {
$products_price '<s>' $currencies->display_price($products_new['products_price'], tep_get_tax_rate($products_new['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' $currencies->display_price($new_pricetep_get_tax_rate($products_new['products_tax_class_id'])) . '</span>';
} else {
$products_price '<span class="productSpecialPrice">'.$currencies->display_price($products_new['products_price'], tep_get_tax_rate($products_new['products_tax_class_id']).'</span>');
}

$p_price $products_price;

$products_new['products_name'] = tep_get_products_name($products_new['products_id']);
$info_box_contents[$row][$col] = array('align' => 'center',
'params' => '',
'text' => '
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="bg2">'
.$p_name.'</td>
</tr>
</table>
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td style="height:128px" class="vam">
<table cellpadding="0" cellspacing="0" border="0" style="width:143px;"><tr><td align="center">'
.$p_pic.'</td></tr></table>
</td>
<td style="width:100%;">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td style="height:79px" class="vam">'
.$p_desc.'</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" border="0" style="height:49px" class="bg3">
<tr>
<td style="width:45%" class="vam" align="center">'
.$p_price.'</td>
<td style="width:55%">
<br style="line-height:6px">
<a href="'
.tep_href_link("products_new.php","action=buy_now&products_id=".$p_id).'">'.tep_image_button('button_add_to_cart1.gif').'</a><br>
<br style="line-height:4px">
<a href="' 
tep_href_link('product_info.php?products_id='.$p_id) . '">'.tep_image_button("button_details.gif").'</a><br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
'
);

$col ++;
if (
$col 0) {
$col 0;
$row ++;
}
}
new 
contentBox($info_box_contents);

} else {
?>
<table border="0" cellspacing="0" cellpadding="0" class="box_width_cont">
<tr><td class="main"><?php echo TEXT_NO_NEW_PRODUCTS?></td></tr>
<tr><td><?php echo tep_draw_separator('pixel_trans.gif''100%''10'); ?></td></tr>
</table>
<?php
}
?>

<?php echo tep_draw_result_bottom(); ?>

<?php
if (($products_new_split->number_of_rows 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) {
?>
<?php 
echo tep_draw_result_top_2(); ?>
<table border="0" width="100%" cellspacing="0" cellpadding="0" class="result">
<tr>
<td><?php echo $products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW); ?></td>
<td class="result_right"><?php echo TEXT_RESULT_PAGE ' ' $products_new_split->display_links(MAX_DISPLAY_PAGE_LINKStep_get_all_get_params(array('page''info''x''y'))); ?></td>
</tr>
</table>
<?php echo tep_draw_result_bottom_2(); ?>

<?php
}
?>

<? tep_draw_heading_bottom_3();?>

<? tep_draw_heading_bottom();?>

</td>
<!-- body_text_eof //-->
<td class="col_right">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</td>
</tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES 'footer.php'); ?>
<!-- footer_eof //--></body>
</html>
<?php require(DIR_WS_INCLUDES 'application_bottom.php'); ?>

Last edited by Buzz; July 15th, 2008 at 10:16 AM. Reason: added code tags.
Reply With Quote
  #2  
Old July 22nd, 2008, 07:31 PM
FrEaKmAn FrEaKmAn is offline
Senior Member
 
Join Date: Aug 2005
Posts: 477
around here: $products_new_query_raw = "select p.pr...
is searches the db for products, now u could can a option like after where: p.id='idyouwant',
but this isn't best solution. If you want to output only certain products, that
don't have anything in common, then maybe adding another table is best solution...
Reply With Quote
Reply

Bookmarks

Topic Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Topics
Topic Topic Starter Forum Replies Last Post
Any osCommerce Guru's ? Jimmyshmitts Web Development & Graphic Design 3 October 18th, 2007 08:37 AM
Website Help. OSCommerce. Plz read. boardernerd228 Web Development & Graphic Design 4 June 7th, 2007 01:36 PM
OSCommerce giving me troubles. boardernerd228 Web Development & Graphic Design 4 June 5th, 2007 08:54 PM
oscommerce leroys1000 Web Development & Graphic Design 8 April 20th, 2007 10:04 AM


All times are GMT +1. The time now is 11:03 AM.