[SOLVED] URL, PHP and databases

[transparencia]

This is my table:

 

id

titles

1

TitleA

2

TitleB

3

TitleC

 

I want to show the title text for the URL of a page. Something like: www.website.com/titleA.html

 

Also, within that page, www.website.com/titleA.html, I want to add a link to the next page, www.website.com/titleB.html.

 

How can I do this?

[JustLikeIcarus]

Look into Apache mod_rewrite.  I think its the direction you will need to go.

[JonnoTheDev]

You use the primary key to identify the page i.e

 

<a href="page.php?id=1">A</a>

<a href="page.php?id=2">B</a>

<a href="page.php?id=3">C</a>

 

When a user lands on page.php you get the database record to display i.e

// page.php
$result = mysql_query("SELECT * FROM tablename WHERE id='".mysql_real_escape_string($_GET['id'])."'");
$row = mysql_fetch_assoc($result);
print "You are on page: ".$row['title'];

To display the links select the records from the database and loop through them

[JonnoTheDev]

If you want to use friendly urls you could structure like

 

/page/titlea/1

/page/titleb/2

/page/titlec/3

 

as stated mod_rewrite is used for this