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

Redirect not working after making a POST/GET
Hi Everyone,

I am a novice in PHP. Here I have 2 pages, one page with a textbox and button an

output printing as hexadecmal... XD
Everything works except the calcem call for the totusold and totuprice. The out put shows up as hex.

Login script (probably a simple error)
dbConfig.php
Code: <?
// Replace the variable values below
// with your specific dat

[newb] Image hosting help.
Hey there, I'm new to php, I know some basics and i can code PWN, I'm only 14 but I'm interested in

Bit manipulation program with binary operations
My homework is to create a program to scan in and add binary numbers and print them like so

Else statement screws up all css
Does anyone know what goes wrong in the process with this php code?
This code seems to be causing

problem with script manager
Hi iam using Net.2005.I have created ajax enabledwebsite.i have master page in which i have script m

duplicate record notification
In my database, after insertion of records, I want to know if the record inserted is duplicate or no

File upload issues
Hi Guys,

Can anyone see any issues with this code:
Code: [Select]$setImage= 'productimages

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my