Getting DB error on using pods () function
-
Hi
I’ve created a pod “movies” with “language” as one of the fields.
Now I’m trying to create a page where I’m trying to filter all movies where language is not “English”.
I’m using the below code, but getting the error as second code block below. Could you help what am I doing wrong?
$params = [ 'limit' => 25, 'where' => 't.language != "English"', ]; $mypod = pods( 'movies', $params ); //$mypod = pods( 'mypod' )->find( $params ); // Loop through the items returned. while ( $mypod->fetch() ) { echo '<p>' . $mypod->display( 'ms_title' ) . '</p>'; }
Database Error; SQL: SELECT DISTINCT
t
.* FROMwp_kekc_posts
ASt
WHERE ( ( t.language != "English" ) AND (t
.post_type
= 'movies' ) AND (t
.post_status
IN ( 'publish' ) ) ) ORDER BYt
.menu_order
,t
.post_title
,t
.post_date
LIMIT 0, 25; Response: Unknown column 't.language' in 'where clause'
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Getting DB error on using pods () function’ is closed to new replies.