Cart Problems - SEO Chat

SEO Chat Forums Sponsor:

March 16th, 2007, 04:56 PM

MBS Auto Parts

Contributing User

Join Date: Apr 2005

Location: Los Angeles

Posts: 138

Time spent in forums: 8 h 39 m 3 sec
Reputation Power: 4

Send a message via MSN to MBS Auto Parts

Send a message via Yahoo to MBS Auto Parts

Cart Problems

Guys I have a problem with this cart! The Items (descriptions) are not showing up!!! Can anyone help???

http://www.hoopnutsncandies.com/index.php?case=category&CID=7

here is the code:

PHP Code:


		
			
<?php

            

            /* Query to fetch last four featured products */

            if(!isset($_REQUEST["start"]))

            { 

                $start = 0; // This variable is set to zero for the first page

            }else{

                $start = $_REQUEST["start"];

            }

            

                $catId = $_REQUEST['CID'];

                $page_name ="index.php?case=category&CID=".$catId."&start";

                $eu = ($start - 0);

                $limit = 12; // No of records to be shown per page.

                $back = $eu - $limit;

                $next = $eu + $limit;

                

                $SQL1= "SELECT * FROM tbl_product WHERE SubCategoryID = '". $catId."'  AND Status= 'Y'";

                $rsQuery1 = mysql_query($SQL1);

                $num=mysql_num_rows($rsQuery1);

                

                $SQL= "SELECT * FROM tbl_product WHERE SubCategoryID = '". $catId."'  AND Status= 'Y' limit $eu, $limit ";

                $rsQuery = mysql_query($SQL);

            

            if(isset($_SESSION["noRefresh"]))

            {

                 $_SESSION["noRefresh"]="";

            }

            

    

    ?>    

            <table width="100%" border="0" cellspacing="0" cellpadding="0">

                  <tr>

                    <td width="542" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                        <tr>

                          <td align="center"><table width="95%" border="0" cellspacing="0" cellpadding="0">

                            <tr>

                              <td>&nbsp;</td>

                              <td>&nbsp;</td>

                            </tr>

                            <tr>

                              

                            </tr>

                            <tr>

                              <td width="19%">&nbsp;</td>

                              <td width="81%" align="left" valign="top"><img src="images/mid_bgline.gif" width="225" height="2" /></td>

                            </tr>

                          </table></td>

                        </tr>

                        <tr>

                          <td align="center" valign="top">

                          <?php if($num>0){?>

                          <table width="95%" border="0" cellspacing="0" cellpadding="0">

                              <tr>

                                <!-- indivisual featured items -->

                                <?php 

                                $i = 1;

                                while($row = mysql_fetch_array($rsQuery)){

                                

                                ?>

                                <td width="45%" valign="top">

                                <table width="100%" border="0" cellspacing="0" cellpadding="0">

                                  <tr>

                                    <td width="7"><img src="images/midleft_cor.gif" width="7" height="34" /></td>

                                    <td align="center" background="images/mid_bg_mid.gif" class="txtbold1"><?=$row['ProductName'];?></td>

                                    <td width="7"><img src="images/midright_cor.gif" width="7" height="34" /></td>

                                  </tr>

                                  <tr>

                                 <form action="index.php?case=shopping" method="POST" >

                                    <td background="images/mid_bgline1.gif" style="background-repeat:no-repeat;">&nbsp;</td>

                                    <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                                      <tr>

                                        <td width="45%" rowspan="3">

                                        <img src="ProductImage/<?=$row['ProductImg'];?>" width="80" height="60" vspace="2" /></td>

                                        <td width="55%">&nbsp;</td>

                                      </tr>

                                      <tr>

                                        <td align="left" class="linktop2">Price : $<?=$row['ProductPrice'] ;?>

                                          </td>

                                      </tr>

                                      <tr>

                                        <td align="left" valign="top">

                                        <input name="Submit" type="submit" class="bttn" value="Add to Cart" /></td>

                                        <input name="product_id" type="hidden"  value="<?=$row['ProductID'];?>" />

                                        <input name="quantity" type="hidden"  value="1" />

                                      </tr>

                                    </table></td>

                                    <td background="images/mid_bgline2.gif" style="background-repeat:no-repeat;">&nbsp;</td>

                                </form>

                                  </tr>

                                </table></td>

                                 

                                 <?php if($i%2 == 0) { 

                                          echo "</tr><tr>";

                                    }else{

                                      echo "<td width=\"5%\">&nbsp;</td>";

                                    

                                    }

                                    $i++;

                                 ?>

                                         

                                <?php 

                                   

                                } ?>

                                <!-- indivisula item ends here -->

                              

                          </table>

                          <?php }else{ echo '<font color="#FF0000" >! Products Not Exits</font>';}?>

                          </td>

                        </tr>

__________________
auto parts parts

April 15th, 2007, 03:47 PM

SanDiegoEcom

Registered User

Join Date: Mar 2007

Location: San Diego, California

Posts: 4

Time spent in forums: 29 m 58 sec
Reputation Power: 0

You're not calling out....

the product description anywhere. There should be a column in the database called 'ProductDescription' or 'Description' or something.

Example:
<?=$row['ProductDescription'];?>

Comments on this post

evmikna agrees: Exactly

April 16th, 2007, 02:44 PM