Another problem.

[tomato_ketchup]

I am coding a message board script and have just started work on the template system.

function templates($templatename,$topicID)
{
    $template_query = mysql_query("SELECT name,html FROM templates WHERE (name='$templatename')");
    $template = mysql_fetch_array($template_query);
    $templatex=$template['html'];

$gettopic_query = mysql_query("SELECT TopicName FROM topics WHERE (ID=$topicID)");
$gettopic = mysql_fetch_array($gettopic_query);

$getpost_query = mysql_query("SELECT Name,Post FROM posts WHERE (TopicID='$topicID')");
while ($getpost = mysql_fetch_array($getpost_query)) {
$find_var=array("%topicname%", "%author%", "%postbody%");
$rplc_var=array("$gettopic[TopicName]","$getpost[Name]","$getpost[Post]");
}
    $new_template=str_replace($find_var,$rplc_var,$templatex);
    print $new_template;
}

function viewpost($topicID)
{
$topic_query = mysql_query("SELECT TopicName FROM topics WHERE (ID=$topicID)");
$topic = mysql_fetch_array($topic_query);

templates(viewthread_head_subject,$topicID);

$post_query = mysql_query("SELECT * FROM posts WHERE (TopicID='$topicID')");
while ($post = mysql_fetch_array($post_query)) {
templates(viewthread_post_body,$topicID);
}
templates(viewthread_post_foot,$topicID);
}

Those are my functions for the template system. and view post script.

My problem is that as you can see here: http://www.agent-penguin.net/penguinbb0.1/test/test.php?topicID=1

it only shows the last result in the mysql query.

I don't know how to get it to show EVERY result in order, instead of just the last 1.

[halojoy]

In
function viewpost($topicID)
I would expect here you input one post to display, instead of topic
But maybe I haven't understood it

also, you have only showe us 2 functions
not the 'test.php' page that calls these functions
so we really do not know what is happening

maybe it should be something like this ????

while ( $post = ...............){
templates(viewthread_post_body,$post);
}

shouldnt
viewthread_head_subject
be a variable:
$viewthread_head_subject

[tomato_ketchup]

None of that is neccessary. The functioins are called the same way they are called in the two functions. The templates functions that i am having trouble with are called in functions.php The problem is php is displaying ther last entry in mysql. and not both entries.

Not that my functions are being called incorrectly.

[halojoy]

Okay, I see.
hope somebody can help
🙂