[RESOLVED] Issue getting dynamic image from table

[dmacman1962]

Hi All,

I did a bunch of searches and all of them had way more complicated code than I could apply, so I will post my question.

I have an image that the image name is in my mysql table.

All I need to do is get the name from the query (which is based on the product ID for that page) and display the logo.

Here is my code so far.

<?PHP
//get the item from the table

$sql = "SELECT prodGroup, prodName, prodDesc, prodDetails, prodType, prodTeacherRecc, prodColor, prodImgDim, prodLogo, prodImgAlt, ";
$sql.= "prodIsCC, prodRuntime, prodMetaDesc, prodMetaKeywords FROM tblProduct WHERE prodID=" . $prodID;
$result=@mysql_query($sql);
$row = mysql_fetch_array($result, MYSQL_ASSOC);


//display the image

<img src="http://www.intheclassroom.org/noFrames/images/'<?PHP echo $row['prodLogo']; ?>'" width="100" Height="50">

That is only the code for the image that I am having issues with.

I do not get an error, just "" for the image name in the source code for the page.

Thanks in advance,

Don

[devinemke]

<?php
// connect to db first

$result = mysql_query("SELECT * FROM tblProduct WHERE prodID = '$prodID'") or exit(mysql_error());
if (mysql_num_rows($result))
{
	$row = mysql_fetch_assoc($result);
	echo '<img src="http://www.intheclassroom.org/noFrames/images/' . $row['prodLogo'] . '" width="100" Height="50">';
}
else
{
	echo 'no records matching that search criteria';
}
?>

[dmacman1962]

As always, devinemke, to the rescue!!!

Thanks a bunch, that worked perfectly.

I owe you another one, I think I'm up to about 1500!

Thanks,

Don