errors in my script

conehead

<?php

$url = "/forum"; // If url is - http://www.yourforums.com/forums , then enter in "/forums"
$ppath = "/home/conehead/public_html/forum/config.php"; // Physical path to the config.php file
if(empty($count))
$count = "5"; // How many topics to link to

include_once("$ppath");
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection");
@mysql_select_db("$dbname",$db) or die("here we die");

$prefix = "$table_prefix";

$query="SELECT * FROM phpbb_topics ORDER BY topic_id DESC LIMIT 0 , 5
$result= mysql_query($query) or die('Error: '.mysql_error());
while ($row = mysql_fetch_array ( $result )) {
$topicid = $row[topic_id];
$title = $row[topic_title];
$forumid = $row[forum_id];
$replies = $row[topic_replies];

echo "<a title=\"$title\" href=\"$url/viewtopic.php?t=$topicid&sid=$forumid\">$title</a> (<i>$replies</i><br>";

}

?>

when i run it i get

Parse error: parse error, unexpected T_STRING in /home/conehead/public_html/recent.php on line 22

then thinking it is the echo line i remove it, and i get unexpected $ on the last line.

Can anyone help, Thanx
😕

move3rd

change:

$query="SELECT * FROM phpbb_topics ORDER BY `topic_id` DESC LIMIT 0 , 5

$query="SELECT * FROM phpbb_topics ORDER BY `topic_id` DESC LIMIT 0 , 5";

conehead

wow thank you i knew i was missing something obvious

move3rd

If you use an editor with highlighting it's allot easier to spot things like this.

conehead

i have dreamweaver does that highlight

Weedpacket

Originally posted by conehead
i have dreamweaver does that highlight

You should know, you have Dreamweaver.
/Me guesses at where the punctuation is supposed to go.

conehead

yes , it does. 🙂

anyway i finally got it to work with your help, but it does not do what i want. What i want it to display is the last 5 topics posted. However instead, it displays the last 5 topics created. Does anybody know how to get it to display what i want? it is for phpbb, btw.

Weedpacket

Originally posted by conehead
What i want it to display is the last 5 topics posted. However instead, it displays the last 5 topics created. Does anybody know how to get it to display what i want?

So, you'll need to order by post date; you can order by several fields at the same time (I forget which order you'll write them in: ORDER BY date,topic_id or vice versa).

conehead

okay here is a liitle more information, The topics are ordered in creation order; however the posts hold the forum id number and are in order of last posted.

i know i need another query. i think you have to query the posts first and put them in latest post order, than store their forum numbers and query the forums table and display the matching forum numbers.

can that be done?