Solution Required -- urgent

[phpprogrammer]

Dear Friends,

plz see the code

<?

Class class CMyClass extends CDBConnect
{
var $intSurveyId =12;
var $strSurveyOption1='phptalk.com';
var $strSurveyOption2='php.net';
var $strSurveyOption3='mysql.com';
var $strSurveyOption4='zend.com';

// to insert the above option values into my table i am using the following code

function addsurveyoptions()
{

$SqlQuery1="insert into tblsurvey(surveyoption,surveyid)
values(" . $this->strSurveyoption1."','".$this->intSurveyId."')";

$SqlQuery2="insert into tblsurvey(surveyoption,surveyid)
values(" . $this->strSurveyoption1."','".$this->intSurveyId."')";

$SqlQuery3="insert into tblsurvey(surveyoption,surveyid)
values(" . $this->strSurveyoption3."','".$this->intSurveyId."')";

$SqlQuery4="insert into tblsurvey(surveyoption,surveyid)
values(" . $this->strSurveyoption4."','".$this->intSurveyId."')";

  mysql_query($SqlQuery1);
  mysql_query($SqlQuery2);
  mysql_query($SqlQuery3);
  mysql_query($SqlQuery4);

}

}

// my query is instead of writing this number of sqlquerys is it possible to write a single query with for loop

// plz give me the code , it is urgent

regards
bvsureshbabu

[yuraupt]

Class class CMyClass extends CDBConnect
{
    var $intSurveyId;
    var $strSurveyOptions;

// constructor
function CMyClass(){

	$this->intSurveyId =12;

	$this->strSurveyOptions[]='phptalk.com';
	$this->strSurveyOptions[]='php.net';
	$this->strSurveyOptions[]='mysql.com';
	$this->strSurveyOptions[]='zend.com';
}

// to insert the above option values into my table i am using the following code

function addsurveyoptions()
{
	foreach($this->strSurveyOptions as $option){
		$SqlQuery="insert into tblsurvey(surveyoption,surveyid)
		values(" . $option."','".$this->intSurveyId."')";
		mysql_query($SqlQuery);
	}

}

} 

[mystrymaster]

store the inital values in an array

var $strSurveyOption[0]='phptalk.com'; 
var $strSurveyOption[1]='php.net'; 
var $strSurveyOption[2]='mysql.com'; 
var $strSurveyOption[3]='zend.com'; 

and then loop through the array in your insert with a while or for statement

control structures

[yuraupt]

And replace

Class class CMyClass extends CDBConnect

with just

class CMyClass extends CDBConnect

[phpprogrammer]

Dear yuraupt,

thanks for your solution

regards
bvsureshbabu