Simple database linking on a page

Lengkap Disiarkan Apr 5, 2012 Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

I think this would be easy for anyone knowledgeable with mysql/php.

I am having a problem getting links working on a page on my site. I have attached the file to the project. If you scroll down you will see $stmt = etc, this is where I'm pulling the data from.

The problem is the player link doesn't work as it needs to access a different table to get the id, as does the opposition part (also in a different table)

For players it needs to get the playerid from players table based off firstname and lastname

For opposition, the id is exactly the same as the one shown on the page, but in a different table.

HTML MySQL PHP Reka Bentuk Laman Web

ID Projek: #1547906

Tentang projek

7 cadangan Projek jarak jauh Aktif Apr 5, 2012

Dianugerahkan kepada:

sam45

hey, please see PM :)

$30 USD dalam sehari
(112 Ulasan)
6.4

7 pekerja bebas membida secara purata $33 untuk pekerjaan ini

urmi1

let's start right now , I am ready for your work..

$30 USD dalam sehari
(211 Ulasan)
7.2
coolrankit

------2YEARS EXPERIENCED WEB DESIGNING & SEO EXPERT------

$30 USD dalam 0 hari
(52 Ulasan)
6.3
MustafaSR

Hello Sir, Please check PMB

$30 USD dalam sehari
(87 Ulasan)
5.8
piaoxin

Hi, dear. If you award me, I'll just complete this job clearly and smartly. Thanks.

$50 USD dalam 0 hari
(26 Ulasan)
5.3
nishant074

Hello Hiring Manager, I am ready to start now. Please check message.

$30 USD dalam sehari
(0 Ulasan)
0.0