Parse error: syntax error, unexpected T_STRING in /home/kokodi/public_html/online_a

Question

bluetoot 0 Newbie Poster

13 Years Ago

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!";						
 }						
 }						?>

mysql

5 Contributors
16 Replies
395 Views
6 Months Discussion Span
Latest Post 12 Years Ago Latest Post by satyajit das

All 16 Replies

pritaeas 2,194 ¯\_(ツ)_/¯

13 Years Ago

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

Edited 13 Years Ago by pritaeas because: n/a

pritaeas 2,194 ¯\_(ツ)_/¯

13 Years Ago

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 13 Years Ago by pritaeas because: n/a

pritaeas 2,194 ¯\_(ツ)_/¯

13 Years Ago

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 13 Years Ago by pritaeas because: n/a

pritaeas 2,194 ¯\_(ツ)_/¯

13 Years Ago

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

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

bluetoot 0 Newbie Poster · Answer 1 · 2011-01-03T15:07:05+00:00

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?

bluetoot 0 Newbie Poster · Answer 2 · 2011-01-04T05:18:42+00:00

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?

bluetoot 0 Newbie Poster · Answer 3 · 2011-01-05T10:29:03+00:00

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

bluetoot 0 Newbie Poster · Answer 4 · 2011-01-07T04:59:29+00:00

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

smantscheff 265 Veteran Poster · Answer 5 · 2011-01-07T06:00:44+00:00

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).

chistybsl 0 Newbie Poster · Answer 6 · 2011-08-03T11:57:13+00:00

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

satyajit das 0 Newbie Poster · Answer 7 · 2011-08-03T20:30:55+00:00

Re: Parse error: syntax error, unexpected T_STRING in /home/kokodi/public_html/online_a

satyajit das 0 Newbie Poster · Answer 8 · 2011-08-03T20:33:03+00:00

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

satyajit das 0 Newbie Poster · Answer 9 · 2011-08-03T20:35:04+00:00

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

satyajit das 0 Newbie Poster · Answer 10 · 2011-08-03T20:36:35+00:00

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

satyajit das 0 Newbie Poster · Answer 11 · 2011-08-03T20:40:23+00:00

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

satyajit das 0 Newbie Poster · Answer 12 · 2011-08-03T20:41:24+00:00

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

Parse error: syntax error, unexpected T_STRING in /home/kokodi/public_html/online_a

Recommended Answers Collapse Answers

All 16 Replies

Recommended Answers