nezona

Joomla Menu Help

Hi There Im creating a site for a client using the classifiedplazza template. Please see http://developmentoy.com/classifieds_10_quickstart/ if you look at the link you will see the menu ' Local Home - Local Events -Fun Pages etc, etc. Directly underneath this is a blue space, set out ready for another menu I wish to place there. My problem is. How do I create this?. I kinda hacked the code for the first menu, but don't know where to start for the second menu. To have a clearer picture of what im trying to recreate see the image. [attachment deleted by admin]

February 21, 2009

creating a link text instead of an image

nezona posted a topic in PHP Coding Help

Hi there, Im trying to covert an image to text the following code is used:- <table border="0" width="100%" cellpadding="0" cellspacing="0"> <tr> <td width="20px"> </td> <td align="left" valign="top"><a href="/chairs/" class="mnselected" ><img src="http://www.primeofficeenvironments.com/images/sidemenu-chair-hover.jpg" border="0"></a> </td> </tr> <tr> <td> </td> <td align="left" valign="top" face="bradley hand itc"><a href="/files/" class="snav" >files</a> </td> </tr> <tr> <td> </td> <td align="left" valign="top" face="bradley hand itc"><a href="/reception/" class="snav" ><img src="http://www.primeofficeenvironments.com/images/sidemenu-reception.jpg" border="0"></a> </td> </tr> <tr> <td> </td> <td align="left" valign="top" ><a href="/workstations/" class="snav" ><img src="http://www.primeofficeenvironments.com/images/sidemenu-workstations.jpg" border="0"></a> </td> </tr> <tr> <td> </td> As you can see somebody has cheated and put the links as an image rather than text, Im wanting to create links with a font face of bradley hand itc, can anyone help

basic php question? - echo site url

nezona replied to nezona's topic in PHP Coding Help

Hi thanks guys it worked, apart from.... because it's the header.php file, if I go from the home pages www.primeoe.com and click on the a href is works fine and shows the directory www.primeoe.com/reception. If I then click on desks it tries to find www.primeoe.com/reception/desks. is there anywhere around this? kind regards neil

basic php question? - echo site url

nezona posted a topic in PHP Coding Help

I have this piece of code in my header.php ;- <a href="<? echo SITE_URL; ?>reception/" class="snav" >Reception Areas</a> Now obviously this points to a page on my site called reception. The only problem is im trying to get ready to be search engine optimized, instead of it pointing to the whole of the url, I just want it point to same site link i.e instead of www.primeofficeenviroments.com/reception. I want it to point to /reception. Can anyone help? Neil

php same site links

nezona posted a topic in PHP Coding Help

