Displaying CMS info

[emvy03]

Hi guys,

I've been experimenting with a CMS, and have learnt quite a bit on how to script one. But what I want to do now is write the script so that in the index page, only the title is displayed but then when you click on the title it links you to the whole article. Is there a way to do this.

 

function get_content($id = '') {

 

if($id !=""):

 

 

$id = mysql_real_escape_string($id);

$sql = "SELECT * FROM ppyfc_content WHERE id= '$id'";

$return = '<p><a href="index.php">Go back to Content</a></p>';

else:

$sql = "SELECT * FROM ppyfc_content ORDER BY id DESC";

endif;

 

$res = mysql_query($sql) or die(mysql_error());

 

if(mysql_num_rows($res) !=0):

while($row = mysql_fetch_assoc($res)){

 

echo '<h1><a href="index.php?id=' . $row['id'] . '">' . $row['title'] . '</a></h1>';

echo '<div id="result">' . $row['home'] . ' ' . $row['score'] . ' ' .  $row['away'] . '</div>';

echo '<div id="result">' . $row['home1'] . ' ' . $row['score1'] . ' ' . $row['away1'] . '</div>';

 

}

 

This is the code to get and display the content from the database atm.

 

Thanks lads/lasses.