[SOLVED] template help

[gevo12321]

Im new to php, plz help

 

ok so i have a database with 5 columns

 

and a lot of rows

 

i want to make a web page for each row with the same template

 

is there a way to automatically do this or do i have to make each page ?

 

thank you

[chigley]

Not very hard, are you sure you want to physically create the files though? What's it for?.. there may be an easier option

[gevo12321]

well i want to have a link to each file on the site

 

its news articles

 

it pretty much has a title and the date and the news

 

so i dont know

 

whats the easiest and most efficient way of doing this?

 

[chigley]

Personally I'd have a global read news page, which is accessed with get variables:

 

eg. readnews.php?id=1

 

Where that script then reads from the database where id = 1. You could also use .htaccess to make it like /readnews/1 or something

[gevo12321]

ok so i have a list of the articles and dates in this code:

<?php
require_once('connect.php');
$query=mysql_query("SELECT date,title FROM news ORDER BY date desc") or die(mysql_error());
while($row=mysql_fetch_object($query))
{
$date1=$row->date;
$title=$row->title;
$date=date('m-d-Y',strtotime($date1));
echo $date;
echo " ";
echo $title;
echo "<br>";
}
?>

I want to have a link for each code to the corresponding article and all the articles use the same template

how do i do this?

[gevo12321]

bump