WordPress.org

1. kye172
   Member
   Posted 2 years ago #

   Created a separate table in the database called fts_groups, just trying to get all the data from it and can't get it working for the life of me, any ideas where I'm going wrong?

   function listspares() {
   
   	$q = "SELECT * FROM fts_groups";
   	$result = $wpdb->get_results($q);
   
   	if ($result) {
   
   		foreach ($result as $r) {
   
   			$GroupID = $r->GroupID;
   			$GroupThumb = $r->GroupThumb;
   			$GroupImage = $r->GroupImage;
   			$GroupName = $r->GroupName;
   
   		?>
   		<a href="<?php get_option('home');?>/wp-content/themes/ft/modals/grouppage.php?ID=<?php echo $GroupID;?>" id="inline" >
   			<img src="<?php get_option('home');?>/<?php echo $GroupThumb; ?>" />
   			<p><?php echo $GroupName; ?></p>
   		</a>
   		<?php
   
   		}
   
   	} else {
   		?>No Spares Found<?php
   	}
   
   }

   Thanks in advance,

   Kyle

2. kye172
   Member
   Posted 2 years ago #

   Resolved - didn't declare Global $wpdb beforehand!

Topic Closed

This topic has been closed to new replies.