ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

How to: Create a database and contents list (index) from weblog entries

September 10, 2008 10:26am

Subscribe [2]
  • #1 / Sep 10, 2008 10:26am

    Ogar

    34 posts

    Hi

    Two questions in one

    I have a weblog to which members can enter their details such as name, dates etc, to their own particular Publish page which is then shown one member per page using pagination.  The result is an individual’s own web page.

    I use the {exp:weblog:entries} tag with variables such as {studio_name}, {address}, etc.

    How do I:

    a) create a contents list with links on each name, say “studio_name”, to each member directing the visitor to that particular member’s page?

    b) put all the entries onto one printable page as a database list.  I have tried and only get so far as the first entry appearing, the rest do not follow despite removing the pagination tag.

    Thank you

    Alex

  • #2 / Sep 10, 2008 10:39am

    Cem Meric

    210 posts

    sounds like a dynamic=“off” issue. can you provide some code examples?

  • #3 / Sep 10, 2008 10:47am

    Ogar

    34 posts

    The tags are at the start and end of this code.  The rest is just the variables.

    Thanks Cem    

    {exp:weblog:entries weblog="studioprofiles" cache="yes" refresh="60" orderby="studio_name"}
         
          <table border=0 cellspacing=5 cellpadding=0>
            <tr>
              <td width=228 height=28 colspan=2 valign=top>{studio_name}
              </td>
              <td width=229 valign=top>http://www.artonthemap.org.uk/Resources/_clear.gif</td>
            </tr>
            <tr>
              <td width=228 height=22 colspan=2 valign=top>http://www.artonthemap.org.uk/Resources/_clear.gif</td>
              <td width=229 valign=top>http://www.artonthemap.org.uk/Resources/_clear.gif</td>
            </tr>
            <tr>
              <td width=111 height=19 valign=top>Clustergroup:
              </td>
              <td width=346 colspan=2 valign=top>{clustergroup}
              </td>
            </tr>
            <tr>
              <td width=111 height=18 valign=top><span class=“contenttitle”>Address:</span>
              </td>
              <td width=346 colspan=2 valign=top>{studio_address}
              </td>
            </tr>
            <tr>
              <td width=111 height=18 valign=top><span class=“contenttitle”>Telephone:</span>
              </td>
              <td width=346 colspan=2 valign=top>{studio_telephone}
              </td>
            </tr>
            <tr>
              <td width=111 height=18 valign=top><span class=“contenttitle”>email:</span>
              </td>
              <td width=346 colspan=2 valign=top>{studio_email}
              </td>
            </tr>
            <tr>
              <td width=111 height=18 valign=top><span class=“contenttitle”>Web site: </span>
              </td>
              <td width=346 colspan=2 valign=top>{studio_website}
              </td>
            </tr>
            <tr>
              <td width=111 height=18 valign=top>http://www.artonthemap.org.uk/Resources/_clear.gif</td>
              <td width=112 valign=top>http://www.artonthemap.org.uk/Resources/_clear.gif</td>
              <td width=229 valign=top>http://www.artonthemap.org.uk/Resources/_clear.gif</td>
            </tr>
            <tr>
              <td width=111 height=80 valign=top>http://www.artonthemap.org.uk/Resources/_clear.gif</td>
              <td width=112 valign=top>http://www.artonthemap.org.uk/Resources/_clear.gif</td>
              <td width=229 valign=top>http://www.artonthemap.org.uk/Resources/_clear.gif</td>
            </tr>
          </table>
          {/exp:weblog:entries}

  • #4 / Sep 10, 2008 11:07am

    Cem Meric

    210 posts

    try it with this to start with

    {exp:weblog:entries weblog="studioprofiles" dynamic="off" cache="yes" refresh="60" orderby="studio_name"}

    also I can’t see links with {studio_name} tag in your html. can you tell us what template_group/template structure you’re using to create those links?

  • #5 / Sep 10, 2008 11:36am

    Ogar

    34 posts

    I don’t quite understand what you mean about the html.

    The URL is

    index.php/Office/memberdatabase/

    i.e. a template within the same template group as the “studio profiles” - this template group is called Office.

    Hope that helps.

    AAAh!  This concerns the printable database - not the contents index.  That I have no idea how to to.

    Thanks - Alex

  • #6 / Sep 13, 2008 7:44am

    Ogar

    34 posts

    I’ve sorted the second problem - thanks.  I was doing everything right except altering the template on the web.  Instead I was uploading the template via ftp as I usually do and the template was not updating for some reason.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases