Slicker solution?

[thriftyspider]

Hi, I am building a small website for a snooker club. I have one ASP page that displays historic data, (tournament results etc) grouped in categories and contained in a DIV. The problem I have is that my customer wants to be able to view by category, i.e click on a category and only see that category displayed in the results. Would I have to provide a new page for each category where the SQL is hard coded or is there a slicker solution I can employ?

[c010depunkk]

No, you could do it dynamically with PHP.

Here's some untested pseudo code:

The SQL table has, for example, three columns - one | two | three
HTML:

Code: Select all

<a href="?sort_key=one">one</a>
<a href="?sort_key=two">two</a>
<a href="?sort_key=three">three</a>

PHP:

PHP: Select all

// mysql query
$query=mysql_query("SELECT * FROM tablename SORT BY ".$_GET['sort_key']." ASC");
while($row=mysql_fetch_object($query)) {
  echo("<p>".$row->one." | ".$row->two." | ".$row->three."</p>");
} 

Hope that helps.

[thriftyspider]

Thanks for that; although I haven't much of a clue how to use PHP or MySQL, I think I can follow your code. Maybe I can pass an argument to the code that creates the query and just reload the page. I really am going to have to get to grips with MySQL Thanks again

Rob