Display mysql data

[ramram]

I have a table that is something like this:

 

(table name: sites)

 

ID----FileName-----FileAddress----About

1----website1-------google.com----Seach engine

 

How can I make a code in such a way that it can be like:

 

Display all of the FileName in an alphabetical order on file.php that links to their further information page. i.e FileName=website1 links to /file.php?sites=website1

 

 

Now when someone clicks on that /file.php?tablename=FileName

 

It will show for instance

/file.php?sites=website1

 

And then in side it, it will show About section of website1

[fenway]

Huh? Is the problem with the query or the script?

[ngreenwood6]

You will have to look into the $_GET method. you can use it to get links from the url and you can put data in the url like you had done. You will also need to query the database. If you come up with some code somone will be willing to help you but no one will show you how to code this

[Maq]

Pseudo:

 

SELECT all your data.

Use HTML and embed your SQL results in the links.  Example:

 

On your next page you need to use $_GET for these.

 

And then:

 

And then in side it, it will show About section of website1

 

I don't know what this means...