View Single Post
  #1 (permalink)  
Old 06-12-2007, 12:20 PM
yuppicide yuppicide is offline
Registered User
 
Join Date: Jan 2007
Posts: 99
MySQL help? Will pay.

Does anyone want to make some extra cash and help me with a MySQL database and some website coding?

When our new catalog comes out I'm changing the look of our website. I want a page on our website where people will to be able to search through our whole
catalog.

Here's the fields I want in the database:

Item Number
Colors
Description
Page

.. Maybe one more catagory, Material.

Item Number examples are: 1120G-6153, 3134-7190, 9601-2000, etc.
Color could be more than one if the item comes in more than one color. Color examples: Multi, Black/White, Black/Tan, Red, Orange, etc.
Description would be what the item is. Examples are skirt, pareo, kaftan, tunic, dress, etc.
Page would be the page number the item appears on.
Material examples would be cotton, rayon, etc.

I want a search page on the website where people can search for items and view pictures.

Here's ways people would be able to search:

1 - For example if someone wanted to pull up just one specific item they can enter it under Item Number.. so typing in 9601-2000 would pull up pictures of all
that item in every color.

2 - If someone wanted to see all 9601's (which might take awhile and pull up a few hundred items) it will pull up pictures of every 9601 in every color
showing show only so many results per page.

3 - Maybe someone wants to see everything we sell that comes in brown. They could do that also.

4 - Maybe they just want to see all skirts. They could do that.

5 - Maybe they want to see everything from page 26 of our catalog. They could do that.

6 - If someone wanted to see everything we sell made out of cotton they could do that also.

I just want someone to start me off. I'll supply maybe 20 or 30 items with all the information including pictures for the database. I'll have a free database
to test everything out with. Once we get that working I'll change it all over to my MySQL database on Yahoo! Small Business where we host our website. The
reason I am not using our Yahoo! MySQL database right now is because our Network Administrator has the password to our Yahoo! account and he has to enable
the database. We have to pay him for his time, so we're not doing it right now, but if I can show them a working demo of what is to come, I am sure that
database will be turned on the same day. I just want to get things started because there will probably be over 400 items to add to the database and I can't
pay someone for their time to do 400+ items. I just want help setting up, making the search page, and showing me how to add more entries to the database and
then I'll take it from there.
Reply With Quote