Php image upload to database issue

This is a discussion on "Php image upload to database issue" within the PHP Forum section. This forum, and the thread "Php image upload to database issue are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > PHP Forum

Notices




Reply
 
LinkBack Thread Tools
  #1  
Old Nov 19th, 2007, 16:32
Reputable Member
Join Date: Oct 2007
Location: Liverpool UK
Age: 29
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Php image upload to database issue

Hello i am having trouble getting images input from my form to upload into a "images2" folder located in my sites directory, aswell as making the name of the image go into the mysql database! I have managed this before using the code below and it works fine:

PHP: Select all

<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form enctype="multipart/form-data" action="add.php" method="POST"> 
Name: <input type="text" name="name"><br> 
E-mail: <input type="text" name = "email"><br> 
Phone: <input type="text" name = "phone"><br> 
Photo: <input type="file" name="photo"><br> 
<input type="submit" value="Add"> 
</form>
</body>
<?php 
//This is the directory where images will be saved 
$target "images/"
$target $target basename$_FILES['photo']['name']); 
//This gets all the other information from the form 
$name=$_POST['name']; 
$email=$_POST['email']; 
$phone=$_POST['phone']; 
$pic=($_FILES['photo']['name']); 
// Connects to your Database 
mysql_connect("localhost""root""longstand") or die(mysql_error()) ; 
mysql_select_db("dblearn") or die(mysql_error()) ; 
//Writes the information to the database 
mysql_query("INSERT INTO `employees` VALUES ('$name', '$email', '$phone', '$name')") ; 
//Writes the photo to the server 
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 

//Tells you if its all ok 
echo "The file "basename$_FILES['uploadedfile']['name']). "has been uploaded, and your information has been added to the directory"

else { 
//Gives and error if its not 
echo "Sorry Andy There Was A Problem Uploading The File."

?> 
</html>
Like i said the code above works fine, the image goes into the images folder & the name of the image goes into the database.

So what exacly am i having problems with i hear you ask?? This time instead of using the code above to input the data from my form into my sql database i have used php array code, to input the form data into the database, now all is going fine all the data goes into the database, but what code do i need to add to the array code so the images go into the images2 folder and the name of the image goes into the database???

The code above was just a working example so you get my drift, below is my new code, and i no its alot of code but it all works, jus a simple small question of mine is:

How & what code should i add to the php code below so that the images that are selected using the file borowsers located in the form its-self get sent to the images2 folder in my sites directory & the name of the image goes into the database with all the outher data??

Its alot of code, but the only thing to look at is the Php code and the filebrowsers part of the form:

PHP: Select all

<?php require_once('Connections/dbsignup.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function 
GetSQLValueString($theValue$theType$theDefinedValue ""$theNotDefinedValue ""
{
  
$theValue get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  
$theValue function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  switch (
$theType) {
    case 
"text":
      
$theValue = ($theValue != "") ? "'" $theValue "'" "NULL";
      break;    
    case 
"long":
    case 
"int":
      
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case 
"double":
      
$theValue = ($theValue != "") ? "'" doubleval($theValue) . "'" "NULL";
      break;
    case 
"date":
      
$theValue = ($theValue != "") ? "'" $theValue "'" "NULL";
      break;
    case 
"defined":
      
$theValue = ($theValue != "") ? $theDefinedValue $theNotDefinedValue;
      break;
  }
  return 
$theValue;
}
}
$editFormAction $_SERVER['PHP_SELF'];
if (isset(
$_SERVER['QUERY_STRING'])) {
  
$editFormAction .= "?" htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset(
$_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  
$insertSQL sprintf("INSERT INTO customer (first_name, last_name, address, city, area, email, phone, user_name, password, work_location, agency_name, agency_number, skills, about_me, myspace_address, hotmail_yahoo_address, gender, age, height_one, height_two, build, eye_colour, hair_colour, desired_work) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       
GetSQLValueString($_POST['first_name'], "text"),
                       
GetSQLValueString($_POST['last_name'], "text"),
                       
GetSQLValueString($_POST['address'], "text"),
                       
GetSQLValueString($_POST['city'], "text"),
                       
GetSQLValueString($_POST['area'], "text"),
                       
GetSQLValueString($_POST['email'], "text"),
                       
GetSQLValueString($_POST['phone'], "text"),
                       
GetSQLValueString($_POST['user_name'], "text"),
                       
GetSQLValueString($_POST['password'], "text"),
                       
GetSQLValueString($_POST['work_location'], "text"),
                       
GetSQLValueString($_POST['agency_name'], "text"),
                       
GetSQLValueString($_POST['agency_number'], "text"),
                       
GetSQLValueString($_POST['skills'], "text"),
                       
GetSQLValueString($_POST['about_me'], "text"),
                       
GetSQLValueString($_POST['myspace_address'], "text"),
                       
GetSQLValueString($_POST['hotmail_yahoo_address'], "text"),
                       
GetSQLValueString($_POST['gender'], "text"),
                       
GetSQLValueString($_POST['age'], "text"),
                       
GetSQLValueString($_POST['height_one'], "text"),
                       
GetSQLValueString($_POST['height_two'], "text"),
                       
GetSQLValueString($_POST['build'], "text"),
                       
GetSQLValueString($_POST['eye_colour'], "text"),
                       
GetSQLValueString($_POST['hair_colour'], "text"),
                       
GetSQLValueString($_POST['desired_work'], "text"));
  
mysql_select_db($database_dbsignup$dbsignup);
  
$Result1 mysql_query($insertSQL$dbsignup) or die(mysql_error());
}
$con mysql_connect("localhost","root","longstand1");
if (!
$con)
  {
  die(
'Could not connect: ' mysql_error());
  }

mysql_select_db("dbsignup"$con);
 

if (!empty(
$_POST['button'])) 

 
     
    
$needStrip get_magic_quotes_gpc(); 
 
     
    
$fields = array(); 
     
   
 
 
$fields['select'] = array('type'        => 's',       
                               
'required'    => true,    
                               
'column'        => 'first_name'    
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'last_name' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'address' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'city' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'area' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'email' 
                               
); 
    
$fields['select2'] = array('type'        => 'n'
                               
'required'    => true
                               
'column'        => 'phone' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'user_name' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'password' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'work_location' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'agency_name' 
                               
); 
    
$fields['select2'] = array('type'        => 'n'
                               
'required'    => true
                               
'column'        => 'agency_number' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'skills' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'about_me' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'myspace_address' 
                               
); 
    
$fields['select2'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'hotmail_yahoo_address' 
                               
); 
    
$fields['select3'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'gender' 
                               
);
    
$fields['select3'] = array('type'        => 'n'
                               
'required'    => true
                               
'column'        => 'age' 
                               
);
    
$fields['select3'] = array('type'        => 'n'
                               
'required'    => true
                               
'column'        => 'height_one' 
                               
);
    
$fields['select3'] = array('type'        => 'n'
                               
'required'    => true
                               
'column'        => 'height_two' 
                               
);
   
$fields['select3'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'build' 
                               
); 
   
$fields['select3'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'eye_colour' 
                               
);
   
$fields['select3'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'hair_colour' 
                               
);
   
$fields['select3'] = array('type'        => 's'
                               
'required'    => true
                               
'column'        => 'desired_work' 
                               
);
   
   

    
$errors = array(); 
 
 
$cols ''
    
$vals ''
 
 foreach (
$fields as $field => $dets
    { 
     
        
$field trim($field); 
         
       
        if (
$dets['required'] && empty($_POST[$field])) { 
            
$errors[] = $field ' is a required field!'
            continue; 
        } 
         
        
        if (
$dets['type'] == 'n' && !is_numeric($_POST[$field])) { 
            
$errors[] = $field ' should be a number!'
            continue; 
        } 
         
        
        if (empty(
$_POST['field']) || count($errors)) 
            continue; 
             
      
         
     
        
$_POST[$field] = $needStrip stripslashes($_POST[$field]) : $_POST[$field]; 
         
     
        
$_POST[$field] = mysql_real_escape_string($_POST[$field]); 
         
      
        if (!empty(
$cols)) { 
        
$cols .= ', '
        
$vals .= ', '
        } 
         
        
$cols .= $dets['column']; 
        
$vals .= $dets['type'] == 'n' && is_numeric($_POST[$field]) ? $_POST[$field] : "'{$_POST[$field]}'";  
     
    } 
     
   
     
    if (!
count($errors) && !empty($cols) && !empty($vals)) {        
     
     
        
$query "INSERT INTO details($cols) VALUES($vals)"
         
   
         
mysql_select_db($database_dbsignup$dbsignup); 
        
$result mysql_query($query) or die(mysql_error()); 
         
         
        
$message "Yay, you have been inserted as " mysql_insert_id(); // The insert ID 
         
    
}  else {  
     
      
        
$message '<strong>The following errors are screwing things up!</strong> 
                    <ol>'

         
        foreach (
$errors as $err)  
            
$message .= '<li>' $err '</li>'
             
        
$message .= '</ol>'
    } 


?><!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Signup Today</title>
<style type="text/css">
<!--

@import url("Drop down menu/Untitled-1.css");
 
@import url("Drop down menu/Untitled-4.css");

@import url("Drop down menu/Untitled-4.css");
body {
 background-image: url(images/Only4Stars%20background.png);
}td img {display: block;}
.style1 {
 font-family: Tahoma;
 font-style: italic;
 color: #FFFFFF;
}
.style2 {
 font-family: Tahoma;
 color: #FFFFFF;
}
.style3 {font-family: Tahoma; color: #FFFFFF; font-size: 12px; }td img {display: block;}
.style4 {font-family: Tahoma; color: #FFFFFF; font-weight: bold; }
td img {display: block;}td img {display: block;}
.style12 {
 font-family: Tahoma;
 font-size: 14px;
}
.style13 {
 font-family: Geneva, Arial, Helvetica, sans-serif;
 font-size: 14px;
 color: #000000;
}td img {display: block;}
.style14 { color: #000000;
 font-size: 12px;
 font-family: Tahoma;
}
 
 
 
-->
</style>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script language="JavaScript1.2" type="text/javascript" src="Drop down menu/mm_css_menu.js"></script>
<script type="text/javascript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body onload="MM_preloadImages('Drop down menu/Untitled-1_r1_c1_f2.gif','Drop down menu/Untitled-1_r2_c1_f2.gif','Drop down menu/Untitled-1_r3_c1_f2.gif','Drop down menu/Untitled-1_r4_c1_f2.gif','Drop down menu/Untitled-1_r4_c3_f2.gif','Drop down menu/Untitled-1_r5_c2_f2.gif','Drop down menu/Untitled-1_r6_c1_f2.gif','Drop down menu/Untitled-1_r7_c1_f2.gif','Drop down menu/Untitled-1_r9_c1_f2.gif','Drop down menu/Untitled-1_r10_c1_f2.gif','Drop down menu/Untitled-1_r11_c1_f2.gif','Drop down menu/Untitled-1_r13_c1_f2.gif')">
<table width="944" height="2005" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="228"><table width="943" height="228" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="419" bgcolor="#EBE9ED"><div align="center">
          <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','421','height','242','src','animation/Main Logo/Menu','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','animation/Main Logo/Menu' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="421" height="242">
            <param name="movie" value="animation/Main Logo/Menu.swf" />
            <param name="quality" value="high" />
            <embed src="animation/Main Logo/Menu.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="421" height="242"></embed>
          </object>
        </noscript></div></td>
        <td width="266" bgcolor="#99FF00"><div align="center">
          <table width="250" height="228" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','251','height','237','src','animation/slide show 1/Movie1','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','animation/slide show 1/Movie1' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="251" height="237">
                <param name="movie" value="animation/slide show 1/Movie1.swf" />
                <param name="quality" value="high" />
                <embed src="animation/slide show 1/Movie1.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="251" height="237"></embed>
              </object></noscript></td>
            </tr>
          </table>
        </div></td>
        <td width="248" bgcolor="#99FF00"><div align="center">
          <table width="250" height="228" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','251','height','237','src','animation/slideshow 2/Movie1','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','animation/slideshow 2/Movie1' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="251" height="237">
                <param name="movie" value="animation/slideshow 2/Movie1.swf" />
                <param name="quality" value="high" />
                <embed src="animation/slideshow 2/Movie1.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="251" height="237"></embed>
              </object></noscript></td>
            </tr>
          </table>
        </div></td>
        <td width="10" bgcolor="#99FF00">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height="94"><img name="" src="images/Photo Reel.png" width="945" height="125" alt="" /></td>
  </tr>
  <tr>
    <td height="1651" valign="top"><table width="944" height="1664" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="189" height="1651" valign="top" bgcolor="#990000"><div id="FWTableContainer1603953034">
          <table border="0" cellpadding="0" cellspacing="0" width="190">
            <!-- fwtable fwsrc="Untitled" fwpage="Page 1" fwbase="Untitled-1.gif" fwstyle="Dreamweaver" fwdocid = "1603953034" fwnested="0" -->
            <tr>
              <td><img src="Drop down menu/spacer.gif" width="36" height="1" border="0" alt="" /></td>
              <td><img src="Drop down menu/spacer.gif" width="81" height="1" border="0" alt="" /></td>
              <td><img src="Drop down menu/spacer.gif" width="73" height="1" border="0" alt="" /></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="1" border="0" alt="" /></td>
            </tr>
            <tr>
              <td colspan="3"><a href="index.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r1_c1','','Drop down menu/Untitled-1_r1_c1_f2.gif',1);"><img name="Untitled1_r1_c1" src="Drop down menu/Untitled-1_r1_c1.gif" width="190" height="34" border="0" id="Untitled1_r1_c1" alt="" /></a></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="34" border="0" alt="" /></td>
            </tr>
            <tr>
              <td colspan="3"><a href="about.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r2_c1','','Drop down menu/Untitled-1_r2_c1_f2.gif',1);"><img name="Untitled1_r2_c1" src="Drop down menu/Untitled-1_r2_c1.gif" width="190" height="34" border="0" id="Untitled1_r2_c1" alt="" /></a></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="34" border="0" alt="" /></td>
            </tr>
            <tr>
              <td colspan="3"><a href="javascript:;" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r3_c1','','Drop down menu/Untitled-1_r3_c1_f2.gif','Untitled1_r4_c1','','Drop down menu/Untitled-1_r4_c1_f2.gif','Untitled1_r4_c3','','Drop down menu/Untitled-1_r4_c3_f2.gif','Untitled1_r5_c2','','Drop down menu/Untitled-1_r5_c2_f2.gif',1);"><img name="Untitled1_r3_c1" src="Drop down menu/Untitled-1_r3_c1.gif" width="190" height="12" border="0" id="Untitled1_r3_c1" alt="" /></a></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="12" border="0" alt="" /></td>
            </tr>
            <tr>
              <td rowspan="2"><a href="javascript:;" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r3_c1','','Drop down menu/Untitled-1_r3_c1_f2.gif','Untitled1_r4_c1','','Drop down menu/Untitled-1_r4_c1_f2.gif','Untitled1_r4_c3','','Drop down menu/Untitled-1_r4_c3_f2.gif','Untitled1_r5_c2','','Drop down menu/Untitled-1_r5_c2_f2.gif',1);"><img name="Untitled1_r4_c1" src="Drop down menu/Untitled-1_r4_c1.gif" width="36" height="22" border="0" id="Untitled1_r4_c1" alt="" /></a></td>
              <td><a href="javascript:;" onmouseout="MM_menuStartTimeout(1000);" onmouseover="MM_menuShowMenu('MMMenuContainer1101183735_0', 'MMMenu1101183735_0',81,0,'Untitled1_r4_c2');"><img name="Untitled1_r4_c2" src="Drop down menu/Untitled-1_r4_c2.gif" width="81" height="13" border="0" id="Untitled1_r4_c2" alt="" /></a></td>
              <td rowspan="2"><a href="javascript:;" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r3_c1','','Drop down menu/Untitled-1_r3_c1_f2.gif','Untitled1_r4_c1','','Drop down menu/Untitled-1_r4_c1_f2.gif','Untitled1_r4_c3','','Drop down menu/Untitled-1_r4_c3_f2.gif','Untitled1_r5_c2','','Drop down menu/Untitled-1_r5_c2_f2.gif',1);"><img name="Untitled1_r4_c3" src="Drop down menu/Untitled-1_r4_c3.gif" width="73" height="22" border="0" id="Untitled1_r4_c3" alt="" /></a></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="13" border="0" alt="" /></td>
            </tr>
            <tr>
              <td><a href="javascript:;" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r3_c1','','Drop down menu/Untitled-1_r3_c1_f2.gif','Untitled1_r4_c1','','Drop down menu/Untitled-1_r4_c1_f2.gif','Untitled1_r4_c3','','Drop down menu/Untitled-1_r4_c3_f2.gif','Untitled1_r5_c2','','Drop down menu/Untitled-1_r5_c2_f2.gif',1);"><img name="Untitled1_r5_c2" src="Drop down menu/Untitled-1_r5_c2.gif" width="81" height="9" border="0" id="Untitled1_r5_c2" alt="" /></a></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="9" border="0" alt="" /></td>
            </tr>
            <tr>
              <td colspan="3"><a href="your_account.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r6_c1','','Drop down menu/Untitled-1_r6_c1_f2.gif',1);"><img name="Untitled1_r6_c1" src="Drop down menu/Untitled-1_r6_c1.gif" width="190" height="33" border="0" id="Untitled1_r6_c1" alt="" /></a></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="33" border="0" alt="" /></td>
            </tr>
            <tr>
              <td rowspan="2" colspan="3"><a href="signup.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r7_c1','','Drop down menu/Untitled-1_r7_c1_f2.gif',1);"><img name="Untitled1_r7_c1" src="Drop down menu/Untitled-1_r7_c1.gif" width="190" height="35" border="0" id="Untitled1_r7_c1" alt="" /></a></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="1" border="0" alt="" /></td>
            </tr>
            <tr>
              <td><img src="Drop down menu/spacer.gif" width="1" height="34" border="0" alt="" /></td>
            </tr>
            <tr>
              <td colspan="3"><a href="search_memebers.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r9_c1','','Drop down menu/Untitled-1_r9_c1_f2.gif',1);"><img name="Untitled1_r9_c1" src="Drop down menu/Untitled-1_r9_c1.gif" width="190" height="34" border="0" id="Untitled1_r9_c1" alt="" /></a></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="34" border="0" alt="" /></td>
            </tr>
            <tr>
              <td colspan="3"><a href="faq.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r10_c1','','Drop down menu/Untitled-1_r10_c1_f2.gif',1);"><img name="Untitled1_r10_c1" src="Drop down menu/Untitled-1_r10_c1.gif" width="190" height="33" border="0" id="Untitled1_r10_c1" alt="" /></a></td>
              <td><img src="Drop down menu/spacer.gif" width="1" height="33" border="0" alt="" /></td>
            </tr>
            <tr>
              <td rowspan="2" colspan="3"><a href="contact_us.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r11_c1','','Drop down menu/Untitled-1_r11_c1_f2.