Help needed for new project

[tbobker]

I need some help, im fine when it comes to understanding how to create a site where all the information is in the database and extracting in all, i have used the $_GET[id] to determin what information to display, but if my site was a template for many users how can i determin what page to display for which users website.

example;

www.mysite.com/index.php?page=gallery

im ok with this

but how can i get this;

www.mysite.com/index.php?username=tbobker&page=gallery

what would the sql be.

perhaps

select * from pages where page_id = $_GET[id] AND username = "tbobker"

is this right, but how can tbobker be a variable? where would it be stored?

Im trying to create a site where users sign up and are given a website of their own but it all goes through one template system.

eventually using mod-rewrite to produce a url for them like this;

www.mysite.com/tbobker/gallery/

so they can have kind of their own url to their site

www.mysite.com/tbobker/

[Scarum]

Pretty much it. Only I would prefer to set a variable that is equal to 'tbobker'... like so:

$username =$_GET['username'];

then the mysql query syntax would be:

select * from pages where page_id = $_GET[id] AND username = "$username"  

if you wanted to, you could also assign the page id to a variable other then $_GET like I've done with the username. You choice.