What is wrong here ... as verb_id and item_code is being entered into the database as "0" ... even the date is like 0000/00/00 ...
Thanx in advance !!
<?php
$verb_description=$_REQUEST['verb'];
$item_description=$_REQUEST['item'];
$post_description=$_REQUEST['post_description'];
//to fetch verb_id
$verb_sql="SELECT verb_id FROM tbl_verbs_master WHERE verb_description='$verb_description'";
$verb_id=mysql_query($verb_sql) or die(mysql_error());
//to fetch item_code
$item_sql="SELECT item_code FROM tbl_item_master WHERE item_description='$item_description'";
$item_code=mysql_query($item_sql) or die(mysql_error());
$posted_on=date("Y/m/d");
$user_id="9";
$tbl_sql="INSERT INTO tbl_user_post_requirement(user_id,verb_id,item_code,post_description,posted_on)VALUES('$user_id','$verb_id','item_code','post_description','posted_on')";
$tbl_res=mysql_query($tbl_sql) or die(mysql_error());
?>