[RESOLVED] Making results of a query into a link

alasxdair

Okay, I have done quite a bit of searching and haven't quite found what I am looking for. I am just starting out with php/mysql.

Basically, I am trying to put together a poker page for my local game. What I am trying to accomplish is being able to upload tournament results into a tournaments database and have player cards and tournament pages automatically update.

This is what I have so far. I have a database called 'tournaments' with the tables Date, Position, Name, and Won. Now, I have created a tournaments page where all I want to display is the date of each tournament. I have figured out how to select the distinct dates. What I need to do now is make those dates into a link. The link would display the tournament results for the date they clicked.

Hope I made sense and that my intentions are clear. This is what I have so far:

$query = mysql_query("SELECT DISTINCT date FROM tournaments ORDER BY date DESC");
while($row = mysql_fetch_array($query))
{
	$date = $row['date'];
		echo "<center> $date </center><br/>";	
}

ucffool

In a simple way, you could have your link be something like:

$urldate = urlencode($date); // convert the date to something compatible for GET
echo "<a href='showdate.php?date=$urldate'>$date</a>";

Then, the showdate.php page would check the $GET['date'] variable,

$date = urldecode($_GET['date'];

Then get the needed info from the database: SELECT * FROM tournaments WHERE date='$date'

laserlight

You would not need to use urldecode() since the value of $_GET['date'] would be in urldecoded form.

ucffool

laserlight wrote:
You would not need to use urldecode() since the value of $_GET['date'] would be in urldecoded form.

You're right, my mistake. Luckily, it wouldn't hurt anything.

laserlight

Luckily, it wouldn't hurt anything.

Unless the data itself contains a urlencoded string, but that would be rather strange for a date 🙂

alasxdair

I got it, thanks!! I am sure I will have more questions as I go along, but this was a great help. Thanks a ton.

laserlight

Remember to mark this thread as resolved (if it is) using the thread tools.