displaying a single databse entry

chuddyuk

I am trying to make a script that will show products from the database, which works fine. also when the user clicks the image it opens a pop-up window and a larger image will be displayed.
everything works fine except when the image is clicked i get the larger image plus the other products from the page before! here is my code and a link to the site, its probably easier to work out my problem if you see it. any help is much appreciated

thanks 😃

<? 


include("file.php"); 


$result = 
@MySQL_Query("select * from koruproduct");
while ($ex = 
@MySQL_Fetch_Array($result)){

$id = $ex["id"];
$code = $ex["code"];
$type = $ex["type"];
$price = $ex["price"];
$imagefull = $ex["imagefull"];
$imagethumb = $ex["imagethumb"];
$keyword = $ex["keyword"];

switch($_GET['product']){

case ($id):
?>

<div class="productlarge">
<div><? echo"<img src=images/products/$imagefull.jpg"; ?>></div>
</div>
<?
break;

default:
?>
<div class="product">
<div class="producttop"><? echo "$code<br>$type";?></div>
<div><? echo"<a href=javascript:popUp('show.php?product=$id')><img src=images/products/$imagethumb.jpg"; ?>></a></div>
<div><? echo"$price";?></div>
</div>
<?
break;

}
}
?>

Page where problem is

chuddyuk

Does no1 understand my problem? 🙂

bradgrafelman

What I don't understand is your logic in the coding. Why would you use a switch() statement here?!

I don't even know where to begin rewriting this... is the page source you're showing us for show.php? Or is that index.php ?

chuddyuk

Im a total newb to this, so sorr if the code is bad. the code is show.php.
all i want is for when the user clicks the link a pop up apears with the larger image in. what is the best way to do this?

esukf

try

<?php

$id = $_GET['product'];

$sql = "SELECT imagefull FROM koruproduct WHERE id = '$id' LIMIT 1;";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

$imagefull = $row["imagefull"];

echo '<div class="productlarge">';
echo '<div><img src="images/products/'.$imagefull.'.jpg"></div>';
echo '</div>';


?>

chuddyuk

get an error

http://korucontemporary.co.uk/dev/index.php

can you explain what this code is doing please?

esukf

On your index.php page you should have a list of product generated from your database with thumbnail pictures with links like

<a href=javascript:popUp('show.php?product=1')><img src=images/products/imagethumb.jpg"></a>

Now when a user clicks the link it will load show.php with the product id being passed in the querystring.

<?php

//show.php

//connect to your database
mysql_connect('localhost', 'your_db_username', 'your_db_password');
mysql_select_db("your_db_name");

$id = $_GET['product']; //get the product id using GET

//SQL to get imagefull name from db
$sql = "SELECT imagefull FROM koruproduct WHERE id = '$id' LIMIT 1;";  

$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

$imagefull = $row["imagefull"];

//echo html
echo '<div class="productlarge">';
echo '<div><img src="images/products/'.$imagefull.'.jpg"></div>';
echo '</div>';


?>