Accessing images from mysql database!

sadaf

I'm pretty new to php. I'm trying to display images on the webpage from mysql database. First, I saved it as longblob, and tried accessing it, but doesnt work. Then, I tried saving the file location in the database as VARCHAR, but it still doesnt work. Any suggestions??
Here's the code!

<?php

	require_once ('../mysql_connect.php'); // Connect to the db.

	$query = "SELECT * FROM `pictures` WHERE `picture_id` > 0";

	$result = mysql_query($query)or die(mysql_error());

	$num_results = mysql_num_rows($result);

echo '<P><strong>Number of items found: '.$num_results.'</strong></p>';

for ($i=0; $i <$num_results; $i++){

$row = mysql_fetch_array($result);
echo stripslashes($row['picture_id']);
$image = stripslashes($row['file_path']);
$dispimage = "<img src='C:\apache\htdocs\images\$image'>";

echo $dispimage;

}//end of for loop

Roger_Ramjet

Basic syntax error: you don't put quotes around table and column names, the db engine will treat these as values;

$query = "SELECT * FROM pictures WHERE picture_id > 0";

Should be

$query = "SELECT * FROM pictures WHERE picture_id > 0";

And , at a guess, the picture_id > 0 is redundant. I'll bet all picture ids are greater than 0 so

$query = "SELECT * FROM pictures ";

will probably do it.

sadaf

I removed quotes from the query, and changed the code to:

$row = mysql_fetch_array($result);
echo stripslashes($row[picture_id]);
$image = ($row[file_path]);
$dispimage = "<img src='$image'>";
echo $dispimage;

I can see the image by right click->Vew Image, but still see the same output with broken images!
😕