Hi I have the following same site link's images, that i can see in html, [empty] /desc/?pid=48&cat=4 2. [empty] /desc/?pid=54&cat=4 3. [empty] /desc/?pid=64&cat=4 4. [empty] /desc/?pid=66&cat=4 5. [empty] /desc/?pid=75&cat=4 6. [empty] /desc/?pid=76&cat=4 however within php:- <? $page_title = 'Office Workstations-A range of different models to suit your needs at www.primoe.com'; $keywords = 'office furniture, computer workstation, office desks, computer desks, office workstations, used computer desks, office cubicles, office chairs, home enviroment, steel case, knoll, steelcase, register, shopping cart'; $pageDescription = 'Stocking a range of office workstations and office desks, from steel to knoll effect. A whole range of office furniture is available, used and new.'; $page="workstations";include_once("../includes/header.php"); $count=0; $idcount=0; $sqlSel="SELECT * from products where category='4'"; $resSel=mysql_query($sqlSel) or die (mysql_error()); $affrows =mysql_num_rows($resSel); if ($affrows > 0) { while($rowssel=mysql_fetch_array($resSel)) { $count++; $idcount++; $pid=$rowssel['id']; $name=$rowssel['name']; $price=$rowssel['price']; $img=$rowssel['image']; $jid="p".$idcount; if ($count==1) { $content.=' <tr> <td width="155px" height="240px" background="'.IMAGE_PATH.'bgbox.jpg" valign="top" id="'.$jid.'"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="19px" width="155px" valign="bottom" class="whttxt"> '.$name.'</td> </tr> <tr> <td height="19px" width="155px" align="right" class="whttxt">$'.$price.' </td> </tr> <tr> <td height="202px" width="155px" align="center" colspan="2"><a href="desc/?pid='.$pid.'&cat=4" onmouseover="mover(\''.$jid.'\')" onmouseout="mout(\''.$jid.'\')"><img src="../includes/thumb.php?src='.$img.'&x=152&y=201&f=0" border="0"></a></td> </tr> </table> </td> '; } else if ((($count%4)==0) || $count==$affrows){ $content.=' <td width="155px" height="240px" background="'.IMAGE_PATH.'bgbox.jpg" valign="top" id="'.$jid.'"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="19px" width="155px" valign="bottom" class="whttxt"> '.$name.'</td> </tr> <tr> <td height="19px" width="155px" align="right" class="whttxt">$'.$price.' </td> </tr> <tr> <td height="202px" width="155px" align="center" colspan="2"><a href="desc/?pid='.$pid.'&cat=4" onmouseover="mover(\''.$jid.'\')" onmouseout="mout(\''.$jid.'\')"><img src="../includes/thumb.php?src='.$img.'&x=155&y=202&f=0" border="0"></a></td> </tr> </table> </td> </tr> '; $count=0; } else { $content.=' <td width="155px" height="240px" background="'.IMAGE_PATH.'bgbox.jpg" valign="top" id="'.$jid.'"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="19px" width="155px" valign="bottom" class="whttxt"> '.$name.'</td> </tr> <tr> <td height="19px" width="155px" align="right" class="whttxt">$'.$price.' </td> </tr> <tr> <td height="202px" width="155px" align="center" colspan="2"><a href="desc/?pid='.$pid.'&cat=4" onmouseover="mover(\''.$jid.'\')" onmouseout="mout(\''.$jid.'\')"><img src="../includes/thumb.php?src='.$img.'&x=155&y=202&f=0" border="0"></a></td> </tr> </table> </td> '; } } } else{ $content.='<font class="redtxt">We are in the process of adding more products, Kindly check with us later.</font>'; } ?> <script language="JavaScript"> function mover(id) { /*var obj = document.getElementById(id); alert(obj.background); obj.background='../images/bgboxhover.jpg';*/ var TableObj = document.getElementById(id); if (TableObj && TableObj.style) { TableObj.style.backgroundImage ='url("../images/bgboxhover.jpg")'; } } function mout(id) { /*var obj = document.getElementById(id); obj.background='../images/bgbox.jpg';*/ var TableObj = document.getElementById(id); if (TableObj && TableObj.style) { TableObj.style.backgroundImage ='url("../images/bgbox.jpg")'; } } </script>  <td align="left" valign="top" width="75%" height="85%" > <table border="0" width="780"> <tr> <td class="btext" align="center" valign="top"><br> <table width="95%" height="100%" border="0"> <tr> <td valign="top"><IMG src="<? echo IMAGE_PATH; ?>workstations.jpg"></td> </tr> <tr> <td> </td> </tr> <tr> <td align="left"> <table border="0" cellpadding="0" cellspacing="12"> <?=$content?> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr>  <? include_once("../includes/footer.php"); ?> the links dissappear?. can anyone help me the same site link's need text, but I can't do that without finding the links in php kind regards neil

December 6, 2007

[SOLVED] header.php and meta name

nezona replied to nezona's topic in PHP Coding Help

wrap this in php, ??... have I forgot something?

[SOLVED] header.php and meta name

nezona replied to nezona's topic in PHP Coding Help

