Forum

Please consider registering
guest

Log In Register

Register | Lost password?
Search
Advanced Search
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 3 characters - maximum search word length is 84 characters

Topic RSS
SQL in Sermon Browser only returns one item
7 July, 2011
9:03 pm
enzoaeneas
New Member
Forum Posts: 1
Member Since:
7 July, 2011
Offline
1

This happens for preachers, sermons, series, and services.

It will only show one per item.
I pasted one of your SQL expressions into phpmyadmin and ran it.

SELECT wp_sb_preachers.*, COUNT(wp_sb_sermons.id) AS sermon_count FROM wp_sb_preachers LEFT JOIN wp_sb_sermons ON wp_sb_preachers.id=preacher_id GROUP BY preacher_id ORDER BY name ASC

It only returns one entry, even though I have 3 available.

In order for more than one to show up, I have associate a sermon with it.

version .45.4
WP 3.1 and now 3.2

All RSS
Forum Timezone: Europe/London

Most Users Ever Online: 40

Currently Online:
12 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

malpan: 2453

jogen: 2440

VanWatterson: 652

GeraldSebring: 364

LucasWoltman: 362

RandellFeenstra: 362

Member Stats:

Guest Posters: 7

Members: 2066

Moderators: 1

Admins: 1

Forum Stats:

Groups: 1

Forums: 2

Topics: 1071

Posts: 4045

Newest Members: Nixon Designs, zolaperry, tanec69, lbakyl, richdorm, Aaron Velasquez

Moderators: Ben Miller (387)

Administrators: Mark Barnes (425)

Comments are closed.