Link to home
Start Free TrialLog in
Avatar of theodawson
theodawsonFlag for United States of America

asked on

Inserting graphics based on conditions specified in recordsets (sql).

I've created a figure that shows levels of performance using PHP mysql and Dreamweaver recordsets to specify the criteria for selecting the appropriate figure. Each of the vertical cells in the figure could be occupied by a graphic if certain conditions were met. In the example, only one set of conditions is met (for the LDMA column). The other columns represent missing values. The values are indeed missing. There is not problem in that regard. The issue is: How do I get rid of the boxes with the question marks?
// Code for the graphics 


  <img src="../images/stars/ScaleNos.gif" width="38" height="430" hspace="0" align="top" /><img src="<?php echo $row_rsLasartEthics['stars']; ?>" width="38" height="430" hspace="0" border="0" align="top" class="scalelera" /><img src="<?php echo $row_rsLasartEthics2['stars']; ?>" alt="" width="38" height="430" hspace="0" border="0" align="top" class="scalelera" /><img src="<?php echo $row_rsLasartEthics3['stars']; ?>" alt="" width="38" height="430" hspace="0" border="0" align="top" class="scalelera" /><img src="<?php echo $row_rsLasartEthics4['stars']; ?>" alt="" width="38" height="430" hspace="0" border="0" align="top" class="scalelera" /></div>

Recordset sql for one of the images:


$colname_rsLasartSelf = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartSelf = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartSelf = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LSUAscores.lsuakey, LSUAscores.lasname, LSUA.testtime, LSUA.UserNo, LSUA.lsuakey FROM Lasart, LSUAscores, LSUA WHERE LSUA.UserNo=%s AND Lasart.lasname = LSUAscores.lasname AND LSUAscores.lsuakey=LSUA.lsuakey AND LSUA.testtime=1", GetSQLValueString($colname_rsLasartSelf, "int"));
$rsLasartSelf = mysql_query($query_rsLasartSelf, $Assessment) or die(mysql_error());
$row_rsLasartSelf = mysql_fetch_assoc($rsLasartSelf);
$totalRows_rsLasartSelf = mysql_num_rows($rsLasartSelf);

Open in new window

Example.tiff
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Hi theodawson,

"The values are indeed missing."

This can be handled by a little bit of logic in the body of the file.  Without seeing the whole document, I'd have to guess but something like this:

<?php if (!is_null($row_rsLasartSelf['theFieldName'])) { ?>
    image HTML code here
<?php } else { ?>
    &nbsp;
<?php } ?>

So if theFieldName is not null, show image.  Otherwise, just put a non-breaking space or whatever.

Avatar of theodawson

ASKER

This did not help. I'm very good with Dreamweaver, but not so good with code. I know that I need a statement that says what to do if the return is null, but I don't know how to do it. I need to know exactly what to do in this instance. I've provided the code for the entire page so you can see how it is being handled now.
<?php require_once('../Connections/Assessment.php'); ?>
<?php
// Load the tNG classes
require_once('../includes/tng/tNG.inc.php');

// Make unified connection variable
$conn_Assessment = new KT_connection($Assessment, $database_Assessment);

//Start Restrict Access To Page
$restrict = new tNG_RestrictAccess($conn_Assessment, "../");
//Grand Levels: Level
$restrict->addLevel("1");
$restrict->addLevel("2");
$restrict->addLevel("3");
$restrict->addLevel("4");
$restrict->Execute();
//End Restrict Access To Page

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_rsRegistrants = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsRegistrants = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsRegistrants = sprintf("SELECT UserNo, firstname, lastname FROM Registrants WHERE UserNo = %s", GetSQLValueString($colname_rsRegistrants, "int"));
$rsRegistrants = mysql_query($query_rsRegistrants, $Assessment) or die(mysql_error());
$row_rsRegistrants = mysql_fetch_assoc($rsRegistrants);
$totalRows_rsRegistrants = mysql_num_rows($rsRegistrants);

$colname_rsLasartRJ = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartRJ = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartRJ = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LRJA.UserNo, LRJA.LRJAno, LRJAscores.LRJAno, LRJAscores.lasname, LRJA.testtime, LRJA.ManagerStatus FROM Lasart, LRJAscores, LRJA WHERE LRJA.UserNo=%s AND Lasart.lasname = LRJAscores.lasname AND LRJAscores.LRJAno=LRJA.LRJAno AND LRJA.testtime = 1", GetSQLValueString($colname_rsLasartRJ, "int"));
$rsLasartRJ = mysql_query($query_rsLasartRJ, $Assessment) or die(mysql_error());
$row_rsLasartRJ = mysql_fetch_assoc($rsLasartRJ);
$totalRows_rsLasartRJ = mysql_num_rows($rsLasartRJ);