i have uploaded the code as below:- header.php ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> '<TITLE>' .$page_title . '</TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT="' . $keywords . '"> <META NAME="Description" CONTENT="">' ?><link href="<? echo CSS_PATH ; ?>style.css" rel="stylesheet" type="text/css"> <div id="divTopLeft" style="position:absolute"> <table height="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="50"> </td> </tr> <tr> <td valign="top"> <table border="0" width="100%" cellpadding="0" cellspacing="0"> <tr> <td width="20px"> </td> <? if($page=="chairs") {?> <td align="left" valign="top"><a href="<? echo SITE_URL; ?>chairs/" class="mnselected" ><img src="<? echo IMAGE_PATH ; ?>sidemenu-chair-hover.jpg" border="0"></a> </td> <? } else {?> <td align="left" valign="top" ><a href="<? echo SITE_URL; ?>chairs/" class="snav" ><img src="<? echo IMAGE_PATH ; ?>sidemenu-chair.jpg" border="0"></a> </td> <? } ?> </tr> <tr> <td> </td> <? if ($page == "files") {?> <td align="left" valign="top"><a href="<? echo SITE_URL; ?>files/" class="mnselected" ><img src="<? echo IMAGE_PATH ; ?>sidemenu-file-hover.jpg" border="0"></a> &nbsp and one of the pages code = <? $page="workstations"; $page_title = 'Your Office Furniture needs at Prime Office Enviroments, chairs, desks, drawers, filing and more Office Furniture'; $keywords = 'Office furniture, used office furniture, office filing, office chairs, etc...'; $page="workstations"; include_once("../includes/header.php"); $count=0; $idcount=0; $sqlSel="SELECT now im getting ' . $page_title . ' - microsoft windows inexplorer in the title header

[SOLVED] header.php and meta name

nezona posted a topic in PHP Coding Help

