[TYPO3-english] DB Select

Roberto Torresani erreti at gmail.com
Mon Oct 5 16:21:35 CEST 2009


Hi all!
I'm writing an extension. Now I have a table with uid and name of category
and another table with a field that reference to the first table.

Example Table 1;
uid;name
1;category1
2;category2
3;category3

Example Table 2
uid;name;category
1;name1;1,2
2;name2;2
3;name3;1,2,3

I need, for example, all the record of second table with category 1. What is
the command to use? I try with  exec_SELECTquery, but I don't find how set
the parameters.

Thanks
Roberto


More information about the TYPO3-english mailing list