February 13th, 2000, 11:15 AM
I have just started to dab with php as well as Mysql. I am in need of creating a database for an upcoming project.
The project will list retail stores, with the brands they carry (about 20 per store) and some basic information about their store such as the location, email address, website, hours, certifications, location etc.
Then when some one goes to my site they will be able to search for stores in there area, or search for stores that carry there brand in there area, or just plain out search. The search results will also need to display 5 per page.
When this is finnished there will be about 10,000 or more stores, so I will need this as efficient as possible.
What I am in need of is assistance setting up the database. I have been told I will want to set up multiple tables for this so it will stay fast.
So basically I am in need of assistance in setting up the table, and a search form.
To see an example of the output I would like go to: http://www.elitecaraudio.com/audio_stores/test.shtml
If you are able to assist me please ICQ me or reply to this post. My ICQ number is 10271446
Thanks in advance
February 23rd, 2000, 04:29 PM
Are you still looking for help? Let me know if you are.