[macj1326]

You know how some sites have page ids for there news and articles and stuff? Well, I want to know how to do that for one of my news articles so that I don't have to make a new page for each news article. You know, like whatever.php?article=230 and it will go to the news article 230.

[Ryan]

There are several ways of doing this. Are you using a database to pull the articles from?

[macj1326]

That's what I'd like to do. How do I do this?

[Ryan]

If you're using a database you'll need to write a script that stores the articles in the database and then calls them out. I'll write something up and post it a little later.

[gizmoitus]

Whenever I see these types of questions, the first thing I can think to say is: you need to learn something about relational database design, and of course the language to manipulate them which is SQL.

A news app is fairly simple in the way you describe it, and would make for a good learning project. Browse the phpfreaks.com tutorials, they might have a how-to on that.

[Stefan]

I second gizmoitus' words. a news script is a very basic script, and is a good way of learning how to do things. besides phpfreaks.com, there are so many other sites outthere that offer tutorials on how to do this. go read em and try it yourself. if you have specific problems, ask questions about that but try to solve it yourself first. thats the best way of learning things.

[Ryan]

I'm sorry this took me so long to get back with you, been busy. Here's what I did and I've explained it along the way. This should work, but if you have any problems then let me know.

PHP Code:

<?php



// Connect to the database and select which database we want to use first.



$db = mysql_connect("server", "username", "password") or die(mysql_error());

mysql_select_db("dbname", $db) or die(mysql_error());



// Now we're going to make a query to the database to retrieve all the information we need.



$get = mysql_query("SELECT * FROM tbl_name") or die(mysql_error());



// Now we're going to create a loop that will display all the articles for you to choose from.

while($row = mysql_fetch_array($get))

{

    // Declare your variables in here

    $id = $row['ID'];

    $title = $row['title'];

    $article = $row['article'];

    

    echo("<a href='http://www.yoursite.com/articles.php?articleid=$id'>$title</a>");

}



if($_GET['articleid'] == $id)

{

     echo("<b>$title</b><br />");

     echo($article);

}

?>

Let me know how it works.

[macj1326]

I'm sorry to bother you anymore, but what tables should I create in mySQL? Im not too good with mySQL...

EDIT: Nevermind I got it working

[Ryan]

Glad to hear it. Let me know if you need anything else.

[macj1326]

Well, I've been tweaking it all morning and I can't seem to get it to stop displaying the link on the top of the page and on the bottom. Heres the code I have:

PHP Code:

<?php 



// Connect to the database and select which database we want to use first. 



$db = mysql_connect("localhost", "sn", "pw") or die(mysql_error()); 

mysql_select_db("db", $db) or die(mysql_error()); 



// Now we're going to make a query to the database to retrieve all the information we need. 



$get = mysql_query("SELECT * FROM article_news ORDER BY id DESC") or die(mysql_error()); 



// Now we're going to create a loop that will display all the articles for you to choose from. 

while($row = mysql_fetch_array($get)) 

{ 

// Declare your variables in here 

$id = $row['ID']; 

$date = $row['date']; 

$title = $row['title']; 

$article = $row['article']; 







if($_GET['article'] == $id) 

{ 

echo("<b>$title</b><br />");

echo("<b>Posted on:</b> $date<br /><br />"); 

echo($article); 

echo("<br><br><br><hr width=\"55%\" align=left><b><u>Other news articles:</u></b><br>");

} 

echo("<a href='http://www.gameraddictions.net/news.php?article=$id'><b>$title</b></a> posted on $date<br>"); 

} 

?>

The example of what I'm talking about is http://www.gameraddictions.net/news.php?article=2 ... If I go to the news feed about Tomb Raider then the link to the other one doesn't show up so why does it on this page? How can I stop this? I need it to look like http://www.gameraddictions.net/news.php?article=3 ..... all links on the bottom...