I posted my database problems still need help

[djraver]

I posted in my other thread my problems with fetch content. If anyone can help.

[bpat1434]

Help you with what? Incomplete sentences don't help. And just saying: I posted something somewhere else, but still need help is not good. How about a link to the thread?

~Brett

[djraver]

maybe not resolved HELP PLEASE
Ok this is what my data base looks like:

CREATE TABLE @bans (
id int(11) NOT NULL auto_increment,
host varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE @board_sections (
id int(11) NOT NULL auto_increment,
ref varchar(30) NOT NULL default '',
name varchar(30) NOT NULL default '',
description varchar(200) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO @board_sections VALUES (3, 'general', 'General Board', 'The general layout which includes board header and footer');
INSERT INTO @board_sections VALUES (4, 'view_board', 'View Board', 'The main page of the board that displays all the forum listings');
INSERT INTO @board_sections VALUES (5, 'thread_list', 'Thread List', 'The page that shows the listing of threads for a particular forum.');
INSERT INTO @board_sections VALUES (7, 'post_list', 'Post List', 'The area where the list of posts inside a thread is shown');
INSERT INTO @board_sections VALUES (8, 'register', 'Register', 'Where guests can register their own username');
INSERT INTO @board_sections VALUES (9, 'error', 'Errors', 'The software errors that occur');
INSERT INTO @board_sections VALUES (10, 'log_in', 'Log In', 'The log-in form');
INSERT INTO @board_sections VALUES (11, 'add_post', 'Add Post', 'Where you add a post to a thread or create a new thread');
INSERT INTO @board_sections VALUES (13, 'mem_ctl', 'Member control', 'Where the user can alter their profile');
INSERT INTO @board_sections VALUES (14, 'moderation', 'Moderation Features', 'Edit, delete, move threads etc.');
INSERT INTO @board_sections VALUES (15, 'messenger', 'Your Messenger', 'Private Messenger');
INSERT INTO @board_sections VALUES (16, 'view_profile', 'View Profile', 'Allows viewing of a members profile');
INSERT INTO @board_sections VALUES (17, 'communication', 'Communication', 'ICQ & AIM pagers');

CREATE TABLE @cat_masks (
id int(11) NOT NULL auto_increment,
cat int(11) NOT NULL default '0',
member_group int(11) default NULL,
permission_id int(11) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE @category (
id int(11) NOT NULL auto_increment,
name varchar(100) NOT NULL default '',
order_number int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE @emoticons (
id int(11) NOT NULL auto_increment,
keyword char(15) default NULL,
image char(15) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO @emoticons VALUES (1, '', 'smile.gif');
INSERT INTO @emoticons VALUES (2, '', 'sad.gif');
INSERT INTO @emoticons VALUES (13, '', 'rolleyes.gif');
INSERT INTO @emoticons VALUES (12, '😐', 'bored.gif');
INSERT INTO @emoticons VALUES (5, '', 'biggrin.gif');
INSERT INTO @emoticons VALUES (6, '', 'wink.gif');
INSERT INTO @emoticons VALUES (11, '😠', 'angry.gif');
INSERT INTO @emoticons VALUES (10, '', 'tongue.gif');
INSERT INTO @emoticons VALUES (9, '???', 'confused.gif');
INSERT INTO @emoticons VALUES (14, '', 'cool.gif');
INSERT INTO @emoticons VALUES (15, ':sleep:', 'sleeping.gif');
INSERT INTO @emoticons VALUES (16, '👍', 'thumbs-up.gif');
INSERT INTO @emoticons VALUES (17, ':dontgetit:', 'dontgetit.gif');
INSERT INTO @emoticons VALUES (18, ':hmmm:', 'hmmm.gif');
INSERT INTO @emoticons VALUES (19, '😆', 'satisfied.gif');
INSERT INTO @emoticons VALUES (20, ':dozingoff:', 'dozingoff.gif');

CREATE TABLE @forgotpass (
member_id int(11) NOT NULL default '0',
hash char(12) NOT NULL default '',
timestamp int(11) NOT NULL default '0',
PRIMARY KEY (member_id)
) TYPE=MyISAM;

CREATE TABLE @forum_masks (
id int(11) NOT NULL auto_increment,
forum int(11) NOT NULL default '0',
member_group int(11) default NULL,
permission_id int(11) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE @ (
id int(11) NOT NULL auto_increment,
name varchar(100) NOT NULL default '',
category_id int(11) NOT NULL default '0',
description varchar(100) NOT NULL default '',
order_number tinyint(4) NOT NULL default '0',
last_thread_id int(11) NOT NULL default '0',
last_member_isreg tinyint(4) NOT NULL default '0',
last_thread_name varchar(50) NOT NULL default '',
last_post_time int(10) NOT NULL default '0',
last_poster_id int(10) NOT NULL default '0',
last_poster_name varchar(20) default NULL,
post_count int(11) NOT NULL default '0',
thread_count int(11) NOT NULL default '0',
named_moderators varchar(100) default NULL,
post_marker_prefix varchar(10) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE @language_pack (
id int(11) NOT NULL auto_increment,
name varchar(30) NOT NULL default '',
abbrev char(3) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE @language_sentence (
id int(11) NOT NULL auto_increment,
boardsection int(11) NOT NULL default '0',
language int(11) NOT NULL default '0',
name varchar(30) NOT NULL default '',
text varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO @language_sentence VALUES (1, 3, 1, 'welcome_to_forums', 'Welcome to PHP TB forums');
INSERT INTO @language_sentence VALUES (2, 3, 1, 'please', 'please');
INSERT INTO @language_sentence VALUES (3, 3, 1, 'login', 'login');
INSERT INTO @language_sentence VALUES (4, 3, 1, 'or', 'or');
INSERT INTO @language_sentence VALUES (5, 3, 1, 'register', 'register');
INSERT INTO @language_sentence VALUES (6, 3, 1, 'login_details', 'Login Details');
INSERT INTO @language_sentence VALUES (33, 3, 1, 'nav_separator', ' » ');
INSERT INTO @language_sentence VALUES (9, 4, 1, 'forum', 'Forum');
INSERT INTO @language_sentence VALUES (10, 4, 1, 'threads', 'Threads');
INSERT INTO @language_sentence VALUES (11, 4, 1, 'posts', 'Posts');
INSERT INTO @language_sentence VALUES (12, 4, 1, 'last_post_info', 'Last Post Info');
INSERT INTO @language_sentence VALUES (20, 3, 1, 'log_out', 'Log Out');
INSERT INTO @language_sentence VALUES (13, 5, 1, 'thread_name', 'Thread Name');
INSERT INTO @language_sentence VALUES (14, 5, 1, 'thread_starter', 'Thread Starter');
INSERT INTO @language_sentence VALUES (15, 5, 1, 'replies', 'Replies');
INSERT INTO @language_sentence VALUES (16, 5, 1, 'views', 'Views');
INSERT INTO @language_sentence VALUES (17, 5, 1, 'last_action', 'Last Action');
INSERT INTO @language_sentence VALUES (18, 3, 1, 'or', 'or');
INSERT INTO @language_sentence VALUES (19, 3, 1, 'control_panel', 'Control Panel');
INSERT INTO @language_sentence VALUES (21, 8, 1, 'register', 'Register');
INSERT INTO @language_sentence VALUES (22, 8, 1, 'email_address', 'E-mail address');
INSERT INTO @language_sentence VALUES (23, 8, 1, 'please_enter_email', 'Please enter your e-mail address');
INSERT INTO @language_sentence VALUES (24, 8, 1, 'confirm_password', 'Confirm Password');
INSERT INTO @language_sentence VALUES (25, 8, 1, 'please_reenter', 'Please re-enter the password');
INSERT INTO @language_sentence VALUES (26, 8, 1, 'password', 'Password');
INSERT INTO @language_sentence VALUES (27, 8, 1, 'password_length', 'Passwords must be between 6 and 20 characters long');
INSERT INTO @language_sentence VALUES (28, 8, 1, 'member_name', 'Member Name');
INSERT INTO @language_sentence VALUES (29, 8, 1, 'main_identity', 'This will be your unique identity on the board');
INSERT INTO @language_sentence VALUES (30, 8, 1, 'please_fill_in_details', 'Please fill in all details of the form fully');
INSERT INTO @language_sentence VALUES (34, 9, 1, 'back', 'click here to go back');
INSERT INTO @language_sentence VALUES (35, 10, 1, 'member_name', 'Member Name');
INSERT INTO @language_sentence VALUES (32, 8, 1, 'agree_to_terms', 'By clicking 'Register' you agree to the terms stated below');
INSERT INTO @language_sentence VALUES (36, 10, 1, 'password', 'Password');
INSERT INTO @language_sentence VALUES (37, 10, 1, 'log_in', 'Log In');
INSERT INTO @language_sentence VALUES (38, 11, 1, 'insert_emoticon', 'Click to insert emoticon');
INSERT INTO @language_sentence VALUES (39, 11, 1, 'post_text', 'Post Text');
INSERT INTO @language_sentence VALUES (40, 11, 1, 'add_post', 'Add Post');
INSERT INTO @language_sentence VALUES (41, 11, 1, 'fonsize_msg', 'Please enter a font size between 1 and 10');
INSERT INTO @language_sentence VALUES (42, 11, 1, 'enter_fontface', 'Please enter the name of the font face');
INSERT INTO @language_sentence VALUES (43, 11, 1, 'enter_fontcolor', 'Please enter the color of the font');
INSERT INTO @language_sentence VALUES (44, 11, 1, 'enter_validlink', 'Please enter a valid link (make sure you include the [url]http://[/url])');
INSERT INTO @language_sentence VALUES (45, 11, 1, 'enter_validimg', 'Please enter the full url to a valid image (include the [url]http://[/url])');
INSERT INTO @language_sentence VALUES (46, 11, 1, 'formatting_options', 'Formatting Options');
INSERT INTO @language_sentence VALUES (47, 11, 1, 'close_tag', 'close tag');
INSERT INTO @language_sentence VALUES (48, 11, 1, 'open_tag', 'open tag');
INSERT INTO @language_sentence VALUES (49, 11, 1, 'insert', 'insert');
INSERT INTO @language_sentence VALUES (50, 11, 1, 'title', 'Title');
INSERT INTO @language_sentence VALUES (51, 11, 1, 'description', 'Description');
INSERT INTO @language_sentence VALUES (52, 11, 1, 'post_text', 'Post Text');
INSERT INTO @language_sentence VALUES (53, 11, 1, 'create_thread', 'Create Thread');
That is part of the data base that i am getting the values from but i am having trouble with your example and adding them
this is my database info i am trying to add a fetch all to last five topics and authors to my home page from my forum and can't get it to work.

[bretticus]

ummm....who's example are you having trouble implementing??? Were you going to post PHP code instead of just the dump of your table structures and data?

[djraver]

We don't know what your message board forum is, so how are we to know what the database schema looks like? Put yourself in our shoes. If you don't supply us with enough information, how can we help you?

Let's talk in general here. I won't solve your problem specifically and get into too much detail. Its up to you to learn HOW to do it, rather than being given the answer.

In general, you should have a database table (lets call it TABLE_MESSAGES). In it, it should have something like this as a schema:

TABLE_MESSAGES
msgId
postTime
author
message

You would create a script file that is designed to be include/require into a table cell. This is important for layout design. Let's call this file, LastPosts.php.

Somewhere on your website layout, you want to place this script to output the last N posts:

Index.php

<?php require_once("LastPosts.php"); ?>

<html>
<head><title>Main Page</title></head>
<body>
<table>
<tr><td>
<?php
$lastPosts = new LastPosts();
$lastPosts->GetPosts(5);
$lastPosts->Show();
?>
</td></tr>
</body>
</html>

LastPosts.php

NOTE: THIS IS PSEUDO CODE AND IS NOT COMPLETE. IT IS MEANT TO GIVE YOU AN IDEA OF HOW TO SOLVE YOUR PROBLEM. IT CONTAINS NO ERROR CHECKING.

<?php

class LastPosts
{
var $msgInfo;

function LastPosts()
{
$this->msgInfo = array();
}

function GetPosts($num)
{
if ($num <= 0)
return;

database_connect("blah");
database_select("blah");

// Sort messages by latest time and fetch up to $num records

$sql = SELECT PostTime, Author, Message from TABLE_MESSAGES LIMIT 0, " . $num-1 . "ORDER BY postTime DESC";

$result = database_query($sql);
$numRows = database _getNumRows();

// note that the number of records
// may be LESS than the number you requested

// iterate, stuffing the array
for ($i=0; $i < $numRows; ++i)
{
// stuff the msgInfo array here
$this->msgInfo["PostTime"] = $result[0];
$this->msgInfo["Author"] = $result[1];
$this->msgInfo["Message"] = $result[2];
}

database_close();
}

function Show()
{
// just general iteration
// you would of course present the information whatever way you want
for ($i=0; $i < count($this->msgInfo); ++i)
echo $this->msgInfo["PostTime"] . "<br />;
echo $this->msgInfo["Author"] . "<br />;
echo $this->msgInfo["Message"] . "<br />;

}
}

?>
this is the example to use but i can't find the right tables to show the last post the user and the thread from my database

[kkobashi]

Why are you plageurizing my solution and pasting it in another new thread? I posted that as a response to you and put A LOT of time into that to help you solve your problem.

You should have kept responding in the same message thread, instead of trying to start yet another one here.

Do you realize, that if I didn't read this thread, I would never have even been able to respond to your request on what MY CODE DOES? Don't you think its smarter to keep asking the guy who posted his own code, what it does?

Look, I can't possibly type in the entire solution to your problem with the amount of time I have. Hell, what I typed in is MORE THAN what most would take the time to do. What you got was PSUEDO code to THINK FOR YOURSELF and SOLVE THE PROBLEM FOR YOURSELF.

Sir, today I must have answered 20-30 problems. Some of these are quick, some are them are more involved. Yours falls in the category of "taking too much of my time".

I can only juggle only so many questions at a time and try my best to solve them . But realize, I do have a life and am busy.

Instead of always giving people the answer to their questions, it is often best to make YOU THINK. This is why I gave you psuedo code. Whether you realize it or not, programming is about problem solving. You will never be a great programmer if someone always hands you the answer.

Let's get real here. Judging by your question and the problem itself, this is not a very difficult one. It tells me you are lacking the basics.

If you don't understand the pseudo code and cannot write code to fill in the logic, then I'm afraid you really need to take a course on PHP, get a hold of a beginner's book and read through it because it doesn't get any more simpler than that.

Sorry, but if you would have stuck to posting your message in the same thread I would be more obliged to help you. You just don't do what you did here - that is not proper etiquette.