Newbie Question - an If in an Array?
| From: | Jackson Linux | 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ésumé</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>