[TYPO3-english] Is this a fullQuoteStr mistake?
Luming Xing
xingluming at googlemail.com
Mon Apr 6 00:22:14 CEST 2009
Hello Everyone,
I'm working on a search function. user can just use a part of a book name
to search fully book name.
I have some troube in following code, No result is returned. how sould i
do, Is there any mistake in SQL LIKE field? or a fullQuoteStr mistake?
Thank you for all help!
$res=$GLOBALS['TYPO3_DB']->exec_SELECTquery(
'*', #select
'tx_romoduxing_module', #from
'modul_name='.$GLOBALS['TYPO3_DB']->escapeStrForLike($this->piVars['modul_name'],
'tx_romoduxing_module'),
#'modul_name like
\'%'.$GLOBALS['TYPO3_DB']->fullQuoteStr($this->piVars['modul_name'],
'tx_romoduxing_module').'%\'',
'',
'',
'');
Luming xing
More information about the TYPO3-english
mailing list