bluetoot 0 Newbie Poster

I am new to php,just did a couple of things to get here, can someone read this script for me and locate where this open/close braces is missing?
thank you

bluetoot 0 Newbie Poster

hello people

I Have this error mssg can anybody help me see what i am not seeing here that is wrong? thanks


Parse error: syntax error, unexpected $end in /home/www/t.php on line 434

this is my php page

<?php
session_start();
/******************************************************************************
*                                                                             *
*                                                                             *
*                                                                             *
******************************************************************************/

/******************************************************************************
*                                                                             *
*                                                                             *  
*                                                                             *
*                                                                             *
*                                                                             *
*                                                                             *
*                                                                             *
******************************************************************************/
include('myconfig.php');
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");
include('response.php');
if(isset($_POST['Submit']))
{
if(($_POST['check']) == $_SESSION['check']) { 
echo '<br>';
}else{ 
echo '<center><font face=" verdana, tahoma" font size="-2">Input Wrong<BR>';
echo '<a href="javascript:history.go(-1)">Go Back</a></font></center>'; 
die;
        }
$subject = $_POST['subject'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];
$address = $_POST['address'];
$fax = $_POST['fax'];
$phone = $_POST['phone'];
$website = $_POST['website'];
$emaile = $_POST['emaile'];
$comments = $_POST['comments'];
$time = date ("h:i A"); 
$date = date ("l, F jS, Y");
$name=array($subject,$firstname,$lastname,$city,$state,$zip,$address,$fax,$phone,$website,$comments);
foreach ($name as $name) 
{
if (ereg("^\.",$name)) {
echo "<center>Invalid Characters:<a href=\"javascript:history.go(-1)\">Go Back</a></center>";  
 Die();
}
if (ereg("\<", $name)) {
echo "<center>Invalid Characters: <font color = \"red\"><strong><</strong></font> <a href=\"javascript:history.go(-1)\">Go Back</a></center>";  
 Die();
}
if (ereg("\>", $name)) {
echo "<center>Invalid Characters: <font color = \"red\"><strong>></strong></font> <a href=\"javascript:history.go(-1)\">Go Back</a></center>";  
 Die();
}
if (ereg("\[", $name)) {
echo "<center>Invalid Characters: <font color = \"red\"><strong>[</strong></font> <a href=\"javascript:history.go(-1)\">Go Back</a></center>";  
 Die();
}
if …
bluetoot 0 Newbie Poster

Hi people.

I got this error fixed, thanks for stopping by

bluetoot 0 Newbie Poster

Please can someone help me out with this error?
Parse error: syntax error, unexpected ';' in /home/npr/public_html/getfile.php on line 12

if i take off the line 12 the page works but i need to include the line 12.HELP!

<?php
include('recruit.php');

$id = $_GET['id'];
mysql_select_db($database_, $recruit);
$query_users = "SELECT * FROM files WHERE id='$id'";
$tmp = mysql_query($query_users, $recruit) or die(mysql_error());
$row_users = mysql_fetch_assoc($tmp);
$totalRows_users = mysql_num_rows($tmp);
{
echo "File: <a href=uploads/" . $row_users['newfile'] . ">File</a><br /><br />";
echo "back: <a href=../db_recruit/view.php" . $row_users['id'] . ">back</a><br /><br />".;

}
?>
bluetoot 0 Newbie Poster

Hello good ITz

bluetoot 0 Newbie Poster

Hello All

I guess my note is long enough to get someone confused.

let me simplify it

1. i have a user registration form and i need to add a multiple upload file component in the form.this forms goes to the next page which is a form displaying what the user has filled

First page

<?
//register session
if (!$PHPSESSIONID){
  session_register('sname');
<input name="firstname" type="text" maxlength="50" />

this is the second page:

<?
//start session
  session_start();	
  //pass post data into session variables
  $HTTP_SESSION_VARS['sname'] = addslashes($HTTP_POST_VARS['name']);

this second page echos what you have filled in the first page
for instance:

<? echo $HTTP_SESSION_VARS['sfirstname']; ?>

please can someone tell me what to do to add the upload component

thank you

bluetoot 0 Newbie Poster

Hello good ITz

This is my last resort,I've checked threads but saw no answer to my question,I blieve you good people will help me out

This are my existing forms, i want to add a multiple file upload system to it for each user that signs up as shown below

Begining of form
(Toggle Plain Text)

<?php session_start();
//include('vdaemon/vdaemon.php'); ?>
<!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>testing</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script language="JavaScript" 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];}}
}
//-->
</script>
</head>

