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

Cloud Computing?
Hello,

I was wondering if anyone could help explain this term to me. I'm starting to hear it

redirect standard error and assert (how to?)
How do you redirect standard error and assert?

---

(Why? I am creating an web app and

Displaying pictures
i have worked my way through storing images in directory and storing the location in mySQL db.Now i

AutoChoosing a CSS file based on URL
Hey everyone,

I have a site that has multiple URLs and CSS files.

Based on the URL tha

listcube issue
Hi
I have a virtual cube ZREMOTE. I use Tcode "listcube" to retrieve contents. I use of the

sapgui f4 help last search
I know this has to be simople. One user (maybe more) does not have the "last search saved" from the

if statements problems
Hi. I'm trying to make a web form, but I kind of hit a dead end trying to figure out why it doesn't

Local file browser with php
Halo..

So this is what i want to create. I have a folder that i share and it has many movies.

keeps going back to index.html ???????
ok so i started making my site using mostly.html files now i have added a fair chunk of php. My inde

Fetching META TAGS through
Hello everybody
I want to fetch meta tags of a domain.
It will be done from following code of