$colname_rsLasartEthics = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartEthics = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartEthics = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LERA.UserNo, LERA.lerakey, LERAscores.lerakey, LERAscores.lasname, LERA.testtime FROM Lasart, LERAscores, LERA WHERE LERA.UserNo=%s AND Lasart.lasname = LERAscores.lasname AND LERAscores.lerakey=LERA.lerakey AND LERA.testtime = 1", GetSQLValueString($colname_rsLasartEthics, "int"));
$rsLasartEthics = mysql_query($query_rsLasartEthics, $Assessment) or die(mysql_error());
$row_rsLasartEthics = mysql_fetch_assoc($rsLasartEthics);
$totalRows_rsLasartEthics = mysql_num_rows($rsLasartEthics);

$colname_rsLasartSelf = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartSelf = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartSelf = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LSUAscores.lsuakey, LSUAscores.lasname, LSUA.testtime, LSUA.UserNo, LSUA.lsuakey FROM Lasart, LSUAscores, LSUA WHERE LSUA.UserNo=%s AND Lasart.lasname = LSUAscores.lasname AND LSUAscores.lsuakey=LSUA.lsuakey AND LSUA.testtime=1", GetSQLValueString($colname_rsLasartSelf, "int"));
$rsLasartSelf = mysql_query($query_rsLasartSelf, $Assessment) or die(mysql_error());
$row_rsLasartSelf = mysql_fetch_assoc($rsLasartSelf);
$totalRows_rsLasartSelf = mysql_num_rows($rsLasartSelf);

$colname_rsLasartDM = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartDM = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartDM = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LDMA.UserNo, LDMA.ldmakey, LDMAscores.lasname, LDMAscores.ldmakey, LDMA.testtime, LDMA.manlevel FROM Lasart, LDMA, LDMAscores WHERE LDMA.UserNo=%s AND Lasart.lasname = LDMAscores.lasname AND LDMAscores.ldmakey=LDMA.ldmakey AND LDMA.testtime = 1", GetSQLValueString($colname_rsLasartDM, "int"));
$rsLasartDM = mysql_query($query_rsLasartDM, $Assessment) or die(mysql_error());
$row_rsLasartDM = mysql_fetch_assoc($rsLasartDM);
$totalRows_rsLasartDM = mysql_num_rows($rsLasartDM);

$colname_rsLasartLL = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartLL = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartLL = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LLRA.UserNo, LLRA.llrakey, LLRAscores.lasname, LLRAscores.llrakey, LLRA.testtime FROM Lasart, LLRA, LLRAscores WHERE LLRA.UserNo=%s AND Lasart.lasname = LLRAscores.lasname AND LLRAscores.llrakey=LLRA.llrakey AND LLRA.testtime = 1", GetSQLValueString($colname_rsLasartLL, "int"));
$rsLasartLL = mysql_query($query_rsLasartLL, $Assessment) or die(mysql_error());
$row_rsLasartLL = mysql_fetch_assoc($rsLasartLL);
$totalRows_rsLasartLL = mysql_num_rows($rsLasartLL);

$colname_rsLasartIR = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartIR = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartIR = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LIMA.UserNo, LIMA.limakey, LIMAscores.lasname, LIMAscores.limakey, LIMA.testtime FROM Lasart, LIMA, LIMAscores WHERE LIMA.UserNo=%s AND Lasart.lasname = LIMAscores.lasname AND LIMAscores.limakey=LIMA.limakey AND LIMA.testtime = 1", GetSQLValueString($colname_rsLasartIR, "int"));
$rsLasartIR = mysql_query($query_rsLasartIR, $Assessment) or die(mysql_error());
$row_rsLasartIR = mysql_fetch_assoc($rsLasartIR);
$totalRows_rsLasartIR = mysql_num_rows($rsLasartIR);

$colname_rsRegistrant = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsRegistrant = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsRegistrant = sprintf("SELECT UserNo, firstname, lastname FROM Registrants WHERE UserNo = %s", GetSQLValueString($colname_rsRegistrant, "int"));
$rsRegistrant = mysql_query($query_rsRegistrant, $Assessment) or die(mysql_error());
$row_rsRegistrant = mysql_fetch_assoc($rsRegistrant);
$totalRows_rsRegistrant = mysql_num_rows($rsRegistrant);

