3 users online. Create an account or sign in to join them.Users

Search

How can I fetch an entry from section_id = 4, that has email = 'something@somewhere.com' using EntryManager? How do I construct the $where argument? I find the documentation to not be very useful here. Thanks in advance!

You will need to build the WHERE and JOIN statements yourself, so you'll need to know the field ID to build the table name. You could use something like the SymQL extension instead, which is a wrapper on top of these classes to prevent you having to write SQL.

Ok, to bad. I hoped it would be possible in a simpler manner because I actually have to look for a match in 6 possible fields, so that would mean joining with 6 tables...

Edit: ah, your symsql extension seems like a nice solution, thanks!

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.2 or above
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.0 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details