whats the problem!

[rameshfaj]

Can anyone say anything that makes the following function call an error:

This is a coordination of PHP and Mysql

function editjobpost($pid,$description,$ownership,$title,$companyname,$openings,$sex,$age,$qualification,$experience,$skills,$responsibility,$location,$salary,$servicetype,$maritalstatus,$dbconnection)
{
if(!($description="")||(!($salary=""))||(!($location=""))||(!($title=""))||(!($openings=""))) 
{
$sql="UPDATE jobpost set companyname='".$companyname."' ,title='".$title."',description='".$description."',
	openings='".$openings."',
	 sex='".$sex."',
	  age='".$age."',
	   qualification='".$qualification."',experience='".$experience."',responsibility='".$responsibility."',skills='".$skills."',ownership='".$ownership."',location='".$location."',salary='".$salary."',service_type='".$servicetype."',maritalstatus='".$maritalstatus."' where pid='".$pid."'";
$result=mysql_query($sql,$dbconnection) 
	or die('<div class="error"> ERROR, while adding new JOB <br>'.mysql_error().'</div>');
return("Job Successfully Updated!!!");
}
}	

[fenway]

That's ugly... echo the query after the variables have been substitued.

[bubblegum.anarchy]

My money is on a wayward quote....

 

... mysql_real_escape_string()

[rameshfaj]

That's ugly... echo the query after the variables have been substitued.

 

where is the echo? or where it should be or not be used?Its fully functionality

implementing the database manipulation!

[fenway]

You're sending a query to database... I want to see what the database gets, sans PHP.

[rameshfaj]

The function is called providing the corresponding values.When the function is called nothing result comes even if there are the corresponding data in the corresponding tables.

[fenway]

Still... echo the $sql variable.