$colname_rsLasartEthics2 = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartEthics2 = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartEthics2 = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LERA.UserNo, LERA.lerakey, LERAscores.lerakey, LERAscores.lasname, LERA.testtime FROM Lasart, LERAscores, LERA WHERE LERA.UserNo=%s AND Lasart.lasname = LERAscores.lasname AND LERAscores.lerakey=LERA.lerakey AND LERA.testtime = 2", GetSQLValueString($colname_rsLasartEthics2, "int"));
$rsLasartEthics2 = mysql_query($query_rsLasartEthics2, $Assessment) or die(mysql_error());
$row_rsLasartEthics2 = mysql_fetch_assoc($rsLasartEthics2);
$totalRows_rsLasartEthics2 = mysql_num_rows($rsLasartEthics2);

$colname_rsLasartEthics3 = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartEthics3 = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartEthics3 = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LERA.UserNo, LERA.lerakey, LERAscores.lerakey, LERAscores.lasname, LERA.testtime FROM Lasart, LERAscores, LERA WHERE LERA.UserNo=%s AND Lasart.lasname = LERAscores.lasname AND LERAscores.lerakey=LERA.lerakey AND LERA.testtime = 3", GetSQLValueString($colname_rsLasartEthics3, "int"));
$rsLasartEthics3 = mysql_query($query_rsLasartEthics3, $Assessment) or die(mysql_error());
$row_rsLasartEthics3 = mysql_fetch_assoc($rsLasartEthics3);
$totalRows_rsLasartEthics3 = mysql_num_rows($rsLasartEthics3);

$colname_rsLasartEthics4 = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsLasartEthics4 = $_SESSION['kt_login_id'];
}
mysql_select_db($database_Assessment, $Assessment);
$query_rsLasartEthics4 = sprintf("SELECT Lasart.lasartkey, Lasart.lasname, Lasart.stars, LERA.UserNo, LERA.lerakey, LERAscores.lerakey, LERAscores.lasname, LERA.testtime FROM Lasart, LERAscores, LERA WHERE LERA.UserNo=%s AND Lasart.lasname = LERAscores.lasname AND LERAscores.lerakey=LERA.lerakey AND LERA.testtime = 4", GetSQLValueString($colname_rsLasartEthics4, "int"));
$rsLasartEthics4 = mysql_query($query_rsLasartEthics4, $Assessment) or die(mysql_error());
$row_rsLasartEthics4 = mysql_fetch_assoc($rsLasartEthics4);
$totalRows_rsLasartEthics4 = mysql_num_rows($rsLasartEthics4);
?>
<div style="display:none"><%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%></div>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/template2php.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>DTS: LERA lectagraph</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.left {
	float: left;
	width: 370px;
}
.right {
	float: right; /* since this element is floated, a width must be given */
	width: 300px;
	margin: 0px;
	padding: 0px;
}
-->
</style>
<!-- InstanceEndEditable -->
<style type="text/css"> 
<!-- 
body  {
	margin: 0; /* it's good practice to zero the margin and padding of the body element to account for differing browser defaults */
	padding: 0; /* this centers the container in IE 5* browsers. The text is then set to the left aligned default in the #container selector */
	color: #474A47;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 11px;
	background-color: #929292;
}
.twoColFixRtHdr #container {
	width: 780px;
	margin: 0 auto;
	text-align: left;
	border: 1px solid #474A47;
	background-color: #F4F6F2;
} 
.twoColFixRtHdr #header {
	background-image: url(../images/skin/header2.jpg);
	height: 70px;
	padding-top: 0;
	padding-right: 0px;
	padding-bottom: 0;
	padding-left: 0px;
} 
.twoColFixRtHdr #menu1 {
	height: 20px;
	padding-top: 4;
	padding-right: 27px;
	padding-bottom: 0;
	padding-left: 17px;
	background-color: #777E79;
	background-image: url(../images/skin/menu2.jpg);
	color: #E2E2E2;
	margin-top: 0px;
} 
.twoColFixRtHdr #menu2 {
	height: 20px;
	padding-top: 0;
	padding-right: 0px;
	padding-bottom: 0;
	padding-left: 17px;
	background-color: #474A47;
	background-image: url(../images/skin/menu2.jpg);
} 
.twoColFixRtHdr #spacer1 {
	background-color: #E2E2E2;
	height: 20px;
} 
.twoColFixRtHdr #header h1 {
	margin: 0; /* zeroing the margin of the last element in the #header div will avoid margin collapse - an unexplainable space between divs. If the div has a border around it, this is not necessary as that also avoids the margin collapse */
	padding: 10px 0; /* using padding instead of margin will allow you to keep the element away from the edges of the div */
}
.twoColFixRtHdr #mainContent {
	margin-top: 0;
	margin-right: 0px;
	margin-bottom: 0;
	margin-left: 0;
	padding-top: 0;
	padding-right: 46px;
	padding-bottom: 0;
	padding-left: 46px;
} 
.twoColFixRtHdr #footer {
	background-image: url(../images/skin/footer2.jpg);
	height: 70px;
	padding-top: 0;
	padding-right: 10px;
	padding-bottom: 0;
	padding-left: 20px;
} 
.twoColFixRtHdr #footer p {
	margin: 0; /* zeroing the margins of the first element in the footer will avoid the possibility of margin collapse - a space between divs */
	padding: 10px 0; /* padding on this element will create space, just as the the margin would have, without the margin collapse issue */
}
.fltrt { /* this class can be used to float an element right in your page. The floated element must precede the element it should be next to on the page. */
	float: right;
	margin-left: 8px;
}
.fltlft { /* this class can be used to float an element left in your page */
	float: left;
	margin-right: 8px;
}
.clearfloat { /* this class should be placed on a div or break element and should be the final element before the close of a container that should fully contain a float */
	clear:both;
    height:0;
    font-size: 1px;
    line-height: 0px;
}
--> 
</style><!--[if IE 5]>
<style type="text/css"> 
/* place css box model fixes for IE 5* in this conditional comment */
.twoColFixRtHdr #sidebar1 { width: 220px; }
</style>
<![endif]--><!--[if IE]>
<style type="text/css"> 
/* place css fixes for all versions of IE in this conditional comment */
.twoColFixRtHdr #sidebar1 { padding-top: 30px; }
.twoColFixRtHdr #mainContent { zoom: 1; }
/* the above proprietary zoom property gives IE the hasLayout it needs to avoid several bugs */
</style>
<![endif]-->
<link href="../css/styleassessments.css" rel="stylesheet" type="text/css" />
<script src="../SpryAssetsTemplates1/SpryMenuBar.js" type="text/javascript"></script>
<link href="../SpryAssetsTemplates1/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
</head>