Hiya guys I need your help again surrounding meta name and php. I have a file called header.php, which contains the following code:- <TITLE>Prime Office Environments</TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT=""> <META NAME="Description" CONTENT=""> Now my understanding is that the header.php, contains information for all pages, fine for a single page but when your doing seo, you need the meta information to be different for different pages. How can I change this:- below is the meta information for the front page <TITLE>Your Office Furniture needs at Prime Office Enviroments, chairs, desks, drawers, filing and more Office Furniture</TITLE> <meta name="description" content="is a national office furniture company that deals with new and used office furniture. We offer extensive services from buying, selling, installation, liquidations, project management, design and asset management. We carry only Grade A office furniture."> <meta name="keywords" content="Office furniture, used office furniture, office filing, office chairs, workstations, deliver throughout the US, "> <META NAME="Generator" CONTENT="EditPlus"> but I dont know what to take out in the header.php, and where to put this in terms of php in the following script:- <? $page="workstations"; include_once("../includes/header.php"); $count=0; $idcount=0; $sqlSel="SELECT * from products where category='4'"; $resSel=mysql_query($sqlSel) or die (mysql_error()); $affrows =mysql_num_rows($resSel); if ($affrows > 0) { while($rowssel=mysql_fetch_array($resSel)) { $count++; $idcount++; $pid=$rowssel['id']; $name=$rowssel['name']; $price=$rowssel['price']; $img=$rowssel['image']; $jid="p".$idcount; if ($count==1) { $content.=' <tr> <td width="155px" height="240px" background="'.IMAGE_PATH.'bgbox.jpg" valign="top" id="'.$jid.'"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="19px" width="155px" valign="bottom" class="whttxt"> '.$name.'</td> </tr> <tr> <td height="19px" width="155px" align="right" class="whttxt">$'.$price.' </td> </tr> <tr> <td height="202px" width="155px" align="center" colspan="2"><a href="desc/?pid='.$pid.'&cat=4" onmouseover="mover(\''.$jid.'\')" onmouseout="mout(\''.$jid.'\')"><img src="../includes/thumb.php?src='.$img.'&x=152&y=201&f=0" border="0"></a></td> </tr> </table> </td> '; } else if ((($count%4)==0) || $count==$affrows){ $content.=' <td width="155px" height="240px" background="'.IMAGE_PATH.'bgbox.jpg" valign="top" id="'.$jid.'"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="19px" width="155px" valign="bottom" class="whttxt"> '.$name.'</td> </tr> <tr> <td height="19px" width="155px" align="right" class="whttxt">$'.$price.' </td> </tr> <tr> <td height="202px" width="155px" align="center" colspan="2"><a href="desc/?pid='.$pid.'&cat=4" onmouseover="mover(\''.$jid.'\')" onmouseout="mout(\''.$jid.'\')"><img src="../includes/thumb.php?src='.$img.'&x=155&y=202&f=0" border="0"></a></td> </tr> </table> </td> </tr> '; $count=0; } else { $content.=' <td width="155px" height="240px" background="'.IMAGE_PATH.'bgbox.jpg" valign="top" id="'.$jid.'"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="19px" width="155px" valign="bottom" class="whttxt"> '.$name.'</td> </tr> <tr> <td height="19px" width="155px" align="right" class="whttxt">$'.$price.' </td> </tr> <tr> <td height="202px" width="155px" align="center" colspan="2"><a href="desc/?pid='.$pid.'&cat=4" onmouseover="mover(\''.$jid.'\')" onmouseout="mout(\''.$jid.'\')"><img src="../includes/thumb.php?src='.$img.'&x=155&y=202&f=0" border="0"></a></td> </tr> </table> </td> '; } } } else{ $content.='<font class="redtxt">We are in the process of adding more products, Kindly check with us later.</font>'; } ?> <script language="JavaScript"> function mover(id) { /*var obj = document.getElementById(id); alert(obj.background); obj.background='../images/bgboxhover.jpg';*/ var TableObj = document.getElementById(id); if (TableObj && TableObj.style) { TableObj.style.backgroundImage ='url("../images/bgboxhover.jpg")'; } } function mout(id) { /*var obj = document.getElementById(id); obj.background='../images/bgbox.jpg';*/ var TableObj = document.getElementById(id); if (TableObj && TableObj.style) { TableObj.style.backgroundImage ='url("../images/bgbox.jpg")'; } } </script>  <td align="left" valign="top" width="75%" height="85%" > <table border="0" width="780"> <tr> <td class="btext" align="center" valign="top"><br> <table width="95%" height="100%" border="0"> <tr> <td valign="top"><IMG src="<? echo IMAGE_PATH; ?>workstations.jpg"></td> </tr> <tr> <td> </td> </tr> <tr> <td align="left"> <table border="0" cellpadding="0" cellspacing="12"> <?=$content?> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr>  <? include_once("../includes/footer.php"); ?> Guys I need your help again.

php and metakeywords

nezona replied to nezona's topic in PHP Coding Help

