Newbie Question - an If in an Array?

From: Date: Tue, 29 Mar 2005 03:33:42 +0000
Subject: Newbie Question - an If in an Array?
Groups: php.general 
Request: Send a blank email to php-general+get-211752@lists.php.net to get a copy of this message
I'm so confused. I have an array :
    $display[] 	= "
<div class='job-date'>{$cv['dates']}</div>
    	<div class='job-title'>{$cv['job_title']}</div>
    	<div class='company'>{$cv['company']}</div>
<div class='job'>{$cv['job']}</div>"; In SOME of the rows of this table, there is a field called sidebar. I'd like to have this array include a reference to this field if it exists. I was thinking something like: if (!empty($cv['sidebar'])){ $sidebar_ref = "
      <div class='sidebar_ref_box'><a href='../sidebars/index.htm?s={$cv['sidebar']}' title='Sidebar'>Learn More</a></div>"
}; Can anyone offer some help? Thanks. The whole script is below: <?php /* invalid or missing GET? */ if (!isset($_GET['r']) || empty($_GET['r']) || !($r = intval($_GET['r']))) {
    // show a plain vanilla index
    include('/path/to/docs/cv.include.php');
    exit;
} /* With a valid $r, make some variables to help build the SQL query * Note three conditions join the tables yes we are aware of that */
$fields    =  'cv.cv_id,cv.category,dates,cv.job_title,cv.company,cv.job,cv.sort,cv.sidebar,jobcat.category';
$where     = "WHERE cvjobcats.cv_id=cv.cv_id
	      AND cvjobcats.jobcat_id = '$r'
              AND jobcat.jobcat_id=cvjobcats.jobcat_id";
$restables = "cv, cvjobcats, jobcat";
$sort      = "ORDER BY cv.sort";
/* Finally the actual SQL query, using the variables just set * do we have a valid mysql result resource? */ if (!($result = mysql_query("SELECT $fields FROM $restables $where $sort"))) { echo "Could not successfully run query ($sql) from DB: " . mysql_error(); exit; } /* do we have any records? if not show the list/menu */ if (mysql_num_rows($result) == 0) { include_once('/path/to/docs/cv.include.php'); exit; } $display = array(); // this is merely an array initialization unset($cat); while ($cv = mysql_fetch_assoc($result)) {
    /* set the category name for display in the output */
    if (!isset($cat)) {
    	$cat = $cv['category'];
    }
/*$sidebar_ref = array(); while ($cv = mysql_fetch_assoc($result)) {
      if (!empty($cv['sidebar'])){
$sidebar_ref [] = "
      <div class='sidebar_ref_box'><a href='../sidebars/index.htm?s={$cv['sidebar']}' title='Sidebar'>Learn More</a></div>"
}; }*/
    /* make an array of jobs which includes the HTML to be displayed
     * in the HTML page when we make one...
     */
    $display[] 	= "
<div class='job-date'>{$cv['dates']}</div>
    	<div class='job-title'>{$cv['job_title']}</div>
    	<div class='company'>{$cv['company']}</div>
<div class='job'>{$cv['job']}</div>"; } /* be nice - tell mysql to free the resultset */ mysql_free_result($result); /* * And now, wrap up the PHP and make the page... */ echo "<?xml version='1.0' ?>\n"; ?> <!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" xml:lang="en" lang="en"> <head> <title>Resume </title> <link rel='stylesheet' href='http://domain.com/docs/style.css' type='text/css' /> </head> <body> <!-- CALL EVERYTHING BELOW A PAGE --> <div id='page-display'> <!--START HEADER --><?php include_once "/path/to/docs/header.include.php" ?><!-- END HEADER --> <!-- BEGIN LEFT SIDE --> <div id='left-sidebar'> <?php include_once "/path/to/docs/left-sidebar.cv.include.php"; ?> </div> <!-- END LEFT SIDE --> <!--START MAIN CONTENT AREA--> <div id='content'> <h1>R&eacute;sum&eacute;</h1> <?php include_once "/path/to/docs/cv.$r.include.php"; ?> <div class='job-category'><?php echo $cat?></div> <?php if (sizeof($display)) { echo " <div id='table-of-contents'> "; echo join("\n\t\t", $display); echo " </div> "; } ?> </div> <!--END MAIN CONTENT AREA--> <!--BEGIN FOOTER--> <div id='footer'><?php include_once "/path/to/docs/footer.include.php" ?></div> <!--END FOOTER--> </div> <!--END PAGE--> </body> </html>

« previous php.general (#211752) next »