Breathing Spring

Archive for December, 2008

A quick sample of How to user loadRow and Root Directory

$query=”select userid, pgitemfilename from “.$this->_table_prefix.”profilegallery where id=”.$id;
$this->_db->setQuery( $query );
$this->_db->query();
$row=$this->_db->loadRow();
$pgitemfilename=$row[1];
$userid=$row[0];

unlink( JPATH_ROOT.DS.”images”.DS.”comprofiler”.DS.”plug_profilegallery”.DS.$userid.DS.$pgitemfilename);
unlink( JPATH_ROOT.DS.”images”.DS.”comprofiler”.DS.”plug_profilegallery”.DS.$userid.DS.”tn”.$pgitemfilename);

Insert or Replace Plus adding string to string in mysql

INSERT INTO answers( player, answer )
VALUES (
‘lamis’, ‘-1-0′
) ON DUPLICATE
KEY UPDATE answer = CONCAT(answer, ‘-1-0′)