<body bgcolor="#FFFFFF">
<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">
<?
//register session
if (!$PHPSESSIONID){
  session_register('stitle');
  session_register('sfirstname');
  session_register('smiddlename');
  session_register('ssurname');
  } 
?>

  <table width="780" border="0" cellpadding="0" cellspacing="2">
    <tr> 
      <td height="27"> <div align="center"> 

          <table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#FFFFFF">
            <tr> 
              <td height="25"> <div align="center"> 
                  <table width="100%" border="0" cellpadding="2" cellspacing="2">
                    <tr> 
                      <td width="1%" height="26" bgcolor="#CCCCCC"> 
                        &nbsp;</td>
                      <td width="97%" height="26" bgcolor="#CCCCCC"> <div align="right"> 
                          <table border=0 cellspacing=0 cellpadding=0>
                            <tr> 
                              <td width=170 bgcolor="#006699">&nbsp;<script language=JavaScript 
      src="../../scripts/vnu_datestamp.js"></script></td>
                              <td width="100" align="center" bgcolor="#FF0000"><font color="#FFFFFF" size="2" face="arial">Step 
                                1</font></td>
                              <td width="20" bgcolor="#006699">&nbsp;</td>
                              <td width="100" align="center" bgcolor="#FFFFFF"><font color="#000066" size="2" face="arial">Step 
                                2</font></td>
                            </tr>
                            <tr> 
                              <td height="1" colspan="4" bgcolor="#CCCCCC"><table height="1" width="100%" border="0" cellspacing="0" cellpadding="0">
                                  <tr> 
                                    <td> </td>
                                  </tr>
                                </table></td>
                            </tr>
                          </table>
                        </div></td>
                      <td width="19%" rowspan="2" bgcolor="#FFFFFF">&nbsp;</td>
                    </tr>
                    <tr> 
                      <td height="121" bgcolor="#999999" valign="top" colspan="2"> <blockquote> 
                          <div align="left"> 
                            <form name="form1" id="form1" …
bluetoot 0 Newbie Poster

Hello good ITz

This is my last resort,I've checked threads but saw no answer to my question,I blieve you good people will help me out

This are my existing forms, i want to add a multiple file upload system to it for each user that signs up as shown below

Begining of form

<?php session_start();
//include('vdaemon/vdaemon.php'); ?>
<!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>testing</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script language="JavaScript" 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];}}
}
//-->
</script>
</head>

<body bgcolor="#FFFFFF">
<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">
<?
//register session
if (!$PHPSESSIONID){
  session_register('stitle');
  session_register('sfirstname');
  session_register('smiddlename');
  session_register('ssurname');
  } 
