Ranking Stories

[7724]

Hi Guys,

I have two tables - 'reports' and 'news'. Now on the frontpage of my site I want to be able to order these with either the newest created out of the two being put first on the page

or create some kind of ranking page, where it outputs the $heading variable from each 'report' id and 'news' id on a page and displays a text area box which I can then assign them an order:

ie:

heading (from 'reports' table) [ 1]
heading (from 'news' table) [ 2]

Any ideas?

Ta

[cheese]

Hi 7724,

I take it you are looking for something like this on the page that you are designing.

I did this by using the following;

<?php

//Connect to database

$sql_server = "localhost";
$sql_username = "username";
$sql_password = "password";
$sql_database = "database";
global $sql_server;
global $sql_username;
global $sql_password;
global $sql_database;
$link = mysql_connect($sql_server, $sql_username, $sql_password)
        or die("Could not connect : " . mysql_error());
    mysql_select_db($sql_database) or die("Could not select database");

//Run Query. Change LIMIT for number of entries needed - Date is a column in the news table

query = mysql_query("SELECT * FROM news ORDER BY Date DESC LIMIT 3 ");

//Starts the on screen table

print "<table class=noborder align=center>"; 

//Makes the rows of the on screen table

while ($row = mysql_fetch_array($query, MYSQL_NUM))

{ 

//Takes the first 150 chars from the text entry for display

$col7 = substr($row[6],0,150);

//Changes date from database format to UK format. 

$col2temp = $row[1]; 
$dbdateexplode=explode(' ',$col2temp);
$date=$dbdateexplode[0];
$dateexplode=explode('-',$date);

//Change this line to $col2new = $dateexplode[1]."/".$dateexplode[2]."/".$dateexplode[0]; for US format

$col2new = $dateexplode[2]."/".$dateexplode[1]."/".$dateexplode[0];

print "<tr><td>";
print $row[5];
print "</td><td align=right>";
print $col2new;
print "</td></tr>";
print "<tr><td colspan=2 class=news>";
print $col7;
print "....<a class=news href=morenews.php?newsitem=";
print $row[0];
print ">More</a>";
print "</td></tr>";
print "<tr><td colspan=2>";
print "&nbsp";
print "</td></tr>";

}

//Closes table

print "</table>";

?>

Cheers,

Neil.

[7724]

Hi,

Yep, kinda when i'm displaying on my front screen, but I want to create something where stories from the ‘reports’ and ‘news’ are outputted, so I can change the order I want them to appear on my frontpage.

Something like this, but not sure how I’d go bout doing it…

Ta

[7724]

Oh and out of interest if you don't mind me asking, how did you go about creating a league table?

[cheese]

How about using a rank column and put in it's position number and the use something like

query = mysql_query("SELECT * FROM news ORDER BY RankingColum ASC LIMIT 3 ");

This would give you your top 3 chosen stories.

Cheers,

Neil.

PS No I don't mind you asking........ boy did it take some doing, especially as we have split home and away, taking it from a table that includes all results - not just League games, but cup as well.

N.