Would this work?

[poker158149]

I'm trying to get the topics data table from my forum's MySQL database fed onto my website.

I went into the PhpMyAdmin and I changed the SQL code of the base to PHP and got this:

$sql = 'SELECT * FROM `forums_topics` LIMIT 0, 30 '; 

I don't know much about PHP, but I've seen it alot, so I took a guess at how to implement it into my site.
Here's what I did:

<?php 

$sql = 'SELECT * FROM `forums_topics` LIMIT 0, 30 '; 

?>

But whatever code that is in the section that I want the feed to be in has to be in between <li></li> tags, and I do not know how to put those into PHP, which is what I'm assuming is making the above code not work.

What happens is just a "." where the feed should be.

Does anyone know if this is the problem, and if so, how can I fix it?

[maneetpuri]

Hi,

The code you have added just constructs the query, after it you will have to execute it, get the result returned in an array and then run a while loop or foreach on this array to populate the <li>.

Hope this helps.

Cheers,

~Maneet

[CuppyTea]

This page should help you.

Check out the page example.

[poker158149]

Alright, I used the example on the page and edited everything I could find.
What do I have to put as my row? Because I think I'm getting my rows and columns mixed up. Because when I try to run this, it shows me this:

No rows found, nothing to print, so am exiting

Here is the code I'm currently using:

<?php

$conn = mysql_connect("localhost", "ashint_cn", "********");

if (!$conn) {
    echo "Unable to connect to DB: " . mysql_error();
    exit;
}
  
if (!mysql_select_db("ashint_forums")) {
    echo "Unable to select mydbname: " . mysql_error();
    exit;
}

$sql = "SELECT title as title 
        FROM   forums_topics
        WHERE  title = 1";

$result = mysql_query($sql);

if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print, so am exiting";
    exit;
}

// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
//       then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
    echo $row["title"];
}

mysql_free_result($result);

?>

Please note, my password is not actually 8 stars.

[criterion9]

Do you have any data in the database to query?

[poker158149]

Yes, I'm trying to query my recent topics posted and there are 4 topics in the database. I'm thinking I'm just putting the wrong queries in the code

[welsh]

most likely the problem is your query, so try changing it to:

$sql = "SELECT * FROM forums_topics ORDER BY insert_here DESC LIMIT 4"; 

change the "insert_here" in the query to something like an id for the table or a date so it will pull the most 4 more recent from the table.

[poker158149]

Wow, that actually worked. Thanks alot!
Now the only problem is it comes out like this:

Windows 7Snow Leopard is here!Instant Messaging....Advertising Video

While it should actually show like this:

Windows 7
Snow Leopard is here!
Instant Messaging....
Advertising Video

[criterion9]

change this:

echo $row["title"]; 

to:

echo $row["title"]."<br />"; 

[poker158149]

Ah, thank you again!

Now, another problem. How can I link them to the actual post?

[welsh]

echo $row["title"]."<br />"; 

to

echo '<a href="link.php">' . $row['title'] . '</a><br />' 

is the default thing, however im not sure what the url up top shows as, im guessing it would be like yourwebsite.com/forum/showthread.php?t=1234 so then assuming t is like the column id then it would be:

echo '<a href="yourwebsite.com/forum/showthread.php?t=' . $row['id'] . '">' . $row['title'] . '</a><br />' 

[poker158149]

You are a god. Thank you so much!