Untitled

<?php
require('./includes/content-header.inc');

require('./includes/sql-access.inc');

start_session;

$idx_plant = $_GET["idx_plant"];

$idx_user = $_GET["idx_user"];
echo 'idx_plant = ' . $idx_plant . ', idx_user = ' . $idx_user;

$detail_query  = "select * from plant_desc where idx_plant = $idx_plant";

$query_result = mysql_query($detail_query) 
	or die('existing plant query failed: ' . mysql_error());

if ($myrow = mysql_fetch_array($query_result)) { 
	do { 

	/* assign these now so we don't lose it later */
	$pungency = $myrow["pungency"];
	$shu = $myrow["shu"];
	$species = $myrow["species"];
?>

<table align="center">
<tr>
	<td colspan=5 align="center" bgcolor="#6666CC">All Plants</td>
</tr>
<tr>
	<td>Name</td>
	<td><?php echo $myrow["name"]; ?></td>
	<td>Plant Type</td>
	<td><?php echo $myrow["plant_type"]; ?></td>
	<td></td>
</tr>
<tr>
	<td>Height</td>
	<td><?php echo $myrow["height"]; ?></td>
	<td>Spacing</td>
	<td><?php echo $myrow["spacing"]; ?></td>
	<td></td>
</tr>
<tr>
	<td>Sun Exposure</td>
	<td><?php echo $myrow["sun_exposure"]; ?></td>
	<td>Seed Collecting</td>
	<td><?php echo $myrow["seed_collecting"]; ?></td>
	<td></td>
</tr>
<tr>
	<td>Growth Habit</td>
	<td><?php echo $myrow["growth_habit"]; ?><td>
	<td>Days to Maturity</td>
	<td><?php echo $myrow["days_to_maturity"]; ?></td>
	<td></td>
</tr>
<tr>
	<td>Fruit Shape</td>
	<td><?php echo $myrow["fruit_shape"]; ?></td>
	<td>Fruit Size</td>
	<td><?php echo $myrow["fruit_size"]; ?></td>
	<td></td>
</tr>
<tr>
	<td>Fruit Color</td>
	<td><?php echo $myrow["fruit_color"]; ?></td>
	<td></td>
	<td></td>
	<td></td>
</tr>
<tr>
	<td>Seed Type</td>
	<td><?php echo $myrow["seed_type"]; ?></td>
	<td>Leaf Type</td>
	<td><?php echo $myrow["leaf_type"]; ?></td>
	<td></td>
</tr>
<tr>
	<td>Best Usage</td>
	<td><?php echo $myrow["best_usage"]; ?></td>
	<td>Disease Resistance</td>
	<td><?php echo $myrow["disease_resistance"]; ?></td>
	<td></td>
</tr>

<?php
	/* need to get the origional idx_user for this, and then put his name and post_date */
// $idx_plant = $_GET["idx_plant"];
// echo $idx_plant;
// $idx_user = $myrow["idx_user"];
$user_detail_query  = "select * from user_desc where idx_user = $idx_user";

$user_query_result = mysql_query($user_detail_query) 
	or die('existing user query failed: ' . mysql_error());

	if ($userrow = mysql_fetch_array($user_query_result)) { 
		do { 
echo $userrow["user_name"];
echo $userrow["post_date"];
		} while ($userrow = mysql_fetch_array($user_query_result)); // end of do { and while
?>

<tr>
	<td>Submitter's Name</td>
	<td><?php //echo $userrow["user_name"]; ?></td>
	<td>Date Posted</td>
	<td><?php //echo $userrow["post_date"]; ?></td>
	<td></td>
</tr>

<?php


	/* only display this next section if the plant is a pepper */
?>


<tr bordercolor="#CC9933">
	<td colspan=5 align="center" bgcolor="#CC9933">Peppers Only</td>
</tr>


<tr bordercolor="#CC9933">
	<td bgcolor="#CC9933">Relative Pungency</td>
	<td><?php echo $myrow["pungency"]; ?></td>
	<td bgcolor="#CC9933">Reported SHU's</td>
	<td><?php echo $myrow["shu"]; ?></td>
	<td></td>
</tr>
<tr bordercolor="#CC9933">
	<td bgcolor="#CC9933">Species</td>
	<td><?php echo $myrow["species"]; ?></td>
	<td></td>
	<td></td>
	<td></td>
</tr>


<tr>
	<td>Comments (all plants)</td>
	<td colspan=4></td>
</tr>
<tr>
	<td colspan="5"><?php echo $myrow["creator_comments"]; ?></td>
</tr>
<tr>
	<td></td>
	<td></td>

</tr>
<?php
/*
<tr>
	<td></td>
	<td><input type="submit" name="submit"></td>
	<td></td>
	<td><input type="reset" name="reset"></td>
	<td></td>
</tr>
*/
?>
</table>
<?php
			} while ($myrow = mysql_fetch_array($query_result)); 
//			echo "</table>\n";
	//}


?>