htmltables, sql, php

[Anon]

Ok, this is the situation:

I have got an mysql database and this contains the table members with several items like name, rank, email, etc.

Now I want to show the name and the rank in a table in a html page. This I can do BUT, I want every name to be a link in that html page and link it to a page where all the info about that particular name is shown.

THe way I coded it at first makes it impossible to let a particular field be a link, it is more like: all are a link or none.

So my question(s):

How do i code the first page with a list of all the members and show these in a nice table and how do i make only the name a link.

And how do I have to make the page where it links to.

Muchos gracias for the answer...I am kinda new to php 🙂

Grtz,

Rooseboom

[Anon]

sorry i cant help but thats exactly the problem i have to solve after the problem below 🙂

[sleepycoder]

Here is a good example for the question below:

echo"<td><a href=\"ShowApartment.php?ID=".$row["MemberID"]."\">".$row["CompanyName"]."
</a></td>\n";

This will give you the CompanyName and also create a link that will pass the MemberID - there for you can run a query on the next page where MemberID=$ID or something like that to have it display the right information.

sleepycoder

Rooseboom wrote:

Ok, this is the situation:

I have got an mysql database and this contains the table members with several items like name, rank, email, etc.

Now I want to show the name and the rank in a table in a html page. This I can do BUT, I want every name to be a link in that html page and link it to a page where all the info about that particular name is shown.

THe way I coded it at first makes it impossible to let a particular field be a link, it is more like: all are a link or none.

So my question(s):

How do i code the first page with a list of all the members and show these in a nice table and how do i make only the name a link.

And how do I have to make the page where it links to.

Muchos gracias for the answer...I am kinda new to php 🙂

Grtz,

Rooseboom

[Anon]

Hi Guys,

I have just started getting into php and mysql. I have the same problem as above but would like to get more details and sample code as to how this works.

Requirements:

1. Code samples
2. Database connection
3. How to get ID
4. How to pass it onto the next page, etc.

Basically, it is the whole code sample from page 1 to page 2, etc.

Thanks