Hi,
you can try these Database Functions:
$GLOBALS['TYPO3_DB']->exec_SELECTgetRows
Page is in German, but Example should be fine:
http://www.pi-phi.de/database-api.html
Regards,
Andrea
Am 07.09.2011 21:13, schrieb Piotr Burda:
Hi group
I need to add some parameters to a query in my own extension (simple
list of products)
I need to add:
$addWhere = 'AND categories LIKE "%spo%"';
all code for query:
$addWhere = 'AND categories LIKE "%spo%"';
$count = 1;
list($this->internal['orderBy'],$this->internal['descFlag']) =
explode(':',$this->piVars['sort']);
$this->internal['results_at_a_time']=t3lib_div::intInRange($lConf['results_at_a_time'],0,1000,15);
// Number of results to show in a listing.
$this->internal['maxPages']=t3lib_div::intInRange($lConf['maxPages'],0,1000,2);;
// The maximum number of "pages" in the browse-box: "Page 1", "Page 2",
etc.
$this->internal['searchFieldList']='name,categories';
$this->internal['orderByList']='uid';
// Get number of records:
$res =
$this->pi_exec_query('tx_pbproductskasyfiskalne_kasy_fiskalne',$count,$addWhere);
list($this->internal['res_count']) =
$GLOBALS['TYPO3_DB']->sql_fetch_row($res);
But it doesn`t work, as result i have full list of products.
PLS help to resolve this problem
Regards
Piotr
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english