making table in phpmyadmin?

nolimitman

Hello, im trying to make a table in phpmyadmin following this tutorial
on how to make a master detail pagein dreamweaver.
http://www.adobe.com/support/dreamweaver/building/master_detail_php/master_detail_php02.html
I have good knowledge in dreamweaver but my php knowledge is limited to
setting up finished scripts and some simple coding.
I come so far that i set up the site testing server and so on without any problem and i can connect to the msql/database.
My problem starts when trying to setup the table/database in phpmyadmin i followed a tutorial for this and i get a new database made but when i try to
define the table in the recordset query in dreamweaver i only get the table name
and it says no columns.
Anybody here that could give me some detailed info on how to make the table in phpmyadmin so it will work with this tutorail id be very thankful!

                                                                 / Nolimitman

big_nerd

Here is something I put together really quick. It is just some screencaps and a basic HTML file that shows you how to insert tables.

Keep in mind I showed defining a Primary Key. This will allow you to have each row (or section of data) have one single unique identifier, for modificaiton, reading and deletion. very important to use.

Additionally I use tinyint (as I setup a table for Playing Cards as the example). Be sure to use the proper data type that you have. IF you are unsure, varchar is like a string... text is if you have a LOT of data (text data of course).

If you have any Data Type Specific questions, feel free to ask.

I have included a Zip File. It is i a bunch of images with a tutorial.html file.

Best of Luck!

nolimitman

thanksalot!