hi
i am new to this forum. i am able to add image file(a.jpg) to mysql databse. when i see the file in a databse . i could see the file.but when i try to retrive that file ia m getting error.can anybody help me
thanks
<table width="816" height="377" border="0" cellpadding="1" cellspacing="1" bordercolor="#000000" >
<tr>
<th height="212" scope="col" align="left" valign="top">
<p class="style11 style5">
<?
@ $rpp; //Records Per Page
@ $cps; //Current Page Starting row number
@ $lps; //Last Page Starting row number
@ $a; //will be used to print the starting row number that is shown in the page
@ $b; //will be used to print the ending row number that is shown in the page
/////////////////////////////////////////////////////////////////////////////////
//Database connection
/////////////////////////////////////////////////////////////////////////////////
$database="cinemetrics";
@mysql_connect("localhost","","");
@mysql_select_db($database) or die( "Unable to select database");
$user=$_SESSION['username'];
$folder="upload/profile_img/110x80/";
/////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to make sure when the page is loaded for the
//first time, Current Page's Starting row number is 0, i.e. 1st row from the
//table is being printed. It will change as the user will click on next.
/////////////////////////////////////////////////////////////////////////////////
if(empty($_GET["cps"]))
{
$cps = "0";
}
else
{
$cps = $_GET["cps"];
}
/////////////////////////////////////////////////////////////////////////////////
$a = $cps+1;
$rpp = "12";
$lps = $cps - $rpp; //Calculating the starting row number for previous page
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to make sure whether a link to Previous page is
//needed or not. If the user is viewing the first set of data then the link will
//be disabled, if on the next set then it will carry the $lps in its link and
//enable the link
if ($cps <> 0)
{
$prv = "<a href='viewimages.php?cps=$lps'>Previous</a>";
}
else
{
$prv = "<font color='cccccc'>Previous</font>";
}
$qry = "SELECT * FROM image WHERE username='$user'";
$result=mysql_query($qry);
$nr0=mysql_num_rows($result);
$sql = "SELECT * FROM image WHERE username='$user' LIMIT $cps, $rpp";
$data=mysql_query($sql);
$nr=mysql_num_rows($data);
/////////////////////////////////////////////////////////////////////////////////
//Following SQL Statement uses SQL_CALC_FOUND_ROWS function to calculate total
//number of rows found by the query excluding the limit function added at the
//end of the SQL statement. This is followed by second query with FOUND_ROWS()
//function which actually gives out the number of rows found.
/////////////////////////////////////////////////////////////////////////////////
$q="Select SQL_CALC_FOUND_ROWS * from paging limit $cps, $rpp";
$rs=mysql_query($q) or die(mysql_error());
$nr = mysql_num_rows($rs); //Number of rows found with LIMIT in action
$q0="Select FOUND_ROWS()";
$rs0=mysql_query($q0) or die(mysql_error());
$row0=mysql_fetch_array($rs0);
$nr0 = $row0["FOUND_ROWS()"]; //Number of rows found without LIMIT in action
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to determine whether the user has reached the
//last page of the records. For example, if we have 27 rows to print and we show
//10 rows per page, then on the third and the last page it will show seven rows
//and will say at the top that SHOWING RECORDS FROM 21 to 27. If the following
//validator is not used then it shows SHOWING RECORDS FROM 21 to 30.
/////////////////////////////////////////////////////////////////////////////////
if (($nr0 < 12) || ($nr < 12))
{
$b = $nr0;
}
else
{
$b = ($cps) + $rpp;
}
Print "<table border cellpadding=3>";
Print "<tr>";
//echo $folder;
$i=1;
$k=4;
while($info = mysql_fetch_array( $data ))
{
$cps=$cps+1;
echo "<th><td>";
?>
<?
echo "F:\phpdev\www\cinetrics\upload\profile_img\400x300\".'"$info['imagepath']"';
<a href="javascript
: void(0)" onClick="OpenNewWindow(echo "F:\phpdev\www\cinetrics\upload\profile_img\400x300\".$info['imagepath'] );" onmouseover="javascript
:window.status='Click to view Image'; return true;">
echo "<img src='".$folder.$info['imagepath']."' ></a></td></th>";
$j=fmod($i,$k);
echo $j;
if($j==0)
{
Print "</tr><tr>";
}
$i++;
}
Print "</tr>";
Print "</table>";
?>
</p> </th>
</tr>
<?
echo "<tr><td align='right' colspan=2>$prv";
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to determine whether the Next link will be
//enabled or disabled. If the user has reached the last page of the record, then
//the Next link will be disabled.
/////////////////////////////////////////////////////////////////////////////////
if ($cps == $nr0)
{
echo " | <font color='CCCCCC'>Next</font>";
}
else
{
if ($nr0 > 5)
{
echo " | <a href=' viewimages.php?cps=$cps&lps=$lps'>Next</a>";
}
}
/////////////////////////////////////////////////////////////////////////////////
?>
</tr>
</table>
change database as u have and write your filename at next and previous.i think it will work for you because it worked at my side.
Offline 
Unsolved 