?>
 
  <table width="780" border="0" cellpadding="0" cellspacing="2">
    <tr> 
      <td height="27"> <div align="center"> 
 
          <table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#FFFFFF">
            <tr> 
              <td height="25"> <div align="center"> 
                  <table width="100%" border="0" cellpadding="2" cellspacing="2">
                    <tr> 
                      <td width="1%" height="26" bgcolor="#CCCCCC"> 
						&nbsp;</td>
                      <td width="97%" height="26" bgcolor="#CCCCCC"> <div align="right"> 
                          <table border=0 cellspacing=0 cellpadding=0>
                            <tr> 
                              <td width=170 bgcolor="#006699">&nbsp;<script language=JavaScript 
      src="../../scripts/vnu_datestamp.js"></script></td>
                              <td width="100" align="center" bgcolor="#FF0000"><font color="#FFFFFF" size="2" face="arial">Step 
                                1</font></td>
                              <td width="20" bgcolor="#006699">&nbsp;</td>
                              <td width="100" align="center" bgcolor="#FFFFFF"><font color="#000066" size="2" face="arial">Step 
                                2</font></td>
                            </tr>
                            <tr> 
                              <td height="1" colspan="4" bgcolor="#CCCCCC"><table height="1" width="100%" border="0" cellspacing="0" cellpadding="0">
                                  <tr> 
                                    <td> </td>
                                  </tr>
                                </table></td>
                            </tr>
                          </table>
                        </div></td>
                      <td width="19%" rowspan="2" bgcolor="#FFFFFF">&nbsp;</td>
                    </tr>
                    <tr> 
                      <td height="121" bgcolor="#999999" valign="top" colspan="2"> <blockquote> 
                          <div align="left"> 
                            <form name="form1" id="form1" …
smantscheff commented: Trying to waste our time. Too lazy to state the problem concise and clearly. +0
bluetoot 0 Newbie Poster

Hello Good People.

I need help with my database script,to an extent i have created all the tables i need...for 5 straight days i cant seem to find the solution to this please read my script below

1. i have a database with 2 tables, the admin andm users_cv tables

with the userform on the frontend you can upoad files and fill in your data
on the other hand as an ADMin i can view the data posted by users on an admin page, but the pain here is getting the code to make the uploaded file visible on the viewing admin page.


