The actual integration of a database with a website

[brzy56]

As I am still a newcomer to databases (yet learning, slowly but surely), I have a question, that hopefully has a basic answer.

I'm just trying to understand the specific technical aspects of actually integrating a database into a website. Calling the information to the actual webpage.

So take this random website for example: http://www.123aptsearch.com

You click on a city, and it pulls up a list of properties. They must be coming from some sort of database. All I want to know is what is needed to run that. I.E. is it a SQL statement that pulls that data from the database? Or is it a CGI code, or PHP or what? The basics. I hope I'm asking the right question.

I just keep hearing about so many different kinds of languages, etc. I want to keep it simple, and I found this website would be a good example of something simple. I will go from there.

Thanks for your help.

[brzy56]

Let me elaborate. I was just looking through my Blog site, which I use cafelog.com B2 script to power, and a MySQL database. So I was looking through it, and the B2 software uses PHP language to pull and post to and from the MySQL database.

That said, could I do some simple layout similar to the site posted above with say just PHP and MySQL?