Ask VetsFirst

Ask VetsFirst is an exciting new Web-based service. This ground-breaking service will avail large numbers of veterans of an opportunity to get assistance with benefits-related inquiries quickly and efficiently.
Click here to Ask VetsFirst

Front & Center Click Here To View All Posts & Articles
// Connect to DB
@$conn = mysql_connect('localhost', DB_USER, DB_PASSWORD);
@mysql_select_db('devus');

// Create temp table
@mysql_query("CREATE TEMPORARY TABLE posts_tmp (theDate DATETIME, theExcerpt text, theID bigint, theLink text)");

// Vetsfirst news
@mysql_query("
INSERT INTO posts_tmp
SELECT wposts.post_date, wposts.post_excerpt, wposts.ID, CONCAT('http://www.vetsfirst.org/?p=', wposts.ID)
FROM wp_vetsfirst_posts wposts INNER JOIN wp_vetsfirst_term_relationships wterms ON wposts.ID=wterms.object_id
WHERE
wposts.post_status = 'publish'
AND wposts.post_type = 'post'");

// Get 3 latest articles in either United Newsroom or VetsFirst "united news" category
@$post_res = mysql_query("SELECT DISTINCT *, DATE_FORMAT(theDate, '%M %D, %Y') as theDateFormatted FROM posts_tmp ORDER BY theDate DESC LIMIT 3");

while( @$aPost = mysql_fetch_array($post_res) ) {
echo '

‘;
echo ‘
‘.$aPost[‘theDateFormatted’].’

‘;
echo ‘

‘.$aPost[‘theExcerpt’].’
Full Story

‘;
echo ‘

‘;
echo ‘

‘;
}
?>