THIS IS THE ADMIN PAGE(VIEW.PHP) WHERE I VIEW DATA POSTED BY A VISITOR,THE ONLY PART OF THE FORM NOT WORKING IS WHERE YOU HAVE THE COLUMN FOR LEGAL DOCUMENTS(THIS IS SUPOSE TO SHOW THE FILE THE USER UPLOADED DURING THE ONLINE FILLING.

<?php session_start();
require_once('../Connections/recruit.php'); ?>
<!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>nass :: User's Profile</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script language="JavaScript" 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];}}
}
//-->
</script>
<style type="text/css">
<!--
.style1 {color: #000066}
.profileheader {font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 24px;
	font-weight: bold;
	color: #000000;}
.shade {background-color: #666666;
	color: #FFFFFF;
	display: block;
	font-family: Arial, Helvetica, sans-serif;
	font-weight: bold;
	font-size: 12px;
	padding-left: 15px;}
.subheading {
	border-right-width: thin;
	border-bottom-width: medium;
	border-left-width: …
bluetoot 0 Newbie Poster

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 …
bluetoot 0 Newbie Poster

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

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 …
bluetoot 0 Newbie Poster

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

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" …
bluetoot 0 Newbie Poster

Erro code is on line 5 please can you help me with this good people?

//print_r($_SESSION);

// SELECT DATABASE
mysql_select_db($database_recruit) or die(mysql_error());
$result = mysql_query(" insert into users_cv 
SET
 title = '$title',
 firstname = '$firstname',
 middlename = '$middlename',
 surname = '$surname',					  
 priornames = '$priornames'
 reasons = '$reasons',
 birthplace = '$birthplace',				  
 dob_month = '$dob_month',					  
 dob_day = '$dob_day',					  
 dob_year = '$dob_year',
 sex = '$sex',
 nigeria_address = '$nigeria_address',
 state_of_origin = '$state_of_origin',
 lga = '$lga',	
 current_address = '$current_address',
 contact_details = '$contact_details',
 phone = '$phone',	
 fax = '$fax',
 occupation = '$occupation',
 identification = '$identification',			  					  					  
 eyes = '$eyes',					  
 hair = '$hair',					  
 special_features = '$special_features',					  
 marital_status = '$marital_status',
 kinname = '$kinname',					  
 kin_address = '$kin_address',					  
 kin_relationship = '$kin_relationship', 	
 date_posted = '$date_posted',				  					  
 resume = '$resume' ") or die(mysql_error());
//
bluetoot 0 Newbie Poster

hello,ptriteas,

what is the correct syntax please?
i am not a guru on this,can you also tell me how to use code tags/

thanks

bluetoot 0 Newbie Poster

Hello Good People

I have this error message....Parse error: syntax error, unexpected T_STRING in on line 111 ($result = mysql_query(" insert into users_cv )


this is the script line wherei have it

// SELECT DATABASE
mysql_select_db($database_recruit) or die(mysql_error());
$result = mysql_query(" insert into users_cv
SET
title = '$title',
firstname = '$firstname',
middlename = '$middlename',
surname = '$surname',
priornames = '$priornames'
reasons = '$reasons',
birthplace = '$birthplace',
dob_month = '$dob_month',
dob_day = '$dob_day',
dob_year = '$dob_year',
sex = '$sex',
nigeria_address = '$nigeria_address',
state_of_origin = '$state_of_origin',
lga = '$lga',
current_address = '$current_address',
contact_details = '$contact_details',
phone = '$phone',
fax = '$fax',
occupation = '$occupation',
identification = '$identification',
eyes = '$eyes',
hair = '$hair',
special_features = '$special_features',
marital_status = '$marital_status',
kinname = '$kinname',
kin_address = '$kin_address',
kin_relationship = '$kin_relationship',
date_posted = '$date_posted',
resume = '$resume' ") or die(mysql_error());
//


please can anyone help me with this?
thanks

bluetoot 0 Newbie Poster

Hi bluetoot,

You are missing some comma's seperating your SET variables.
birthplace = '$birthplace',
for example.

Also, please use the CODE tags when posting code, it makes it much easier to read.


Hope this helps.
Zagga

thanks Zagga it worked but i have another error message on line 108

Parse error: syntax error, unexpected T_STRING in

this is the code
$headers = "To: webmaster<spicysaratx@yahoo.com>\r\n";

this is here
/* additional headers */
$headers = "To: webmaster<spicysaratx@yahoo.com>\r\n";
$headers .= "From:"."$email"."\r\n";
$headers .= "Reply-to:"."$email"."\r\n";
$headers .= phpversion();

/* and now mail it */

bluetoot 0 Newbie Poster
<?php session_start();
include("../Connections/recruit.php");


echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">";
//check certification
$certification = $HTTP_POST_VARS;
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;
$firstname = $HTTP_SESSION_VARS;
$middlename = $HTTP_SESSION_VARS;
$surname = $HTTP_SESSION_VARS;
$priornames = $HTTP_SESSION_VARS;
$reasons = $HTTP_SESSION_VARS;
$birthplace = $HTTP_SESSION_VARS;
$dob_month = $HTTP_SESSION_VARS;
$dob_day = $HTTP_SESSION_VARS;
$dob_year = $HTTP_SESSION_VARS;
$sex = $HTTP_SESSION_VARS;
$nigeria_address = $HTTP_SESSION_VARS;
$state_of_origin = $HTTP_SESSION_VARS;
$lga = $HTTP_SESSION_VARS;
$current_address = $HTTP_SESSION_VARS;
$phone = $HTTP_SESSION_VARS;
$fax = $HTTP_SESSION_VARS;
$email = $HTTP_SESSION_VARS;
$eyes = $HTTP_SESSION_VARS;
$hair = $HTTP_SESSION_VARS;
$special_features = $HTTP_SESSION_VARS;
$height = $HTTP_SESSION_VARS;
$weight = $HTTP_SESSION_VARS;
$marital_status = $HTTP_SESSION_VARS;
$kinname = $HTTP_SESSION_VARS;
$kin_address = $HTTP_SESSION_VARS;
$kin_relationship = $HTTP_SESSION_VARS;


//resume
$resume = $HTTP_SESSION_VARS;
?>



<!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" …
bluetoot 0 Newbie Poster

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reasons = '', birthplace = '' dob_month = 'January', dob_day = '' at line 8


Hello aLL

I am developing an online registration form that that a mail application that submits the data to databa and send copy to an email.

when i test drive the form, it gives me the error message above.

i need help,if possible i can send the file to anyone who wants to help me thank you