[Griggsy]

Just finished designing and posting first version of an Estate Agency site.
http://www.simpson-property.com

the lettings section is currently run via an opensource cgi news script and the sales section i have to update every time something changes.

Obviously the next step is to create databases for these 2 areas that i can change on the fly at a moment's notice.

simple question really where's the best place to start to get my head into creating a dbase??(the sites hosted on Unix!!))

[Simon Mundy]

Originally posted by Griggsy:
<STRONG>Just finished designing and posting first version of an Estate Agency site.
http://www.simpson-property.com

the lettings section is currently run via an opensource cgi news script and the sales section i have to update every time something changes.

Obviously the next step is to create databases for these 2 areas that i can change on the fly at a moment's notice.

simple question really where's the best place to start to get my head into creating a dbase??(the sites hosted on Unix!!))</STRONG>

MySQL.com to get MySQL installed if you haven't already. There's also some basic tutorials to get you into the swing of things.

Hotscripts for a bunch of cheap (or even free) scripts using either PHP or Perl.

Amazon (or your supplier of choice - no plugs here!!!) to buy PHP and MySQL Web Development by Luke Welling and Laura Thompson. SAMS publishing do some great instructional how-to's. This book's thorough, simple and helpful. A bargain for the price.

The Avalanches for some nice tunes to listen while you learn :-)

[ReggieX]

If you're looking into MySQL, consider PHPMyAdmin as your maintenence tool. It's open source (so you can fix the author's ANNOYING tendency to use tiny 8px fonts) and easy as pie.

[torifile]

I also recommend php and mysql. PHPmyAdmin is good for administration, but if you're really adventurous you could write a front-end with authentication for your administration page. That way anyone can do it without your worrying about them screwing up the database itself. It's fun stuff if you've never done it before (tongue firmly in cheek).

[Griggsy]

Cool ,

had considered using MySql 'cos server has php admin. So looks like the best bet, any ideas on which is best place for a beginner like myself to get into php and mysql, have mucked about with cgi and perl with a smattering of asp, but am really a designer, so need basics/initial concepts, etc.

btw what do you think of the site??

[ 03-07-2002: Message edited by: Griggsy ]