I have been asking really basic generic questions trying to find out what I need to start building a search function for my web site and as far as I know the first step is for me to conceive the database organization. I thought this sounded easy, because I just needed to make a table but that thought didnt last long.
I don't know any php or mysql code. I just searched around and found that phpmyadmin was a really good program and I check my cpanel to make sure I had it.
Then I looked into the database and I found out that I need a table but the page i was reading was kinda like my question very vague and didn't give me any step by step instructions.
So right now I am trying to conceive the database organization. I thought this sounded easy, because I just needed to make a table but that thought didnt last long.
Where do I make the table at on a blank page? On my index? on my search page? It didnt say
I think I need one entry per species, with at least one field being an absolutely unique ID: usually just a number or something. It would be tempting to use the Latin name, since a species is uniquely identified by its name, but this is probably not a good idea, because of subspecies, and curiosities like the "official name" changing.
but I don't know if I need to do that because I want something that will allow my users to submit all the data. Its hard to explain but there are 800+ different species and there are news found all the time. If I need to make a table with all of them in it then doing it this way is not what I neeed.
I'm sure I'm going to have to code my own but if there are many choices to code it with what option would you guys recommend for someone that only knows html/css?
I am willing to lean new code though i just heard that you could it without php or mysql.
Thanks so much for all the advice I'm just having trouble finding a starting place.