Page 2 of 2

Posted: Fri Nov 11, 2005 12:50 pm
by utahfriend
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:

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>