www.webdeveloper.com
Results 1 to 5 of 5

Thread: Look for beginer help creating a tabel

  1. #1
    Join Date
    Nov 2007
    Location
    FL
    Posts
    71

    Look for beginer help creating a tabel

    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.

  2. #2
    Join Date
    Nov 2007
    Location
    FL
    Posts
    71
    http://www.tarantuladatabase.com/assets/pages/test.html

    This is kinda what I have been playing around with for php If this is working I can see how it works a little.

    I haven't been able to get connected to the database I did find out that to make a table I go into my cpanel then into phpmyadmin. I made a table with 1 field but I don't understand what format I need to use.

    Will i have 1 table for each spider or will i have 1 table called Tarantula with 1 field called Housing and so one like this.

    Code:
    Table called Tarantula
    
    >Housing
    >>>>>>>>Arboreal
    >>>>>>>>Terrestrial
    >>>>>>>>Fossorial
    >Location
    >>>>>>>>New World
    >>>>>>>>Old World
    >Speed
    >>>>>>>>Slow
    >>>>>>>>Medium
    >>>>>>>>Fast
    Is this right at all?
    I am confused about the things that I dont know like genes species and color.

  3. #3
    Join Date
    Jun 2008
    Posts
    2
    What tool do you use to create the table? I'm looking for the available tools nowadays to build my shop database~Thanks

  4. #4
    Join Date
    Nov 2007
    Location
    FL
    Posts
    71
    I think i got the hang of how to create the table... I think

    This is my table

    http://www.tarantuladatabase.com/table.JPG

    and these are the values

    http://www.tarantuladatabase.com/value.JPG

    I couldn't figure out how to leave a field value black so I just put None in as a place holder.

    How does that look?

    andrea32145 What tool do you use to create the table? I'm looking for the available tools nowadays to build my shop database~Thanks
    go to your server and look for phpmyadmin thats what I'm using. it takes alittle getting used to though

  5. #5
    Join Date
    Nov 2007
    Location
    FL
    Posts
    71
    never mind I fixed the id thing and got rid of the search all and none values.

    http://www.tarantuladatabase.com/gotit.JPG

    now i guess i'll try and connect it to the database *Gulp*

    unless you guys have any advice?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles