[Trying to understand how to create a dynamic page from a mysql link]

Excellent.  You guys are good!  Thanks very much!  I can see how this could get addicting. 

[Trying to understand how to create a dynamic page from a mysql link]

Okay... so this worked perfectly for me.  I am able to create the 'shell' page for my entire database.  Thank you! 

 

Now that I have the URL, I was just wondering if it was possible to reformat the url of the new page?  Currently, it looks something like: 

http://www.mydomain.com/description.php?id=the-title

 

For SEO purposes, is there a way to reconstruct it as: 

http://www.mydomain.com/the-title

 

[Trying to understand how to create a dynamic page from a mysql link]

That's pretty much exactly the information I was looking for so thank you for pointing me in the right direction!  I'll try putting it into practice and holler back with any problems. 

 

Thanks again!  Big help! 

[Trying to understand how to create a dynamic page from a mysql link]

Hi guys.. 1st post here.  I'm pretty new to php.. just a few weeks in.  I've gotten pretty decent at making mysql connections and extracting data, but now I'm wanting to take one of my urls that I echo to my page and create a new page.  Hoping someone can help...  Here's the picture:

 

MY MySQL Setup:

I have 1 table called table1. It has 2 columns which are: 'Title' & 'Description'

 

My Index.php Page:

I connect to mysql. I pull the 'Title' from MySQL and loop it to produce 100 rows of data that fill my index page, as expected.

 

My Problem:

I now want to be able to click one of those rows and dynamically create a new page (description.php) that includes the 'Title' & 'Description'.

 

My Progress:

I've managed to click a row and create a hyperlink to mysite.com/$title (where 'title' is pulling the 'title' from the mysql db) but I all I get is page not found.

 

My Question:

How do I tell description.php to pull the 'Title' and 'Description' and link to it from index.php?

 

My Gratitude:

Thanks in advance!