Difficulties getting my images to display
Hello
I am having difficulties getting my images to display.
I am passing a url variable to my display page
My display page catches the url variable (using the code below)
However does not display image.
Any assistance in the correct coding would be greatly appreciated
<?php require_once('Connections/bari.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$colname_Recordset2 = "-1";
if (isset($_GET['PIC'])) {
$colname_Recordset2 = $_GET['PIC'];
}
mysql_select_db($database_bari, $bari);
$query_Recordset2 = sprintf("SELECT * FROM xcart_images_p WHERE imageid = %s ORDER BY imageid ASC", GetSQLValueString($colname_Recordset2, "int"));
$Recordset2 = mysql_query($query_Recordset2, $bari) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
Should display here - however no image appears.
<div id="sideleftLgProductPic"><img src="<?php echo $row_Recordset2['image']; ?>" width="395" height="326" /></div>
Regards
Mike Russavage