Turning Data into URLs?

Posted on 16th Feb 2014 07:03 pm by admin

This may seem very basic to you, but I'm having a hard time figuring out how to do this since I don't even know what the proper term for it is:

Background info:
Animals Table - animalid, name, photo, achievementname, price, resale, levelid, description
Achievement Table - achievementid, achievementname, photo, xprequired, rewardname, description
Levels Table - levelsid, name, xprequired, description
Rewards Table - rewardid, rewardname, desciption

What I want to do is have my animals.php page pull up the MySQL Animals Table (already done) and have all the animal's achievementsid values link to a new page detailing that specific achievement (achievement.php). In turn, that achievement page would show the rewardid value that would link to a page detailing that specific reward (reward.php)

Example:
Animals.php shows a table with:
1-Horse--horse.png-Yee Haw!-1,000$-250$-1-A horse is a horse of course!

I want Yee Haw! to display as a link that would open up a php page that would show information relating to that specific achievement, ignoring all other achievements.

This would work in the same vein as this website: http://farmville.aweblog.net/almanac/animals/all-animals

I assume in being correct that I would have to call the result of that value into a variable that would be passed on as a cookie to another php file but I have not idea where or how to start on that.

My loop looks like this (shortened due to repetition):
while($row = mysql_fetch_array($result)){
echo "<tr>";
echo "<td>" .$row['idAnimal']. "</td>";
echo "<td><img src='".$url.$row['photoAnimal']."' height='50px' width='50px'></td>";
echo "<td>" .$row['nameAnimal']. "</td>";
echo "<td>" .$row['nameCategory']. "</td>";
echo "</tr>";
}


Assuming I wanted each animal name to link to a detailed animal page, what would I do? Can anyone give me some pointers or point me to a good resource for this kind of information? Googling is pointless as I don't know what terms I should be using...
Thanks

Your Answer:

Login to answer

Other forums

CURL XML Request [From C to PHP]
Hi,

I need some help converting this into something that will work with PHP.

Code: #

Parse Error Help
Hello, I got the parse error "Parse error: syntax error, unexpected ',' in register.php on line

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

All possible combinations of Strings from table in PL/SQL
Hi,

I am trying to figure out how to build a list of all possible string combinations fro

Hit counter updating once per IP - IP HIT COUNTER
I have a hit counter, for the amount of views on a tutorial.
It'll do the query and then do..

mysqli_fetch_assoc returns multiple arrays, how to return a single array
Hello, I am using mysqli_fetch_assoc which is returning multiple rows, so it looks like:

Code

captcha error
I have been trying to implement a captcha in php...

here is the code..
Code: (php) [Select

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

Printing issues with xMII 11.5
For some reason, we have one report (and only one) that is giving us fits when trying to print. The

Add 5 to a variable when a button is clicked, and re-run a for loop
So I'm making a feedback sort of section on a website with MySQL and PHP, I've gotten the script to