/*============================= check for presence of bid from this seller=========================*/
$stmt="SELECT * FROM `bidding` WHERE `proj_id`='$id' AND `seller_id`='$row[id]'";
$res_bid=mysql_query($stmt);
$row_bid=mysql_fetch_array($res_bid);
$num=mysql_num_rows($res_bid);

if($num)
{
//update present bid data
$sql_update="UPDATE `bidding` SET `proj_id`='$id',`seller_id`='$row[id]',`seller_name`='$user',`bid_amount`='$amount',`ti meframe`='$days',`bid_time`='$bid_time',`bid_date` ='$date',`bid_details`='$details',`bid_notify`='$n otify',`bid_status`='0' WHERE `proj_id`='$id' AND `seller_id`='$row[id]'";
$res_update=mysql_query($sql_update)
or die("Could not update data".mysql_error());
$msg="Your bid has been successfully UPDATED";
header("location:confirmation.php?msg=$msg");
}
else
{
//insert first bid data
$qry="INSERT INTO `bidding` VALUES('','$id','$row[id]','$user','$amount','$days','$bid_time','$date','$ details','$notify','0')";
$result=mysql_query($qry)
or die("Could not insert data".mysql_error());
$msg="Your bid has been successfully recorded";
header("location:confirmation.php?msg=$msg");
}




------------------ Please suggest me how can i get the last inserted id in updation.

Meh ???
Don't you actually get it to specify which record to update ?
Don't know if you talk about the proj_id or the seller_id though.

Simply keep that id in a separate variable...
On each update, the variable will be updated with the last id that have been updated.

you can ever do a mysql_insert_id function but that will only return for an insert opereation

or you could make you're own function let's say

PHP Code:

function mysql_last_id($table){
    $sql="SELECT max(id) as last_id FROM `$table` ";
    $res=mysql_query($sql);
    $row=mysql_fetch_array($res);

return $row['last_id'];
} 


Hope it helps

The facti is that he don't want to get a insert id, but an update id, which is rather strange, as you have to know which record you want to update, thus the id of this record.

in that case you just do a select id from the table with the where conditions from the update

yeah, but he already have it, as he just did an update !!!

now that i had a better look you are right ...
he has the $row_bid array that contains his id