Newbie needs myphpadmin help

In general, the method is like this:

<?php foreach (array(3,4,5) as $regcat) {
   $sql = "
      SELECT events.*
      FROM WP_FSEVENTS events
      JOIN WP_FSEVENTS_CATS cats1 ON (events.eventid = cats1.eventid)
      JOIN WP_FSEVENTS_CATS cats2 ON (events.eventid = cats2.eventid)
      WHERE cats1.catid = 12
      AND cats2.catid = $regcat";
   $annual_events = $wpdb->get_results($sql);
   echo '<div class="annual-events">';
   foreach ($annual_events as $annual_event) {
      echo "<h2>$annual_event->subject</h2>";
      echo "<p>$annual_event->tsfrom</p>";
      echo "<p>$annual_event->description</p>";
      echo '<br />';
   }
   echo '</div><!-- End annual-events -->';
}
?>

You must put this in code to provide the rest of the page layout. Since I am not familiar with the code that Artisteer generates, I can’t be much more help unless you can put the code for an event page in a pastebin and post a link to it here.

I don’t know what files Artisteer generates. If there is a page.php file in your theme, put it in a pastebin and post a link here.

I will convert it into a template. You will then put the template in your theme folder, create a blank Page, and assign the template to it.

You are correct:

• the code is put in a template
• the template is assigned to a page
• when that page is selected, the data will show in it

Your pastebin link does not lead to your code.

Here is a function to create a shortcode for your event list.

Paste it to the end of your functions.php, leaving no blank lines between the current end and the start of this code. You might need to alter the code a little as some functions.php files do not want the opening <?php or the closing ?> tags.

Create a page to display your data. Put whatever text you want in the page. At the point where you want the events for catid 3, put this shortcode:

[mm-event catid=3]

Put in similar shortcodes for catids 4 and 5.

Publish the page and view it.

Alter the code in the function to change the display to what you want.