0

Hello!
please i need help with this,after sumiting my form i get this error message on line 111
any help i will appreciate, thx

<?php session_start();
include("../Connections/recruit.php");
 
echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; 					  
//check certification					  
$certification = $HTTP_POST_VARS['certification'];					  
if($certification != "accept")					 
{		 echo(" Your application has been terminated as a result of uncertified information!");?> </font></div>
                        

<? end;					  
} 
else{					  
//post time					  
$date_posted = date ("l, jS of , Y h:i:s A");					  

// pass session vars into simple vars					  
//personal data					  
 $title = $HTTP_SESSION_VARS['stitle'];
 $firstname = $HTTP_SESSION_VARS['sfirstname'];					 
 $middlename = $HTTP_SESSION_VARS['smiddlename'];
 $surname = $HTTP_SESSION_VARS['ssurname'];
 $priornames = $HTTP_SESSION_VARS['spriornames'];				  
 $reasons = $HTTP_SESSION_VARS['sreasons'];					  
 $birthplace = $HTTP_SESSION_VARS['sbirthplace'];					  
 $dob_month = $HTTP_SESSION_VARS['sdob_month'];					  
 $dob_day = $HTTP_SESSION_VARS['sdob_day'];					  
 $dob_year = $HTTP_SESSION_VARS['sdob_year'];
 $sex = $HTTP_SESSION_VARS['ssex'];
 $nigeria_address = $HTTP_SESSION_VARS['snigeria_address'];					  
 $state_of_origin = $HTTP_SESSION_VARS['sstate_of_origin'];					  					  
 $lga = $HTTP_SESSION_VARS['slga'];					  
 $current_address = $HTTP_SESSION_VARS['scurrent_address'];					  					  
 $phone = $HTTP_SESSION_VARS['sphone'];
 $fax = $HTTP_SESSION_VARS['sfax'];
 $email = $HTTP_SESSION_VARS['email'];
 $eyes = $HTTP_SESSION_VARS['eyes'];
 $hair = $HTTP_SESSION_VARS['hair'];
 $special_features = $HTTP_SESSION_VARS['sspecial_features'];
 $height = $HTTP_SESSION_VARS['height'];
 $weight = $HTTP_SESSION_VARS['weight'];
 $marital_status = $HTTP_SESSION_VARS['smarital_status'];
 $kinname = $HTTP_SESSION_VARS['skinname'];
 $kin_address = $HTTP_SESSION_VARS['skin_address'];	
 $kin_relationship = $HTTP_SESSION_VARS['skin_relationship'];							  					  
  
  //resume					 
   $resume = $HTTP_SESSION_VARS['sresume'];					   				 
?>


<!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><title>
 :: Recruitment (Status)</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><style TYPE="text/css"><!--  A:link {text-decoration: none; color:#000055}  A:visited {text-decoration: none; color:#000055}  A:active {text-decoration: none; color:#000022}   A:hover {text-decoration: ; color:#00CC00 }--></style><div align="center">   <table width="780" border="0" cellpadding="0" cellspacing="2" bgcolor="#FFFFFF">    <tr>       <td><div align="center">           <table border="0" cellpadding="0" cellspacing="0" width="760">            <!-- fwtable fwsrc="3banner.png" fwbase="3banner.jpg" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" -->            <tr>               <td><img src="bannerhome/spacer.gif" width="67" height="1" border="0" alt="" /></td>              <td><img src="bannerhome/spacer.gif" width="491" height="1" border="0" alt="" /></td>              <td><img src="bannerhome/spacer.gif" width="202" height="1" border="0" alt="" /></td>              <td><img src="bannerhome/spacer.gif" width="1" height="1" border="0" alt="" /></td>            </tr>            <tr>               <td colspan="3">
	<img name="3banner_r1_c1" src="../images/banner_r1_c1.jpg" width="760" height="6" border="0" id="3banner_r1_c1" alt="" /></td>              <td><img src="bannerhome/spacer.gif" width="1" height="6" border="0" alt="" /></td>            </tr>            <tr>               <td rowspan="4">
		<img name="3banner_r2_c1" src="../images/logo.jpg" width="67" height="129" border="0" id="3banner_r2_c1" alt="" /></td>              <td rowspan="3"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="491" height="122">                  
			<param name="movie" value="../flash/banner_recruit.swf" />                  
			<param name="quality" value="High" />                  
			<embed src="../flash/banner_recruit.swf" quality="High" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="491" height="122"></embed></object></td>              <td>
		<img name="3banner_r2_c3" src="../images/3banner_r2_c3.jpg" width="202" height="23" border="0" id="3banner_r2_c3" alt="" /></td>              <td><img src="bannerhome/spacer.gif" width="1" height="23" border="0" alt="" /></td>            </tr>            <tr>               <td>
		<img name="3banner_r3_c3" src="../images/recruit.jpg" width="202" height="61" border="0" id="3banner_r3_c3" alt="" /></td>              <td><img src="bannerhome/spacer.gif" width="1" height="61" border="0" alt="" /></td>            </tr>            <tr>               <td rowspan="2">
		<img name="3banner_r4_c3" src="../images/3banner_r4_c3.jpg" width="202" height="45" border="0" id="3banner_r4_c3" alt="" /></td>              <td><img src="bannerhome/spacer.gif" width="1" height="38" border="0" alt="" /></td>            </tr>            <tr>               <td>
		<img name="3banner_r5_c2" src="../images/3banner_r5_c2.jpg" width="491" height="7" border="0" id="3banner_r5_c2" alt="" /></td>              <td><img src="bannerhome/spacer.gif" width="1" height="7" border="0" alt="" /></td>            </tr>          </table>        </div></td>    </tr>    <tr>       <td height="27"> <div align="center">           <table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#CCCCCC">            <tr>               <td height="25"> <div align="center">                   <table width="100%" border="0" cellpadding="2" cellspacing="2">                    <tr valign="top">                       <td width="81%" height="26" bgcolor="#CCCCCC"> <div align="center">                         </div></td>                      <td width="19%" rowspan="2" bgcolor="#000055"><table width="100%" border="0" cellspacing="0" cellpadding="0">                          <tr>                             <td>
		<img border="0" src="../images/fadeflare.jpg" width="185" height="252"></td>                          </tr>                          </table></td>                    </tr>                    <tr>                       <td valign="top" bgcolor="#FFFFFF">                         

  
  <div align="center"><font face="Arial" color="#FF0000" size="2"> 
  			 <? 					  				  					  						
   
/* recipients */						
					
$to  = "xxjack@yahoo.com";

/* subject */						
$subject = "Application form submission from"." ".$firstname." ".$surname." (".$email.")";												

/* message */						
$message = "Your application form has been completed with the following details"."\n\n".
"Remote form submission time: "."$posttime"."\n".						
"[Personal Data]"."\n".						
"Title : $title"."\n".
"First Name : $firstname"."\n".						
"Middle Name : $middlename"."\n".
"Surname : $surname"."\n".
"Prior Names Used : $priornames"."\n".
"Reasons for Name Change : $reasons"."\n".
"Place of Birth : $birhplace"."\n".
"Name : $kinname"."\n".
"Address : $kin_address"."\n".
"Relatonship : $kin_relationship"."\n".
"Nigeria Address : $nigeria_address"."\n".												
"State of Origin : $state_of_origin"."\n".												
"Current Address : $current_address"."\n".
"Phone : $phone"."\n".
"Fax : $fax"."\n".
"Email : $email"."\n".
"Occupation : $occupation"."\n".
"Color of Eyes : $eyes"."\n".
"Color of Hair : $hair"."\n".
"Special Features : $special_features"."\n".
"Height : $height"."\n".
"Weight : $weight"."\n".	
"Date of Birth : $dob_month $dob_day, $dob_year					
Gender : $sex						
Marital Status : $marital_status						

	
//print_r($_SESSION);

// SELECT DATABASE
mysql_select_db($database_recruit) or die(mysql_error());
$result = mysql_query("insert into users_cv (title, firstname, middlename, surname, priornames, reasons, birthplace, dob_day, dob_day, dob_year, sex, nigeria_address, state_of_origin, lga, current_address, phone, fax, occupation, eyes, hair, height, weight, marital_status, kinname, kin_address, kin_relationship, date_posted) VALUES ('$title', '$firstname', '$middlename', '$surname', '$priornames', '$reasons', '$birthplace', '$dob_month', '$dob_day', '$dob_year', '$sex', '$nigeria_address', '$state_of_origin', '$lga', '$current_address', '$phone', '$fax', '$occupation', '$eyes', '$hair', '$height', '$weight', '$marital_status', '$kinname', '$kin_address', '$kin_relationship', '$date_posted')
//
                       
						
 if(mail($to, $subject, $message, $headers))						
 {						
 echo "Your application has been submitted!";						
 }						
 }						?>
5
Contributors
16
Replies
17
Views
6 Years
Discussion Span
Last Post by satyajit das
0

Lines 104 and 111 are not closed correctly. Missing double quotes and semi-colon.

Edited by pritaeas: n/a

0

Lines 104 and 111 are not closed correctly. Missing double quotes and semi-colon.

please if you have the time, can you put in the correct line, as i am new into php.
thanks for your time

if line 104 isnt closed properly, will that be the same for line 103?
please what are the correct statements for line 103,104 and 111?

Edited by bluetoot: n/a

0

102-104:

"Date of Birth : $dob_month $dob_day, $dob_year"."\n".
"Gender : $sex"."\n".
"Marital Status : $marital_status"."\n";

111:

$result = mysql_query("INSERT INTO users_cv (title, firstname, middlename, surname, priornames, reasons, birthplace, dob_day, dob_day, dob_year, sex, nigeria_address, state_of_origin, lga, current_address, phone, fax, occupation, eyes, hair, height, weight, marital_status, kinname, kin_address, kin_relationship, date_posted) VALUES ('$title', '$firstname', '$middlename', '$surname', '$priornames', '$reasons', '$birthplace', '$dob_month', '$dob_day', '$dob_year', '$sex', '$nigeria_address', '$state_of_origin', '$lga', '$current_address', '$phone', '$fax', '$occupation', '$eyes', '$hair', '$height', '$weight', '$marital_status', '$kinname', '$kin_address', '$kin_relationship', '$date_posted')");

Edited by pritaeas: n/a

0

Thank you pritaes, I do appreciate. the error messages has stopped, i get the submited form in my email box, but when i go to the database to view it there are no data

this is my sql tables

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- 
--
-- Host: localhost
-- Generation Time: Jan 14, 2008 at 12:54 AM
-- Server version: 4.1.22
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `nas_recruit`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL auto_increment,
  `firstname` varchar(20) collate latin1_general_ci default NULL,
  `lastname` varchar(20) collate latin1_general_ci default NULL,
  `username` varchar(20) collate latin1_general_ci default NULL,
  `password` varchar(20) collate latin1_general_ci default NULL,
  `date` date default '0000-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` VALUES(1, 'Niyi', 'Lawani', 'niyilawani', '123456', '0000-00-00');
INSERT INTO `admin` VALUES(2, NULL, NULL, 'admin', 'admin', '1899-12-29');

-- --------------------------------------------------------

--
-- Table structure for table `users_cv`
--

CREATE TABLE `users_cv` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) collate latin1_general_ci default NULL,
  `firstname` varchar(50) collate latin1_general_ci default NULL,
  `middlename` varchar(50) collate latin1_general_ci default NULL,
  `lastname` varchar(50) collate latin1_general_ci default NULL,
  `priornames` varchar(50) collate latin1_general_ci default NULL,
  `reasons` varchar(255) collate latin1_general_ci default NULL,
  `birthplace` varchar(50) collate latin1_general_ci default NULL,
  `dob_month` varchar(20) collate latin1_general_ci default NULL,
  `dob_day` varchar(20) collate latin1_general_ci default NULL,
  `dob_year` varchar(20) collate latin1_general_ci default NULL,
  `sex` varchar(10) collate latin1_general_ci default NULL,
  `nigeria_address` varchar(255) collate latin1_general_ci default NULL,
  `state_of_origin` varchar(20) collate latin1_general_ci default NULL,
  `lga` varchar(255) collate latin1_general_ci default NULL,
  `current_address` varchar(255) collate latin1_general_ci default NULL,
  `phone` varchar(50) collate latin1_general_ci default NULL,
  `fax` varchar(50) collate latin1_general_ci default NULL,
  `email` varchar(50) collate latin1_general_ci default NULL,
  `occupation` varchar(50) collate latin1_general_ci default NULL,
  `eyes` varchar(50) collate latin1_general_ci default NULL,
  `hair` varchar(50) collate latin1_general_ci default NULL,
  `height` varchar(20) collate latin1_general_ci default NULL,
  `weight` varchar(20) collate latin1_general_ci default NULL,
  `marital_status` varchar(20) collate latin1_general_ci default NULL,
  `kinname` varchar(50) collate latin1_general_ci default NULL,
  `kin_address` varchar(255) collate latin1_general_ci default NULL,
  `kin_relationship` varchar(50) collate latin1_general_ci default NULL,
  `resume` longtext collate latin1_general_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users_cv`
--

please could you figure out this?

Edited by bluetoot: n/a

0

First try this:

$result = mysql_query("INSERT INTO users_cv (title, firstname, middlename, surname, priornames, reasons, birthplace, dob_day, dob_day, dob_year, sex, nigeria_address, state_of_origin, lga, current_address, phone, fax, occupation, eyes, hair, height, weight, marital_status, kinname, kin_address, kin_relationship, date_posted) VALUES ('$title', '$firstname', '$middlename', '$surname', '$priornames', '$reasons', '$birthplace', '$dob_month', '$dob_day', '$dob_year', '$sex', '$nigeria_address', '$state_of_origin', '$lga', '$current_address', '$phone', '$fax', '$occupation', '$eyes', '$hair', '$height', '$weight', '$marital_status', '$kinname', '$kin_address', '$kin_relationship', '$date_posted')") or die(mysql_error());

And tell me whether your get an error (post the message if it does). I think you will find that the date_posted column is missing (and surname), then there is the fact that dob_day is specified twice. In other words, check your query, it should match your table.

Edited by pritaeas: n/a

0

First try this:

$result = mysql_query("INSERT INTO users_cv (title, firstname, middlename, surname, priornames, reasons, birthplace, dob_day, dob_day, dob_year, sex, nigeria_address, state_of_origin, lga, current_address, phone, fax, occupation, eyes, hair, height, weight, marital_status, kinname, kin_address, kin_relationship, date_posted) VALUES ('$title', '$firstname', '$middlename', '$surname', '$priornames', '$reasons', '$birthplace', '$dob_month', '$dob_day', '$dob_year', '$sex', '$nigeria_address', '$state_of_origin', '$lga', '$current_address', '$phone', '$fax', '$occupation', '$eyes', '$hair', '$height', '$weight', '$marital_status', '$kinname', '$kin_address', '$kin_relationship', '$date_posted')") or die(mysql_error());

And tell me whether your get an error (post the message if it does). I think you will find that the date_posted column is missing (and surname), then there is the fact that dob_day is specified twice. In other words, check your query, it should match your table.

Wow!

you are good!it worked thank you so much and for your patience i do appreciate.

however i have a question to ask.

please i wanted to add a file upload section to the form, and also able to view files uploaded by users that filled the form,

can you give me the code to and show me how to add it to my existing form and also to my tables?

:)a big thank you priteas

0

Search this forum first. It contains a lot of examples handling file uploads.

Hello Pritaes
A big thank you

I did as you adviced,I have created tables for the upload componet,tables for data,and the form for the upload works.

Now the challenge i have is i have a view page in the admin section, where a person's data is viewed, but i dont know how to incorporate the code to add the file to the users profile

this are my tables

CREATE TABLE `users_cv` (
  `id` int(11) NOT NULL auto_increment,
  `date_posted` varchar(30) collate latin1_general_ci default NULL,
  `title` varchar(50) collate latin1_general_ci default NULL,
  `firstname` varchar(50) collate latin1_general_ci default NULL,
  `middlename` varchar(50) collate latin1_general_ci default NULL,
  `surname` varchar(50) collate latin1_general_ci default NULL,
  `priornames` varchar(50) collate latin1_general_ci default NULL,
  `reasons` varchar(255) collate latin1_general_ci default NULL,
  `birthplace` varchar(50) collate latin1_general_ci default NULL,
  `dob_month` varchar(20) collate latin1_general_ci default NULL,
  `dob_day` varchar(20) collate latin1_general_ci default NULL,
  `dob_year` varchar(20) collate latin1_general_ci default NULL,
  `sex` varchar(10) collate latin1_general_ci default NULL,
  `nigeria_address` varchar(255) collate latin1_general_ci default NULL,
  `state_of_origin` varchar(20) collate latin1_general_ci default NULL,
  `lga` varchar(255) collate latin1_general_ci default NULL,
  `current_address` varchar(255) collate latin1_general_ci default NULL,
  `phone` varchar(50) collate latin1_general_ci default NULL,
  `fax` varchar(50) collate latin1_general_ci default NULL,
  `email` varchar(50) collate latin1_general_ci default NULL,
  `occupation` varchar(50) collate latin1_general_ci default NULL,
  `eyes` varchar(50) collate latin1_general_ci default NULL,
  `hair` varchar(50) collate latin1_general_ci default NULL,
  `height` varchar(20) collate latin1_general_ci default NULL,
  `weight` varchar(20) collate latin1_general_ci default NULL,
  `marital_status` varchar(20) collate latin1_general_ci default NULL,
  `kinname` varchar(50) collate latin1_general_ci default NULL,
  `kin_address` varchar(255) collate latin1_general_ci default NULL,
  `kin_relationship` varchar(50) collate latin1_general_ci default NULL,
  `resume` longtext collate latin1_general_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

Table for files

CREATE TABLE `files` ( `fid` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'unique id', `name` VARCHAR( 30 ) NOT NULL COMMENT 'file name', `type` VARCHAR( 30 ) NOT NULL COMMENT 'MIME type', `size` INT( 11 ) NOT NULL COMMENT 'file size', `content` MEDIUMBLOB NOT NULL COMMENT 'actual file') ENGINE = MYISAM COMMENT = 'Uploaded files'

Now i have a view.php that reads the tabele(users_cv)
The challenge is how do i get this same page to bring out the file user a posted?

i tried to merge the two tables but couldnt


thanks for you kind response to teach

0

Get yourself a MySQL primer to read and study.
If you have exactly one file per user, the administrative data for this file should go into the user_cv table, too.
Otherwise - that is, if there may be more than one file per user - there has to be a connection between the tables, presumably in form of a foreign key field like users_cv_id in the files table. You have to fill this field in the upload routine.
Then you can query both tables with a JOIN (learn about SELECT FROM ... JOIN).

0

Parse error: syntax error, unexpected '=' in /home/movies/public_html/common/dwnload.php on line 102

0

Parse error: syntax error, unexpected '=' in /home/movies/public_html/common/dwnload.php on line 102

0

Parse error: syntax error, unexpected '=' in /home/movies/public_html/common/dwnload.php on line 102Re: Parse error: syntax error, unexpected T_STRING in /home/kokodi/public_html/online_a

0

my page is not openeng due to the thread-Parse error: syntax error, unexpected '=' in /home/movies/public_html/common/dwnload.php on line 102

0

CREATE TABLE `users_cv` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`date_posted` VARCHAR(30) COLLATE latin1_general_ci DEFAULT NULL,
`title` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`firstname` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`middlename` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`surname` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`priornames` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`reasons` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`birthplace` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`dob_month` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`dob_day` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`dob_year` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`sex` VARCHAR(10) COLLATE latin1_general_ci DEFAULT NULL,
`nigeria_address` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`state_of_origin` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`lga` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`current_address` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`phone` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`fax` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`email` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`occupation` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`eyes` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`hair` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`height` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`weight` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`marital_status` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`kinname` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`kin_address` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`kin_relationship` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`resume` LONGTEXT COLLATE latin1_general_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1

0

CREATE TABLE `users_cv` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`date_posted` VARCHAR(30) COLLATE latin1_general_ci DEFAULT NULL,
`title` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`firstname` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`middlename` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`surname` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`priornames` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`reasons` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`birthplace` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`dob_month` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`dob_day` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`dob_year` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`sex` VARCHAR(10) COLLATE latin1_general_ci DEFAULT NULL,
`nigeria_address` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`state_of_origin` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`lga` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`current_address` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`phone` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`fax` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`email` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`occupation` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`eyes` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`hair` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`height` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`weight` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`marital_status` VARCHAR(20) COLLATE latin1_general_ci DEFAULT NULL,
`kinname` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`kin_address` VARCHAR(255) COLLATE latin1_general_ci DEFAULT NULL,
`kin_relationship` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
`resume` LONGTEXT COLLATE latin1_general_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.