dhendler Posted October 5, 2007 Share Posted October 5, 2007 Hello, This is my first post in this forum, I am also pretty new to PHP and mysql, and I'm having trouble wrapping my brain around it. This is kind of a PHP/mysql question. I am trying to create an item tracking website similar to http://www.wheresgeorge.com. I'm having trouble processing the html form, especially the "date found" portion. I also don't really know how to set up my tables in my database so that they work efficiently. The information I an requesting with the form is: item_number, found_by, date_found, city, state, country. I'm assuming that I will have to have more than one table in order for people to search by item_number or found_by etc. I know these are kind of broad questions, but let me know if you'd like me to post what code I have, or stick the files on my FTP for download. I am using SQL Manager for a mysql client and Dreamweaver CS3 for design. Thank you in advance for your patience with me, I know how it is to help newcomers Quote Link to comment Share on other sites More sharing options...
MmmVomit Posted October 5, 2007 Share Posted October 5, 2007 How exactly is the site supposed to work? What are you tracking? Why are you tracking it? Quote Link to comment Share on other sites More sharing options...
dhendler Posted October 5, 2007 Author Share Posted October 5, 2007 Long story short. A friend of mine is into geocaching (http://www.geocaching.com). There are items called tracking bugs for geocaching, you can also create your own trackable items. There is a website called http://www.sigitem.com where this guy has created sites for people with trackable items, but I would like to create something a little more interactive and nicer looking like this one http://www.geofish.net Quote Link to comment Share on other sites More sharing options...
MmmVomit Posted October 5, 2007 Share Posted October 5, 2007 To start with, it sounds like you need the following tables. item find user Item will have one record for each individual item you want to track. ID number, maybe a description, etc. User will have user information, so you can track who has found what. This table may not be strictly necessary. Find will log where and when the different items were found and who found them. Is that enough to get you started? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.