PHP coding help

DakotaSchool · September 26, 2006

Hello. I am need of some help with coding PHP. In the middle of the code below, I would like to have the product model display. The product model is set to display in the admin, but the code to display the product model on this page is missing. I have located the point to insert the code (labeled below with "<tr><td>Need code to place model number here</td></tr>"). I have inserted p.products_model in to the query (hopefully in the right place). Any help with this would be greatly appreciated.

<?php

/*

edited - 2005/07/01 13:50

-----------------------------------------

$Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

?>

<?php

if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {

$new_products_query = tep_db_query("select p.products_id, p.products_model, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

} else {

$new_products_query = tep_db_query("select distinct p.products_id, p.products_model, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

}

$row = 0;

$col = 0;

echo '

<tr>

';

while ($new_products = tep_db_fetch_array($new_products_query)) {

$new_products['products_name'] = tep_get_products_name($new_products['products_id']);

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

$product = tep_db_fetch_array($product_query);

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

// get products category

$categories_query = tep_db_query("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$new_products['products_id'] . "'");

if (tep_db_num_rows($categories_query) > 0) {

$categories = tep_db_fetch_array($categories_query);

$categories_query2 = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$categories['categories_id'] . "'");

$categories2 = tep_db_fetch_array($categories_query2);

$category_name = $categories2['categories_name'];

} else {

$category_name = '';

}

// get products manufacturers

$man_query = tep_db_query("select manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$new_products['products_id'] . "'");

if (tep_db_num_rows($categories_query) > 0) {

$manuf = tep_db_fetch_array($man_query);

$man_query2 = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$manuf['manufacturers_id'] . "'");

$manuf2 = tep_db_fetch_array($man_query2);

$man_name = $manuf2['manufacturers_name'];

} else {

$man_name = '';

}

echo '

<tr><td colspan=2 bgcolor=#ECEEF0 height=38 style="padding-left: 14px" valign=middle><a class="pr_name" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '"> ' . $new_products['products_name'] . '</a></td></tr>

</table>

</td></tr>

<tr><td width=95 valign=top align=center><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'vspace=0') . '</a></td>

<tr><td height=60 valign=middle>'.preg_replace('/\s\S*$/i', '', substr($new_products['products_description'], 0, 80)).' ...</td></tr>

<tr><td>Need code to place model number here</td></tr>

<tr><td><span class=ch7>Price:</span> <span class=ch8>'.$currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).'</span></td></tr>

</table>

</td></tr>

</table>

</td></tr>

<tr><td colspan=2><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']) . '">' . tep_image_button('button_in_cart.gif') . '</a><span style="padding-left: 12px"></span><a href="' . tep_href_link('product_info.php','products_id=' . $new_products['products_id']) . '">' . tep_image_button('small_view.gif') . '</a></td></tr>

</table>

</td>

';

$col ++;

if ($col > 1) {

$col = 0;

$row ++;

echo '

</tr>

</table>

</td></tr>

<tr>

';

} else echo '

</table>

</td>

';

}

echo '

</tr>

</table>

';

?>

dave111 · September 26, 2006

Replace:

Need code to place model number here

With:

<?php echo $new_products['products_model']; ?>

DakotaSchool · September 27, 2006

Thanks!!! I see now how to make this work.

PHP coding help

Recommended Posts

DakotaSchool

dave111

DakotaSchool

Archived

Browse

Activity