Help needed with php and mysql

[doenci]

 

I am such a beginner but I had gone this far....

Here is the code:

 

<?php

 

$url = "http://www.website.com/";      // The simple url

$name = "11215";                      // this data coming from database

$newUrl = $url . "$name";    // appending the new url

header("location:$newUrl"); //the new url redirected

exit;

 

?>

 

 

So I'd like to get a $name variable (zipcode) received from a database or any file.

Everytime the url/site refreshes the next or randomly picked zipcode should be the new variable for $name

and the one was just used should be deleted from the database. I guess it's like an array...

I have a mysql database on my server set up which I have to connect to....help would be nice there too .

I am wondering if I could run the database from my local computer without connecting to any server.

 

Any help would be great!

 

Thank you guys...

 

doenci

[fenway]

I'm not sure if you really mean "deleted"... maybe keep a count?