SQL/phpMyAdmin newbie needs help....

heebiejeebieclu's picture

They have: 527 posts

Joined: Aug 2004

OK, so I have a MySQL database. What I want to be able to do is let users add data to the database, and then for everybody's results to be searchable.

A similar project to mine would be to let visitors submit their site, and to turn everybody's submitted sites into a special search engine.

So, I need a form for submitters to fill in, and a search function.

I realise that this will probably a lot to explain in one post, so if you know any articles....

He has: 1,758 posts

Joined: Jul 2002

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 '

Andy

heebiejeebieclu's picture

They have: 527 posts

Joined: Aug 2004

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.

They have: 78 posts

Joined: May 2006

why don't you try a content management.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.