<body class="twoColFixRtHdr">

<div id="container">
  <div id="spacer1">
  <!-- end #spacer1 --></div>
  <div id="header">
  <!-- end #header --></div>
  <div id="menu1">
    <div align="right" class="logintext">
      <!-- end #menu1 -->
      You are logged in as <?php echo $row_rsRegistrants['firstname']; ?> <?php echo $row_rsRegistrants['lastname']; ?></div>
  </div>
  <div id="mainContent"> <!-- InstanceBeginEditable name="main" -->
    <h1>LERA Lectagraph for  <?php echo $row_rsRegistrant['firstname']; ?> <?php echo $row_rsRegistrant['lastname']; ?> </h1>
    <p>More lectagraphs: <a href="lectagraph1.php">test time 1</a> | <a href="lectagraph2.php">test time 2</a> | <a href="lectagraph3.php">test time 3</a> | <a href="lectagraph_ldma.php">LDMA</a> | <a href="lectagraph_lera.php">LERA</a> | <a href="lectagraph_llra.php">LLRA</a> | <a href="lectagraph_lrja.php">LRJA</a> | <a href="lectagraph_lsua.php">LSUA</a> | <a href="lectagraph_lima.php">LIMA</a> | <a href="../assessments/select_assess.php">select an assessment</a></p>
    <p>&nbsp;</p>
    <p></p>
<div class="left">
  <img src="../images/stars/ScaleNos.gif" width="38" height="430" hspace="0" align="top" /><img src="<?php echo $row_rsLasartEthics['stars']; ?>" width="38" height="430" hspace="0" border="0" align="top" class="scalelera" /><img src="<?php echo $row_rsLasartEthics2['stars']; ?>" alt="" width="38" height="430" hspace="0" border="0" align="top" class="scalelera" /><img src="<?php echo $row_rsLasartEthics3['stars']; ?>" alt="" width="38" height="430" hspace="0" border="0" align="top" class="scalelera" /><img src="<?php echo $row_rsLasartEthics4['stars']; ?>" alt="" width="38" height="430" hspace="0" border="0" align="top" class="scalelera" /></div>
