Slicker solution?

thriftyspider · #1 Aug 8th, 2007, 08:59

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 · #2 Aug 8th, 2007, 14:02

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 · #3 Aug 8th, 2007, 15:22

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop-down menu solution?	Sanehouse	Web Page Design	10	May 2nd, 2008 11:02
Need internet marketing solution?	hretlin	PHP Forum	1	Mar 8th, 2008 07:17
Help can't find solution	bcwups	Web Page Design	2	Nov 30th, 2007 18:50
Can't think of a solution!!	snowangel	PHP Forum	3	Mar 12th, 2006 21:20
New Member, looking for a web solution	timthompson	Job Opportunities	2	Feb 26th, 2006 07:36

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
Slicker solution?