Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Blocks
Author Message
mds
Client



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

PostPosted: Tue May 16, 2006 6:11 pm Reply with quote

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 [ Only registered users can see links on this board! Get registered or login! ]

Ive tried the tutorial from [ Only registered users can see links on this board! Get registered or login! ]

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
-- [ Only registered users can see links on this board! Get registered or login! ]
--
-- 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', '', '', '', '', '', '', '');
 
View user's profile Send private message
mds







PostPosted: Wed May 17, 2006 9:09 pm Reply with quote

hmmmmm 29 views and not even a comment Question
 
montego
Site Admin



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona

PostPosted: Fri May 19, 2006 6:15 am Reply with quote

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.

_________________
Where Do YOU Stand?
HTML Newsletter::ShortLinks::Mailer::Downloads and more... 
View user's profile Send private message Visit poster's website
mds







PostPosted: Sun May 21, 2006 6:32 pm Reply with quote

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
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Blocks

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©