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


<div><br/><center><h2><font face="Lucida Handwriting" size="+1" color="#00CCFF">Casual Shirts</font></h2></center></div>
<div style="width:100%;float:left" >

   $sel=mysqli_query($conn,"select * from items where catg='$catg' and subcatg='$subcatg'");
   echo"<form method='post'><table border='0' align='center'><tr>";
    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><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>

      echo "</tr></table>
<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"/>

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.