Member Avatar for vipula65

Hi I have this script to show items in the database. but it is not showing the results. Pls can anyone help?

<html>

<div><br/><center><h2><font face="Lucida Handwriting" size="+1" color="#00CCFF">Casual Shirts</font></h2></center></div>
<div style="width:100%;float:left" >
<?php
include("config.php");
$dress=$_REQUEST['dress'];
$catg=$_REQUEST['catg'];
$subcatg=$_REQUEST['subcatg'];

   $sel=mysqli_query($conn,"select * from items where catg='$catg' and subcatg='$subcatg'");
   echo"<form method='post'><table border='0' align='center'><tr>";
   $n=1;
    while($arr=mysqli_fetch_array($sel))
   {
   $i=$arr['itemno'];
    if($n%4==0)
    {
    echo "<tr>";
    }
   echo "
   <td height='280' width='240' align='center'><img src='admin/itempics/$i.jpg' height='200' width='200'><br/>

 <b>Item No:</b>".$arr['itemno'].
   "<br><b>Price:</b>Rs&nbsp;".$arr['price'].
   "<br><b>Description:</b>".$arr['desc']."
   <br><br><a href='index.php?con=12 & itemno=$i'><img src='images/MetalPlakDa5new.gif' width='70' height='20'/></a>
      <a href='index.php?con=14 & itemno=$i'><img src='images/view7.jpg' width='70' height='20'/></a>
   </td>";
  $n++;

   }
      echo "</tr></table>
       </form>";
    ?>
<div><br>
<marquee behavior="scroll"  dir="ltr" align="absbottom"><img src="usepics/logo5.jpg" width="100" height="70"/>
<img src="usepics/logo11.jpg" width="100" height="70"/>
<img src="usepics/logo12.jpg" width="100" height="70"/><img src="usepics/logo8.jpg" width="100" height="70"/><img src="usepics/logo6.jpg" width="100" height="70"/>
<img src="usepics/logo4.jpg" width="100" height="70"/>
<img src="usepics/logo3.jpg" width="100" height="70"/>

<img src="usepics/logo13.jpg" width="100" height="70"/> <img src="usepics/logo15.jpg" width="100" height="70"/>
<img src="usepics/logo1.jpg" width="100" height="70"/> <img src="usepics/logo2.jpg" width="100" height="70"/><img src="usepics/logo14.jpg" width="100" height="70"/><img src="usepics/logo9.jpg" width="100" height="70"/>
</marquee>
</div>
    </div>
</body>
</html>
  • 2 Contributors
  • 1 Reply
  • 258 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by andrevanzuydam
Member Avatar for andrevanzuydam

Hi Vipula

Not knowing what is in your config file, you have a couple of places your code could fail:

  1. Database connection is not correct - global variable $conn is not correct - test with a var_dump, is mysqli extension installed?
  2. Your SQL, echo out your select statement and test against the database using work bench or similar client
  3. Your query may be 100% but your request variables may not have the correct data
  4. Html tag error ? You may need to close your before you open the new one on line 19.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.