chippyb

Hi guys, Just trying to finish off the last bit of work on my sites just to add abit more to the site before they get sent elsewhere,

Basiclly hotel listings get pulled down off the mysql database table and displays a list of hotels and prices in that area, as seen at londonhoteloffers.org.uk/search.php at the moment tho the view details link is a link that points to that hotel on laterooms, but I would like to be able to be able to click that link and then it creates a dynamic page by pull the rest of the data row from the db of the hotel infomation on my site, I have looked around in row to do this and I kind of understand how its done I just cant find what im looking for on google, I thought I did but wasnt quite right, can anyone tell me what its called Im looking for or point me to a site or tutorial of what im trying to do,

Thank you for you time

Ryan

grantw

Change the link to:

yourdynamicpage.php?ID=12345

Where 12345 is the id number of the hotel from the database.

Then in yourdynamicpage.php use:

$hotelID = $_GET['ID']

You then use the $hotelID variable within the SQL query to bring back the data you need to build the page.

Grant

__________________
Domain Brokerage :: Bulk UK Whois :: Property Insurance

dta

if you already query the db to get the summary data from the row, you simply need to extend the query now to select the other columns you'd like to display and format your html accordingly to display the returned data.

__________________

iBranded sites... Football Betting Tips | Cheap Flights | High Interest Bank Account | Instant Loans | London Olympics | Desi | Online MBA Courses | MBA

chippyb

thanks for the reply, can you point me somewhere to where i can read up about this, or tell me what its called im looking for so i can search it myself, pref somewhere that has examples

thanks

chippyb

also where in the link you put 12345 instead would it be ['hotelid'] or ['ID']

thanks

grantw

Play around with it and work it out for yourself, I've just given you the basics of what you need to do.

Also, why have you opened two identical threads for this?? Please get admin to close one down.

Grant

__________________
Domain Brokerage :: Bulk UK Whois :: Property Insurance

Skinner

If your using GET, for ANYTHING cleanse the data. For a number use is_numeric to verify someone isn't trying to inject anything.

__________________
Browse:

chippyb

i would rather not get little bits of info like this now i sort of know what im doing as it makes it harder to guess! that why im asking to point me somewhere that has a tutorial on this or info of what im after, or even just tell me what its called im looking for
Thanks

grantw

passing variable in url

passing variable between pages


or something similar

__________________
Domain Brokerage :: Bulk UK Whois :: Property Insurance

newpbc

You want to do something like this with the ID as sugested
http://www.scottklarr.com/topic/91/p...-url-with-php/
All the time your spending on this mate you could be rewriting the laterooms content in wordpress
I know cron was a pain with your host but im sure one of the online solutions would have worked with less effort than this is going to be for you to get setup

__________________
Laterooms Wordpress Solution |