foottuns — Wed, 11 Oct 2006 20:03:37 +0000

why don't you try a content management.

heebiejeebieclu — Mon, 31 Jul 2006 12:05:47 +0000

OK, this might be more complicated than I imagined, but thanks for your help andy. I'll work on it and see what I come up with.

andy206uk — Sun, 30 Jul 2006 21:02:13 +0000

It's probably best that you buy a book to be honest. I don't think many people have the kind of time required to teach you how to do this in a forum post and not all online tutorials will be detailed enough. I should imagine sitepoint.com will have a relevant tutorial.

The MySQL stuff is relatively simple, just two lines one for inserting the data from the form and one to select the data based on the search parameters it's writing the PHP to do all the stuff in the middle that's a bit more complicated.

Here's an example of an SQL insert:

INSERT INTO `dbname` VALUES ('blah','blah','blah')'

Here's an SQL select based on a query (returning 10 results):

SELECT * FROM `dbname` WHERE blah = 'blah' LIMIT 0, 10 '