display selected image from MySQL database

matty22

Hi I was hoping someone could help me with a image databasing problem that I have come accross.

I can upload images and display their names in a table list.

I have made it so each image name is a hyperlink to a page that displays
the image which has been selected. The only problem is that the image which is displayed is always the first image in the database, even though I am selecting different image names from the list.

here is my code:

This is code which displays my image names in a list

<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("cook_book") or die(mysql_error());


// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM upload") 
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>Recipe Name</th></tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table

echo "<tr><td>"; 
//echo "<img src=' ".$row['RecipeName']." '>"; 


echo $row = '<a href="'."TRY.PHP".'">'.$row['RecipeName'].'</a>';
echo "</tr></td>";

} 

echo "</table>";
?>
</body>

This is the code which is supposed to display the correct image that has been selected not just the first one in the database.

This file is named TRY.PHP

<?php

$conn = mysql_connect("localhost","root","");
$db = mysql_select_db("cook_book")
or die(mysql_error()); 

$query = mysql_query("SELECT * FROM upload");
while($row = mysql_fetch_array($query)){
echo $row['content'];

}

?>

Any help would be greatly appreciated.

bradgrafelman

matty22 wrote:
This is the code which is supposed to display the correct image that has been selected

And how is it supposed to do that? You're not passing any sort of unique identifier in the URL when they click on a recipe, so is PHP/MySQL supposed to magically figure out which link was clicked?

Assuming your DB schema is setup properly, try passing the value of whichever column uniquely identifies each row in the DB (e.g. an AUTO_INCREMENT column) in the query string to this "try.php" script. Then, modify your query in this script so that it only SELECT's the row that has this unique value.