$sqlSURVEY_AnsSUid=mysql_query("SELECT *  FROM `xp_survey_answer` ")or die(mysql_error());

while ($rowSURVEY_Ans=mysql_fetch_array($sqlSURVEY_AnsSUid))
{
$ans_su_id[]=$rowSURVEY_Ans['ans_su_id'];
}

$str2 = implode(',',array_unique($ans_su_id));

// geting max 
$sqlSURVEY_Amax=mysql_query("SELECT max(ans_q_id) as maxq  FROM `xp_survey_answer` ")or die(mysql_error());
$rooo=mysql_fetch_assoc($sqlSURVEY_Amax);

$maxq=$rooo['maxq'];

// end geting max

// puting all in arrays
$sqlSURVEY_Ac=mysql_query("SELECT *   FROM `xp_survey_answer`  where

$sql=mysql_query("SELECT `ans_id`, `ans_caption`, `ans_position`, `ans_su_id`, 'ans_q_id'   FROM `MY_TABLE`  where ans_su_id='2'");
$row=mysql_fetch_assoc($sql);
$num=mysql_num_rows($sql);

$sql=mysql_query("select * from `yourtable` where id='theid'")or die(mysql_error());
$row=mysql_fetch_assoc($sql);
echo $row['name1'].$row['name2'].$row['name3'].$row['name4'];

$sql_f="SELECT reg_id, count(bid_price) as cnt, min(bid_price) as low FROM `bidding_details` where bid_id='$bid_id' and sortbid = '1' group by reg_id HAVING COUNT(reg_id) > 9  limit 50";
$results=mysql_query($sql_f)or die(mysql_error());
$row = mysql_fetch_assoc($results);
$num = $row['low'];
$cnt = $row['cnt'];

if($cnt > 9) {

$sql_u="update

$resultr = mysql_query("SELECT id, rank FROM bidding_details where bid_id=$bid_id and sortbid='1' ORDER BY bid_price DESC");
$rank=1;

while ($myrow=mysql_fetch_row($resultr)) {

$id = $myrow[0];
mysql_query("UPDATE bidding_details SET rank=$rank WHERE bid_id=$bid_id and id=$id and sortbid='1'");

$rank++;