Thread

I have been reviewing the forum posts on alphabetical navigation and have my page working almost the way I want it to.  I want to display the records and not just link a title to select from. How do I pull the data for the web log?

I am wanting to pull some of the other fields in the web log such and their address and dates they were aboard the ship.  I will paginate and clean up once I figure out how to pull this other information.

Any assistance would be appreciated.

Link to page

http://www.ussalgolaka54.org/index.php/site/shiproster/

My code far.

{exp:query sql="SELECT title, entry_id, url_title AS urlt FROM exp_weblog_titles 
WHERE weblog_id = '2' AND title LIKE '{segment_3}%' ORDER BY title ASC"} 


{title}



{/exp:query}

{exp:query sql="SELECT t.title, t.entry_id, t.url_title AS urlt, d.field_id_1 as body FROM exp_weblog_titles t LEFT JOIN exp_weblog_data d ON t.entry_id = d.entry_id WHERE t.weblog_id = '2' AND t.title LIKE '{segment_3}%' ORDER BY t.title ASC"}
  {title}
  {body}
{/exp:query}

This query should give you access to the custom fields linked to that entry. Just find out which field_id_x belongs to which field and place those in the query.

Greetz,
Wouter

Thank you for the quick response.  I appreciate the assistance.

Worked like a champ. Thank you for the assistance.  Now I have to go in and clean up the layout of the pages

Glad to see you’re all set.

If you have any other questions, everyone here on the forums are easer to help.

Greetz,
Wouter