How to Pull Content from Specific Category

[biggupp]

This is a humble request for help, as I am stumped with this WordPress setup.

http://www.ahy4life.com/update_20121008/

The above is a testing site. I need to add additional categories but cannot seem to fathom precisely the proper code for a specific section on each page. An rtfm has been unsuccessful. I tried using query, also without success.
For example, if I wish to display the title and then the content from a post from 'events', which is ID=4, in the code below:

'
<?php if ( have_posts() ) : while ( have_posts() ) : the_post(); ?>

<h2><center><?php the_title(); ?></center></h2>

<!-- Display the Post's Content in a div box. -->

<?php the_content(); ?>

<?php endwhile; else: ?>
<p><?php _e('Sorry, no posts matched your criteria.'); ?></p>
<?php endif; ?>
'

what is the proper code?

[Junsee]

Have you code, or would like to know how?

you need connection details first

PHP Code:

$sql = "SELECT * FROM `table` WHERE `ID` = '$ID' ; ";
$rs = mysql_query($sql, $conn);
while ($row = mysql_fetch_array ($rs)){
    $column1 = $row['column1'];
    #more columns ... 

    echo $column1;
    # echo more columns    
} 


something like this...?

[biggupp]

My gut says the solution is a bit simpler. That is, the code I offered is what is used presently in the live site, and pulls content from a single category. Can this code be modified simply to specific a specific category is there are multiple categories?

[biggupp]

OK, I am trying to set up query using the code below for

<http://www.ahy4life.com/update_20121008/events.php>

for the category 'new_event' cat=5, but still not working.

'

<?php
$featuredPosts = new WP_Query();
$featuredPosts->query('showposts=5&cat=5');
while ($featuredPosts->have_posts()) : $featuredPosts->the_post(); ?>
<h2><center><a href="<?php the_permalink() ?>"><?php the_title(); ?></center></a></h2>


<?php the_content(); ?>

<?php endwhile; ?>
'

What am I missing here?

[biggupp]

anyone?