custom block

Client Joined: Dec 24, 2004 Posts: 194 Location: Michigan

trying to create a block that will display info from eventually 3 different DB tables that will contain same fields but are located in same DB as the rest of the sites tables . The block must take the info from the 3 tables with the same field names and display a total .....I am lost im working on trying to get info from 1 table to display and nothing is working this far HELPPPPP Wink

ive searched here ( i am sure i seen this covered somewhere but can't find it) includeing the Nuke How To----->create block http://www.ravenphpscripts.com/nukemanual-modifying-php-nuke-blocks.html

Ive tried the tutorial from http://dev.mysql.com/doc/refman/4.1/en/selecting-all.html

Ive tried using info from other blocks that work and edit the info to end up with "There isn't content right now for this block." which ive searched for as well or i lose all other blocks plus the right side blocks...

the table im working with now which i would like to get working first then continue on to add and include into the block here is the dump file..

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 16, 2006 at 05:02 PM
-- Server version: 4.0.18
-- PHP Version: 4.4.1
--
-- Database: `xxxxxxxxx`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_Xxxxx_Township`
--

CREATE TABLE `nuke_Xxxxx_Township` (
`id` int(10) unsigned NOT NULL auto_increment,
`Fires` text NOT NULL,
`EMS_and_Rescue` text NOT NULL,
`Hazardous_Condition` text NOT NULL,
`Service_Calls` text NOT NULL,
`Good_Intent` text NOT NULL,
`False_Calls` text NOT NULL,
`Servere_Weather` text NOT NULL,
`blank` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id_2` (`id`),
KEY `id` (`id`)
) TYPE=MyISAM COMMENT='Created by phpFormGenerator' AUTO_INCREMENT=4 ;

--
-- Dumping data for table `nuke_Xxxxx_Township`
--

INSERT INTO `nuke_Xxxxx_Township` VALUES (1, '0', '22', '5', '0', '4', '1', '0', '');
INSERT INTO `nuke_Xxxxx_Township` VALUES (2, '22', '', '', '', '', '', '', '');
INSERT INTO `nuke_Xxxxx_Township` VALUES (3, '40', '', '', '', '', '', '', '');

Posted: Wed May 17, 2006 9:09 pm

hmmmmm 29 views and not even a comment Question

registered · Posted: Fri May 19, 2006 6:15 am

I would suggest posting the code that you have so far (please use the code BBcode tags on it) so that we can try to help you with the first one.

Posted: Sun May 21, 2006 6:32 pm

ive tried
1) mysql] SELECT * FROM nuke_Xxxxx_Township;
2)
[?php
mysql] SELECT * FROM nuke_Xxxxx_Township;

?]
3]
$result = $db-]sql_query["SELECT fieldnamesfromabovedumpseperatedwithcommas FROM ".$prefix."Xxxxx_Township"];

4] same as above but with [?php ?]

5) [?php

if [ !defined['BLOCK_FILE'] ] {
Header["Location: ../index.php"];
die[];
}

$result = $db->sql_query["SELECT fieldnamesfromabovedumpseperatedwithcommas FROM ".$prefix."Xxxxx_Township"];

?]

im sure theres a couple i missed as well and to be honest i really have no idea how to start from scratch tho i thought if i took a block and edited it i would be able to get it to work however guess this is not the case in this instance for me thanks for any and all help