Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function CountyInstancesOver30($gallery=1) {
- global $wpdb;
- $sql = "SELECT County, COUNT(County) AS Incident FROM tblSpeedData WHERE Speed > 30";
- $result = $wpdb->get_results($sql);
- if( $result ) {
- $output = "<table>\n";
- foreach ($result as $pic)
- {
- $output .= "<tr><td>County: " . $pic->County . "</td><td>Incidents: " . $pic->Incident . "</td></tr>\n";
- }
- $output .= "</table>\n";
- }
- return $output;
- }
- add_shortcode('CInstO30', 'CountyInstancesOver30');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement