Posted by Milan Krejci on 11/01/07 10:09

$types =
array('text','text','text','date','text','text','text','integer','integer','integer','integer','integer','integer','integer','integer','integer','integer','text','text');
$st = $this->mdb2->prepare("INSERT INTO girls
(email,name,surname,dateOfBirth,country,city,nationality,tall,weight,hairColor,eyeColor,education,profession,maritalStatus,children,smokingHabits,drinkingHabits,aimOfSearch,notes)"
."VALUES
(:email,:name,:surname,:dateOfBirth,:country,:city,:nationality,:tall,:weight,:hair,:eye,:education,:profession,:maritalStatus,:children,:smokingHabits,:drinkingHabits,:aimOfSearch,:notes)",
$types);
$data = array('email' => $this->email, 'name' => $this->name, 'surname'
=> $this->surname, 'dateOfBirth' => $this->dateOfBirth,'country' =>
$this->country,'city' => $this->city,'nationality' =>
$this->nationality,'tall' => $this->tall, 'weight' =>
$this->weight,'hair' =>
$hair,'eye'=>$eye,'education'=>$education,'profession'=>$profession,'maritalStatus'=>$maritalStatus,'children'=>$this->children,'smokingHabits'=>$smokingHabits,'drinkingHabits'=>$drinkingHabits,'aimOfSearch'=>$this->aimOfSearch,'notes'=>$this->notes);
$st=$this->mdb2->prepare("insert into girls(email) values ('d.cz')");
$affectedRows = $st->execute();
if (PEAR::isError($st)) die($st->getMessage());
var_dump($affectedRows);

affectedRows is an object and not int. any idea why?

[Back to original message]