Go Back   CodingForums.com > :: Client side development > HTML & CSS

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 05-13-2011, 05:29 PM   PM User | #1
watty4
New to the CF scene

 
Join Date: May 2011
Location: USA
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
watty4 is an unknown quantity at this point
Beginner: First Project

Here is what I am looking for and what I am trying to do:
1. What programs do I need to create such a program?
2. How hard is this project going to be? Beginner? Pro?

1. User selects a “keyword” from a list on a drop down menu.
*The first word selected provides the program with which database to use.
Example: User selects “Cat” from the list, the program now knows to use only the cat database from now on.

2. User selects another “keyword” from a list of sub-categories of “Cat.”
*The program is now searching for this word in the “Cat” database but under a different sub-category. The list has been pre-determined and only appears
because the user selected “Cat.”
Example: User selects “Short-Haired” from a list of descriptions of “Cat.”

3. User selects another “keyword” from a list of sub-categories of “Short-Haired”
*The program searches for this word in the “Short-Haired” database.


I know my example is somewhat lacking but it’s the best I can do at this point. Here is an outline of what I am trying to do:
1. Use keywords to pinpoint a database that contains items as closely related to the search words as possible.
2. There will be more than one option for the user’s inputs but I need the program to only display one at the very end.
3. There will be a set number of user inputs.

Any information you guys can throw out would be extremely helpful, I mean absolutely anything. Thanks.
watty4 is offline   Reply With Quote
Old 05-13-2011, 05:49 PM   PM User | #2
teedoff
Senior Coder

 
Join Date: Aug 2010
Location: High Point, NC
Posts: 3,325
Thanks: 5
Thanked 363 Times in 360 Posts
teedoff is on a distinguished road
Cat is a Field in a database table correct?

You would use a server side language such as php, in conjunction with a database such as MySQL. Then your database queries would return results depending on the "first" user selection. Then this selection would in turn populate the second selection options with yet another SQL query, so the user can select and narrow down their results.

All similar to how ebay for example, "drills" down a category like Golf>Clubs>Irons>Left Handed>Price....and so forth.

Is this what your talking about?


BTW, this is a pretty advanced "first project" if you've never designed or worked with a database or website before.
__________________
Teed

Last edited by teedoff; 05-13-2011 at 05:53 PM..
teedoff is offline   Reply With Quote
Users who have thanked teedoff for this post:
watty4 (05-13-2011)
Old 05-13-2011, 07:48 PM   PM User | #3
DanInMa
Senior Coder

 
DanInMa's Avatar
 
Join Date: Nov 2010
Location: Salem,Ma
Posts: 1,336
Thanks: 13
Thanked 207 Times in 207 Posts
DanInMa is on a distinguished road
<-- smells a homework assignment
__________________
- Firebug is a web developers best friend! - Learn it, Love it, use it!
- Validate your code! - JQ/JS troubleshooting
- Using jQuery with Other Libraries - Jslint for Jquery/other JS library users
DanInMa is offline   Reply With Quote
Old 05-13-2011, 08:58 PM   PM User | #4
raptorjgzus
New Coder

 
Join Date: May 2011
Posts: 19
Thanks: 0
Thanked 4 Times in 4 Posts
raptorjgzus is an unknown quantity at this point
If I understand correctly what your wanting to achieve then this is the extension from joomla you would want. http://extensions.joomla.org/extensi...irectory/16649

I dont know if you are in intrested in lessening your work load, but i suggest a content management system. I use joomla. There are others like drupal, ruby on rails, wordpress. But being your first project and a rather large one at that. I strongly suggest a little assistance.
raptorjgzus is offline   Reply With Quote
Old 05-13-2011, 09:57 PM   PM User | #5
watty4
New to the CF scene

 
Join Date: May 2011
Location: USA
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
watty4 is an unknown quantity at this point
Haha no homework DanInMa.

teedoff, that is very close to what I am looking to do, if not exactly. I think the only difference might be is when the final keyword is searched there will be several items in the database that match the keywords, but I only need one to display at a time.

I realize that this is going to be pretty tough but I can't afford to pay someone to do it for me so I'll figure it out

Any suggestions on where I can get some good tutorials on php and MySQL?
watty4 is offline   Reply With Quote
Old 05-14-2011, 03:31 AM   PM User | #6
teedoff
Senior Coder

 
Join Date: Aug 2010
Location: High Point, NC
Posts: 3,325
Thanks: 5
Thanked 363 Times in 360 Posts
teedoff is on a distinguished road
Quote:
Originally Posted by watty4 View Post
Haha no homework DanInMa.

teedoff, that is very close to what I am looking to do, if not exactly. I think the only difference might be is when the final keyword is searched there will be several items in the database that match the keywords, but I only need one to display at a time.

I realize that this is going to be pretty tough but I can't afford to pay someone to do it for me so I'll figure it out

Any suggestions on where I can get some good tutorials on php and MySQL?
http://www.w3schools.com is a good start. Also the php website has great tutorials a well as the MySQL website.

If you havent already, download and install WAMP or XAMP(windows) or MAMP for Macs. This will install MySQL database, Apache web server, and PHP server all in one package.
__________________
Teed
teedoff is offline   Reply With Quote
Old 05-14-2011, 06:32 AM   PM User | #7
alykins
Senior Coder

 
alykins's Avatar
 
Join Date: Apr 2011
Posts: 1,608
Thanks: 37
Thanked 183 Times in 182 Posts
alykins will become famous soon enough
does this have to be a web app? you can accomplish same tasks using other coding languages
__________________

I code C hash-tag .Net
Reference: W3C W3CWiki .Net Lib
Validate: html CSS
Debug: Chrome FireFox IE
alykins is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 10:37 AM.


Advertisement
Log in to turn off these ads.