<div class ="right">
	<h3>Reports</h3>
    <p>Select one of the following links to view the report associated with a given score: </p>
    <p><a href="../codingLERA/lerareport.php?lerakey=<?php echo $row_rsLasartEthics['lerakey']; ?>&amp;lasname=<?php echo $row_rsLasartEthics['lasname']; ?>">LERA 1</a> | <a href="../codingLERA/lerareport.php?lerakey=<?php echo $row_rsLasartEthics2['lerakey']; ?>&amp;lasname=<?php echo $row_rsLasartEthics['lasname']; ?>">LERA 2</a> | <a href="../codingLERA/lerareport.php?lerakey=<?php echo $row_rsLasartEthics3['lerakey']; ?>&amp;lasname=<?php echo $row_rsLasartEthics3['lasname']; ?>">LERA 3</a> | <a href="../codingLERA/lerareport.php?lerakey=<?php echo $row_rsLasartEthics4['lerakey']; ?>&amp;lasname=<?php echo $row_rsLasartEthics4['lasname']; ?>">LERA 4</a></p>
    </div>
<br class="clearfloat" />   
<p>&nbsp;</p>
    <p>&nbsp;</p>
  <!-- InstanceEndEditable -->
  <!-- end #mainContent --></div>
	<!-- This clearing element should immediately follow the #mainContent div in order to force the #container div to contain all child floats --><br class="clearfloat" />
  <div id="menu2">
<div>
  <ul id="MenuBar1" class="MenuBarHorizontal">
    <li><a href="../index.html">home</a></li>
    <li><a href="../assessments/select_assess.php">select an assessment</a></li>
    <li><a href="../logout.php">log out</a></li>
    <li><a href="../contactus.php">contact us</a></li>
  </ul>
</div>
<!-- end #menu2 --></div>
  <div id="footer">
    <p>&nbsp;</p>
  <!-- end #footer --></div>
  <!-- end #container -->
</div>
<script type="text/javascript">
<!--
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
//-->
</script>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($rsLasartSelf);

mysql_free_result($rsLasartLL);

mysql_free_result($rsLasartIR);

mysql_free_result($rsRegistrant);

mysql_free_result($rsLasartEthics2);

mysql_free_result($rsLasartEthics3);

mysql_free_result($rsLasartEthics4);

mysql_free_result($rsLasartRJ);

mysql_free_result($rsLasartEthics);

mysql_free_result($rsRegistrants);

mysql_free_result($rsLasartDM);
?>

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Exactly the kind of information I needed.
Yeah, sorry about that.  I did say in my first post that I was just guessing based on the really restricted view of the code you gave.  Once I was able to see the whole thing it became a lot easier.
I often have difficulty framing my question. Your first response helped me to do a better job.
I'm wondering now if there is a way to add a placeholder image.
Yes, absolutely.   Just add the image code below the other image.  Highlight it and do Show Region If Recordset is Empty.  The trick is not to nest the Show Region behaviors so make sure you have just the image tag highlighted before inserting the code.
So, I did this:


      <?php if ($totalRows_rsLasartLL > 0) { // Show if recordset not empty ?>
        <img src="<?php echo $row_rsLasartLL['stars']; ?>" width="38" height="430" hspace="0" align="top" class="scalellra" />
        <?php } // Show if recordset not empty ?>
        <?php if ($totalRows_rsLasartLL == 0) { // Show if recordset empty ?>
          <a href="../images/stars/ScaleLLRA.png"><img src="<?php echo $row_rsLasartLL['stars']; ?>" width="38" height="430" hspace="0" align="top" class="scalellra" /></a>
          <?php } // Show if recordset empty ?>

And the image I intended shows up, but it has a box with a question mark in the middle...
Remove this part from the second set of code:

<img src="<?php echo $row_rsLasartLL['stars']; ?>

That's not going to work if the recordset is null :)
You need to use an actual placeholder image instead of the pull from the database...
Yes. I've got it! Wonderful. Should I have asked my second question as a follow on? Am I depriving you of points?
Check my profile.  I have enough points to survive a follow up now and again :)
How might I go about hiring you for a specific job? Since the Developer Toolbox is no longer being supported by Adobe, we're really hurting. I have not found a good substitute for their feature-laded dynamic tables. We're thinking of hiring someone to make us a widget or extension.
Dynamic lists, I mean.
My email is in my profile.  If you are thinking of moving away from the ADDT, I highly recommend looking at WebAssist as a replacement.
We aren't a commerce website and most of their stuff just doesn't fit what we do. I can't find your email.
I found the email address.
>> and most of their stuff just doesn't fit what we do. I can't find your email.

Not totally true, you just need to learn your way around their terminology
sent a message from devtestservice