Posted: Fri Nov 11, 2005 12:50 pm
I tried to echange template_id with cat_id. And still no difference. I do not know where cat_id comes from. the only place it shows in the whole file if in this little part of the PHP code that I have included.
The complete files is:
The complete files is:
Code: Select all
<?Include("header.php");
include "g/global/database.php";
$details_id = $_GET['detailsId'];
$queryString = "SELECT * FROM members WHERE `details_id` = '$detailsId' ";
$count = 0;
$sql = mysql_query( $queryString );
while($row = mysql_fetch_array($sql)){
foreach($row AS $key => $val){
$$key = stripslashes($val);
}
$count++;
$thisTemplateId = $template_id;
$_SESSION['customerSiteTemplate'] = $thisTemplateId;
}
function dd_template($cat_id=0)
{
$text = "<option value='Select'>Select</option>";
$user_id = '118';
$sql = "SELECT cat_id, cat_name FROM members_cat where `user_id` = '".$user_id."' order by cat_name";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$text .= "<option value='$row[cat_name]'";
if ($row["cat_id"] == $cat_id)
{
$text .= " Selected";
}
$text .= "> $row[cat_name]</option>\n";
}
$text .= "</select>";
return $text;
}
function dd_team($team_id=0)
{
$text = "<option value='Select' selected='selected'>Select</option>";
//$sql = "SELECT * FROM member_teams WHERE user_id = $user_id order by team_name";
$user_id = '118';
$sql = "SELECT team_id,team_name FROM member_teams where `user_id` = '".$user_id."' order by team_name";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$text .= "<option value='$row[team_name]'";
if ($row["team_id"] == $team_id)
{
$text .= " Selected";
}
$text .= "> $row[team_name]</option>\n";
}
$text .= "</select>";
return $text;
}
?>
<div align="center">
<center>
<table border="0" cellpadding="10" style="border-collapse: collapse" bordercolor="#111111" width="770" id="AutoNumber1" height="333" bgcolor="#facb4d" cellspacing="0">
<tr>
<form name="myForm" action="savemembersAction.php" method="POST">
<tr>
<td width="178" height="19"><font face="Verdana" size="2">Team</font></td>
<td width="389" height="19" colspan="2"<font face="Verdana" size="2">
<input type="text" name="t1" size="30" value="<?php echo $team;?>"></td>
<?PHP echo "<td width=\"200\" height=\"19\" colspan=\"1\"><select size=\"1\" name=\"team\">
".dd_team()."</select></td>";
?>
</tr>
<tr>
<td width="178" height="22"><font face="Verdana" size="2">Business Name:</font></td>
<td width="589" height="22" colspan="3"><font face="Verdana">
<input type="text" name="bus_name" size="80" value="<?PHP echo $bus_name; ?>"></font></td>
</tr>
<tr>
<td width="178" height="22"><font face="Verdana" size="2">Contact Name:</font></td>
<td width="589" height="22" colspan="3"><font face="Verdana">
<input type="text" name="contact_name" size="80" value="<?PHP echo $name; ?>"></font></td>
</tr>
<tr>
<td width="178" height="19"><font face="Verdana" size="2">Phone Number:</font></td>
<td width="589" height="19" colspan="3"><font face="Verdana">
<input type="text" name="phone" size="27" value="<?PHP echo $phone; ?>"></font></td>
</tr>
<tr>
<td width="178" height="19"><font face="Verdana" size="2">eMail:</font></td>
<td width="589" height="19" colspan="3"><font face="Verdana">
<input type="text" name="email" size="80" value="<?PHP echo $email; ?>"></font></td>
</tr>
<tr>
<td width="178" height="28"><font face="Verdana" size="2">Website Address<br>
</font><font face="Verdana" size="1">www.domain.com</font></td>
<td width="589" height="28" colspan="3"><font face="Verdana">
<input type="text" name="web_address" size="80" value="<?PHP echo $web; ?>"></font></td>
</tr>
<tr>
<td width="178" height="19"><font face="Verdana" size="2">Address:</font></td>
<td width="589" height="19" colspan="3"><font face="Verdana">
<input type="text" name="address" size="80" value="<?PHP echo $address; ?>"></font></td>
</tr>
<tr>
<td width="178" height="18"><font face="Verdana" size="2">City:</font></td>
<td width="589" height="18" colspan="3"><font face="Verdana">
<input type="text" name="city" size="80" value="<?PHP echo $city; ?>"></font></td>
</tr>
<tr>
<td width="178" height="19"><font face="Verdana" size="2">State:</font></td>
<td width="197" height="19"><font face="Verdana">
<input type="text" name="state" size="12" value="<?PHP echo $state; ?>"></font></td>
<td width="65" height="19">
<p align="right"><font face="Verdana" size="2">Zip:</font></td>
<td width="327" height="19"><font face="Verdana">
<input type="text" name="zip" size="12" value="<?PHP echo $zip; ?>"></font></td>
</tr>
<tr>
<td width="178" height="19"><font face="Verdana" size="2">Business Type</font></td>
<td width="389" height="19" colspan="2"<font face="Verdana" size="2">
<input type="text" name="t1" size="30" value="<?php echo $type;?>"></td>
<?PHP echo "<td width=\"200\" height=\"19\" colspan=\"1\"><select size=\"1\" name=\"business_type\">
".dd_template()."</select></td>
</tr>
<tr>";
?>
<td width="178" height="19"><font face="Verdana" size="2">Comments</font></td>
<td width="589" height="19" colspan="3">
<textarea rows="6" name="details" cols="60"><?PHP echo $details; ?></textarea></td>
</tr>
<tr>
<input type="hidden" name="detailsId" value="<?PHP echo $details_id; ?>">
<td width="767" height="19" colspan="4">
<p align="center">
<button name="B3" type="submit">Submit</button>
</p>
</form>
</td>
</tr>
</table>
</center>
</div>