[williamh26]

I have images in a filed named images i have this code but it does no product any results can you guys help me pleaseeee

Code:

<?php

 $error = "Could not connect to the database";
 mysql_connect('localhost','root','')   or die($error);
 mysql_select_db('hairsalon') or die($error);
 //max displayed per page
 $per_page = 2;

 //get start varible

 $start = $_GET['start'];

 //count records

 $record_count = mysql_num_rows (mysql_query("SELECT * FROM products"));

 //count max pages

 $max_pages = $record_count / $per_page; // may come out as decimal

 if (!$start)
    $start =0;

 //display data

 $get = mysql_query("SELECT  prodid, picturename  FROM products ORDER BY name LIMIT $start, $per_page");


  while ($row = mysql_fetch_assoc($get))
  {
     // get data
        $prodid = $row['prodid'];
       
        $picturename = $row['picturename'];

      echo "<a href=\"index.php?&content=updatetutor&id=$prodid\">";
    
      echo strtoupper("<td class = 'servBodL' width= 30%>$picturename</td>");
      echo "<p>";
  }
    echo" </table> ";
   echo"<br>\n";
   //SETUP PREV AND NEXT VARIABLES

   $prev = $start - $per_page;

   $next = $start + $per_page;

   // show pre button

   if(!($start< 1))

   echo "<a href='index.php?content=ourproducts&start=$prev'>Prev</a>\n";
   //show page numbers

   //set variable for first page

   $i=1;

   for($x=0; $x<$record_count; $x=$x+$per_page)
   {

     if($start!=$x)

     echo "<a href='index.php?content=ourproducts&start=$x'>$i</a>\n";

     else

     echo "<a href='index.php?content=ourproducts&start=$x'>$i</b></a>\n";
     $i++;
   }


    if (!($start>=$record_count=$per_page))
   echo "<a href='index.php?content=ourproducts&start=$next'>Next</a>\n";

   echo "<br>";
?>

[erthomp143]

Ok, I take it that you have a database that holds the image name and that image is stored in a folder some where.
If that is correct you need something like this....

Code:

<img src="pathtofile/$picturename">

[williamh26]

the pictures are the folder called images

Code:

echo "<td><img src='C:\wamp\www\hairsalon2\images\$picturename'></td>";

but still does not show

[erthomp143]

if your sure your path is correct, then

Code:

echo "<td><img src='C:\wamp\www\hairsalon2\images\".$picturename."'></td>";

if that doesn't work, try this

Code:

echo "<td><img src='images/".$picturename."'></td>";