okay im now getting this:- Warning: Unexpected character in input: '' (ASCII=1) state=1 in /hsphere/local/home/mylittle/mycutelittlefeet.com/index2.php on line 82 Parse error: parse error, unexpected T_STRING in /hsphere/local/home/mylittle/mycutelittlefeet.com/index2.php on line 84 <?php /* $Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <?php $pgHeading="onlinemortgage101.com-Helpingyoutoimproveyourwebsite"; $pgDesc="HelpingmillionsRefinancehomeandgetbestmortgageloanratequotes."; $pgKeywords="RefinanceHome,MortgageLoan,Mortgagelead,InternetMortgageLeadTalk"; ?> <meta name="description" content="<?phpecho$pgDesc?>"></meta> <meta name="keywords" content="<?phpecho$pgKeywords?>"></meta> <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">  <?php require(DIR_WS_INCLUDES . 'header.php'); ?>   <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr>  <?php if ($category_depth == 'nested') { $category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'"); $category = tep_db_fetch_array($category_query); ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <?php if (isset($cPath) && strpos('_', $cPath)) { // check to see if there are deeper categories within the current category $category_links = array_reverse($cPath_array); for($i=0, $n=sizeof($category_links); $i<$n; $i++) { $categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'"); $categories = tep_db_fetch_array($categories_query); if ($categories['total'] < 1) { // do nothing, go through the loop } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); break; // we've found the deepest category the customer is in } } } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); } $number_of_categories = tep_db_num_rows($categories_query); $rows = 0; while ($categories = tep_db_fetch_array($categories_query)) { $rows++; $cPath_new = tep_get_path($categories['categories_id']); $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%'; echo ' <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n"; if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) { echo ' </tr>' . "\n"; echo ' <tr>' . "\n"; } } // needed for the new products module shown below $new_products_category_id = $current_category_id; ?> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> </tr> </table></td> </tr> </table></td> <?php } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) { // create column list $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } } else { // show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } } if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">  <tr> <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td> </tr> </table></td> <?php } else { // default page ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td> <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?> </td> </tr> </table> </td> <?php } ?>  </tr> </table>   <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>  </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

php and metakeywords

nezona replied to nezona's topic in PHP Coding Help

Thanks guys, see who said developers/programmers and seo's spoke another language

php and metakeywords

nezona posted a topic in PHP Coding Help

Okay I need help, Im an seo guy not a developer or programmer, and I have a client im helping who needs meta tags and meta descriptions in a home page, I cant figure out where to put the following:- <?php $pgHeading="onlinemortgage101.com - Helping you to improve your web site"; $pgDesc="Helping millions Refinance home and get best mortgage loan rate quotes."; $pgKeywords="Refinance Home, Mortgage Loan, Mortgage lead, Internet Mortgage Lead Talk"; <meta name="description" content="<?php echo $pgDesc ?>"></meta> <meta name="keywords" content="<?php echo $pgKeywords ?>"></meta> this is the php script as below:- <?php /* $Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <?php $pgHeading="onlinemortgage101.com - Helping you to improve your web site"; $pgDesc="Helping millions Refinance home and get best mortgage loan rate quotes."; $pgKeywords="Refinance Home, Mortgage Loan, Mortgage lead, Internet Mortgage Lead Talk"; <meta name="description" content="<?php echo $pgDesc ?>"></meta> <meta name="keywords" content="<?php echo $pgKeywords ?>"></meta> <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">  <?php require(DIR_WS_INCLUDES . 'header.php'); ?>   <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr>  <?php if ($category_depth == 'nested') { $category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'"); $category = tep_db_fetch_array($category_query); ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <?php if (isset($cPath) && strpos('_', $cPath)) { // check to see if there are deeper categories within the current category $category_links = array_reverse($cPath_array); for($i=0, $n=sizeof($category_links); $i<$n; $i++) { $categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'"); $categories = tep_db_fetch_array($categories_query); if ($categories['total'] < 1) { // do nothing, go through the loop } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); break; // we've found the deepest category the customer is in } } } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); } $number_of_categories = tep_db_num_rows($categories_query); $rows = 0; while ($categories = tep_db_fetch_array($categories_query)) { $rows++; $cPath_new = tep_get_path($categories['categories_id']); $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%'; echo ' <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n"; if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) { echo ' </tr>' . "\n"; echo ' <tr>' . "\n"; } } // needed for the new products module shown below $new_products_category_id = $current_category_id; ?> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> </tr> </table></td> </tr> </table></td> <?php } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) { // create column list $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } } else { // show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } } if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">  <tr> <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td> </tr> </table></td> <?php } else { // default page ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td> <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?> </td> </tr> </table> </td> <?php } ?>  </tr> </table>   <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>  </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> help, please!!!

Sign In

Posts

Joined

Last visited

Profile Information

nezona's Achievements

Newbie (1/5)

Reputation

Joomla Menu Help

creating a link text instead of an image

basic php question? - echo site url

basic php question? - echo site url

php same site links

[SOLVED] header.php and meta name

[SOLVED] header.php and meta name

[SOLVED] header.php and meta name

php and metakeywords

php and metakeywords

php and metakeywords

Browse

Activity

Important Information