Links Page?

webmasternovis

Hi there,

Yesterday I posted a thread asking what PHP URL'S such as 'example.php?eg=50' were. Now I need to use these, but need a little bit of help with MySQL...

I want to display a links page which links to a site by:

redirect.php?linkid=number

I would find it easy if I wanted to just place the links in any old order, as I would just add them without no PHP. However, I do want to put them in a 'popularity' order, where I have a MySQL row called 'popularity' which calculates how many times the link has been clicked on.

I know how to actually put them in order, but I wouldn't know how to get the linkid using MySQL.

Would anyone please help me?

Thanks a lot,
Mike🙂

barand

Assuming you have a table that contains

| linkid | popularity | linktitle |

fields, The you need to select the fields and order them by descending popularity so you get the most popular first.

$sql = "SELECT linkid, linktitle, popularity FROM atable ORDER BY
popularity DESC";

$result = mysql_query ($sql);
while (list($id, $title, $pop) = mysql_fetch_row($result)) {
echo "<a href=\"redirect.php?linkid=$id\">$title</a><br>";
}

hth

webmasternovis

Hi barand,

I understood nearly everything up until that while loop. Please could you explain?

Thanks a lot,
Mike

barand

The while loop will process each of the returned rows one at a time so you can echo each link.

The list() just gets the selected fields and puts them into 3 variables. $id, $title and $pop.

You could just use while($row = mysql_fetch_row($result)) and refer to the fields as $row[0], $row[1] and $row[2] buts thats not very readable.

Alternatively while ($row = mysql_fetch_array($result)) and use $row['linkid'] etc. This more readable but I find it a bit awkward (and more typing) when putting into an echo because of all the quotes.

Thats why I use the list() option.

hth

webmasternovis

I get it now, thanks🙂