Query was empty

calling a function

[bluerain]

hi!

new in php here is there anyone who could help me on what is the problem with my code:
i have this sample.php code:

<?php
function addupdateEmployeeNew($empRecID, $employeeNo, $employeeID, $dateEmployed, $batchNo, $firstName, $middleName, $lastName,$streetAddress, $cityMunID, $provinceID, $birthDate, $sex, $civilStatus, $curPositionID, $curEmploymentStatus){
if ($empRecID==0) {
$sqlEmpRecord = "INSERT INTO employeerecordtbl (EmployeeNo, EmployeeID, DateEmployed, BatchNo, ";
$sqlEmpRecord = $sqlEmpRecord . "FirstName, MiddleName, LastName, StreetAddress, CityMunID, ProvinceID, ";
$sqlEmpRecord = $sqlEmpRecord ."BirthDate, Sex, CivilStatus, CurPositionID, CurEmploymentStatus) ";
$sqlEmpRecord = $sqlEmpRecord . "VALUES ('%s','%s','%s',%d,'%s','%s','%s','%s',%d,%d,'%s','%s','%s',%d,'%s');";
$sqlEmpRecord = sprintf($employeeNo, $employeeID, $dateEmployed, $batchNo, $firstName, $middleName, $lastName,
$streetAddress, $cityMunID, $provinceID, $birthDate, $sex, $civilStatus, $curPositionID, $curEmploymentStatus,$empRecID);
echo $sqlEmpRecord;
}

else{
$sqlEmpRecord = "UPDATE employeerecordtbl SET EmployeeNo = '%s', EmployeeID = '%s', DateEmployed = '%s', ";
$sqlEmpRecord = $sqlEmpRecord . "BatchNo = %d, FirstName = '%s', MiddleName = '%s', LastName = '%s', ";
$sqlEmpRecord = $sqlEmpRecord . "StreetAddress = '%s', CityMunID = %d, ProvinceID = %d, BirthDate = '%s', ";
$sqlEmpRecord = $sqlEmpRecord . "Sex = '%s', CivilStatus = '%s', CurPositionID = %d, ";
$sqlEmpRecord = $sqlEmpRecord . "CurEmploymentStatus = '%s' WHERE EmpRecID = %d;";
$sqlUser = sprintf($sqlUser, $employeeNo, $employeeID, $dateEmployed, $batchNo, $firstName, $middleName, $lastName,
$streetAddress, $cityMunID, $provinceID, $birthDate, $sex, $civilStatus, $curPositionID, $curEmploymentStatus,$empRecID);
}
$Is_Query_Sucessful = mysql_query($sqlUser) or die(mysql_error());
return $Is_Query_Sucessful;
}

an i have this callafunction.php code:

<?php
include ('Connections/pis.php');
include ('SAMPLE.php');
addupdateEmployeeNew(0, 'MKL123', 'MKL123', '2002-2-24',90, 'MEL', 'L', 'M','123 RGH', 1, 1, '1980-6-6', 'F', 'CSS', 106, 'N')
?>

this is just a sample code to test if my query can insert a record in the database but only the employee number field value can returned via echo then the error message query was empty

help please anyone. thanks in advance

;

[bluerain]

with code revision of sample.php page:

<?php
function addupdateEmployeeNew($empRecID, $employeeNo, $employeeID, $dateEmployed, $batchNo, $firstName, $middleName, $lastName,$streetAddress, $cityMunID, $provinceID, $birthDate, $sex, $civilStatus, $curPositionID, $curEmploymentStatus){
if ($empRecID==0) {
$sqlEmpRecord = "INSERT INTO employeerecordtbl (EmployeeNo, EmployeeID, DateEmployed, BatchNo, ";
$sqlEmpRecord = $sqlEmpRecord . "FirstName, MiddleName, LastName, StreetAddress, CityMunID, ProvinceID, ";
$sqlEmpRecord = $sqlEmpRecord ."BirthDate, Sex, CivilStatus, CurPositionID, CurEmploymentStatus) ";
$sqlEmpRecord = $sqlEmpRecord . "VALUES ('%s','%s','%s',%d,'%s','%s','%s','%s',%d,%d,'%s','%s','%s',%d,'%s');";
$sqlEmpRecord = sprintf($sqlEmpRecord, $employeeNo, $employeeID, $dateEmployed, $batchNo, $firstName, $middleName, $lastName,
$streetAddress, $cityMunID, $provinceID, $birthDate, $sex, $civilStatus, $curPositionID, $curEmploymentStatus);
echo $sqlEmpRecord;
}

else{
$sqlEmpRecord = "UPDATE employeerecordtbl SET EmployeeNo = '%s', EmployeeID = '%s', DateEmployed = '%s', ";
$sqlEmpRecord = $sqlEmpRecord . "BatchNo = %d, FirstName = '%s', MiddleName = '%s', LastName = '%s', ";
$sqlEmpRecord = $sqlEmpRecord . "StreetAddress = '%s', CityMunID = %d, ProvinceID = %d, BirthDate = '%s', ";
$sqlEmpRecord = $sqlEmpRecord . "Sex = '%s', CivilStatus = '%s', CurPositionID = %d, ";
$sqlEmpRecord = $sqlEmpRecord . "CurEmploymentStatus = '%s' WHERE EmpRecID = %d;";
$sqlUser = sprintf($sqlUser, $employeeNo, $employeeID, $dateEmployed, $batchNo, $firstName, $middleName, $lastName,
$streetAddress, $cityMunID, $provinceID, $birthDate, $sex, $civilStatus, $curPositionID, $curEmploymentStatus,$empRecID);
}
$Is_Query_Sucessful = mysql_query($sqlUser) or die(mysql_error());
return $Is_Query_Sucessful;
}

and the result is : INSERT INTO employeerecordtbl (EmployeeNo, EmployeeID, DateEmployed, BatchNo, FirstName, MiddleName, LastName, StreetAddress, CityMunID, ProvinceID, BirthDate, Sex, CivilStatus, CurPositionID, CurEmploymentStatus) VALUES ('MKL123','MKL1','2002-2-24',90,'MEL','L','M','123 RGH',1,1,'1980-6-6','F','CSS',106,'N');Query was empty

i dont know what is wrong with the query why it does not insert the record in the DB.

[bluerain]

got it solved heres the part with error

$sqlUser = sprintf($sqlUser, $employeeNo, $employeeID, $dateEmployed, $batchNo, $firstName, $middleName, $lastName,
$streetAddress, $cityMunID, $provinceID, $birthDate, $sex, $civilStatus, $curPositionID, $curEmploymentStatus,$empRecID);
}

should be

$sqlEmpRecord not $sqlUser ... im so dumb