Pulling data from forum (smf) to your site

sunrize

Im having some toruble with some coding. I have a website i made and i have a forum. I want to take certain boards from the forum and display it on my main page. I want the subject and the poster name so it looks like the following : Subject - Name of poster. Here is my coding

<?php

$dbh = mysql_connect("localhost","user","pass") or die (mysql_error());
$db = mysql_select_db("team_del_smf1");

$query = mysql_query("SELECT `ID_TOPIC` FROM `smf_topics` WHERE `ID_BOARD`='8' ORDER BY `ID_LAST_MSG` DESC LIMIT 8");
while(list($ID_TOPIC) = @mysql_fetch_array($query))
{
$query2 = mysql_query("SELECT `subject`, `posterName` FROM `smf_messages` WHERE `ID_TOPIC`='$ID_TOPIC'");
list($subject, $posterName) = @mysql_fetch_array($query2);

$scenenews .=<a href=\"/forums/index.php/topic,$ID_TOPIC.2.html\" class=\"Index_03\">$subject</a><br/>";
}



?>

I named this functions.php. Then in my index at very top i put

<?php
session_start();
include "./functions.php";

?>

Now in my codding u can see i put class="Index_03". SO in my index i made this

<div class="Index_03">
<?php include "functions.php"; ?>
</div>

i have no clue if this is right or not

dagon

sunrize;10916688 wrote:
i have no clue if this is right or not

If it works its right, if not tell us what happens as opposed to what you want to happen.

echo $scenenews;

would probably help.

sunrize

Ok this is what i did. I made a seperate file called functions and put tthe following code in it.

					<?php
	$dbh = mysql_connect("localhost","team_del_smf1","stanton2") or die (mysql_error());

$db = mysql_select_db("team_del_smf1");

$query = mysql_query("SELECT ID_TOPIC FROM smf_topics WHERE ID_BOARD='3' ORDER BY ID_LAST_MSG DESC LIMIT 8");
while(list($ID_TOPIC) = @mysql_fetch_array($query))
{
$query2 = mysql_query("SELECT subject, posterName FROM smf_messages WHERE ID_TOPIC='$ID_TOPIC'");
list($subject, $posterName) = @mysql_fetch_array($query2);

$scenenews .=<a href=\"/forums/index.php/topic,$ID_TOPIC.12.html\" class=\"Index_03\">$subject</a><br/>";
}

?>
I saved this a functions.php

Now, i went back to index.php and at the top i put the following:

<?php
session_start();
include "./functions.php";
?>

Now in my div in the index.php i put what you told me to put

<div id="name">
echo $scenenews
</div>

on my page i get this when its uploaded.

dagon

use the board php tags, paste the error, no need for screen shots, learn how to quote a string in php

$scenenews .='<a href="/forums/index.php/topic,$ID_TOPIC.2.html" class="Index_03">'.$subject.'</a><br/>';

onicsoft

Error codes are the best! What is php trying to tell you?

"No such file functions..php"

Check to see if you Double dotted the functions.php file in the index.php file?

syntax error, line 11, functions.php

Syntax error is a fancy way to say you mest up the proper formatting and here is what line php thinks it is mest up on and go check that line number. If we go check that line number we see this there.

$scenenews .=<a href="/forums/index.php/topic,$ID_TOPIC.2.html\" class=\"Index_03\">$subject</a><br/>";

and the error is the missing double quote at the start of it.

Side note this will output where you put it. So, you don't need it at the very top of the index.php page unless you want it to output before anything else is shown. You can put it where the <div class="Index_03"> is located.


<?php

  $dbh = mysql_connect("localhost", "team_del_smf1", "stanton2") or die(mysql_error());
  $db = mysql_select_db("team_del_smf1");


  $query = mysql_query("SELECT `ID_TOPIC` FROM `smf_topics` WHERE `ID_BOARD`= '3' ORDER BY `ID_LAST_MSG` DESC LIMIT 8");
  while (list($ID_TOPIC) = @mysql_fetch_array($query))
  {
      $query2 = mysql_query("SELECT `subject`, `posterName` FROM `smf_messages` WHERE `ID_TOPIC`='$ID_TOPIC' limit 1");
      list($subject, $posterName) = @mysql_fetch_array($query2);

  $scenenews .=  '<a href="/forums/index.php/topic,$ID_TOPIC.12.html" class="Index_03">'.$subject.'</a><br />';
  }

  echo $scenenews;
?>

On the other hand you did teach me something a bit nifty and i have to check out for speed. The list on the fetch command.

sunrize

ok thanks i fixsed that now im gettinig a problem with the database. i know my username and password is right. i get this error message.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'team_del_smf1'@'localhost' (using password: YES) in /home/teamdel/public_html/functions.php on line 4
Access denied for user 'team_del_smf1'@'localhost' (using password: YES)

so thi sis what i have in my functions.php

$con = mysql_connect("localhost", "team_del_smf1", "stanton2") or die(mysql_error());
$db = mysql_select_db("team_del_smf1");

somethign is wrong with my variables , in my cpanel it originally had $dbh = mysql etc.. so i went with that. but im not sure. i think i need if else statemnts to varify if the username and password is right.

sunrize

Ok this is what i did now.

i put $scenenews .='<a href="/forums/index.php/topic,$ID_TOPIC.2.html" class="Index_03">'.$subject.'</a><br/>'; inside my div and removed the php at the top of my index and adjusted the small changes that you made and it shows this inside my content box :

echo $scenenews .=''.$subject.'
';

the subject links to the main page of the forum not the specified board with the topic. it has /index.php/topic,$ID_TOPIC.2.html in the url field but its actually taking me to the index of the forum .