Page 1 of 1

mysql table basics

Posted: Tue Jun 25, 2002 3:41 am
by mrpaulfrank
since i finally got my webserver to spill the beans on how to use their online pannels...im ready to make a test table. the result id like to end up with is something ive heard to be rather simple. its going to categorize items. id like fields for things like, ID # (auto_inc would i think??), genre, title etc. i have no clue what functions these settings perform (type,length/values, attributes, null, default, extra, primary, index, unique,---, fulltext, and table type) i want a simple hyperlink or button to basically run a php script that will search the database for the genre etc and create a page with around 10 or so results within the genre per-page. i apologize for my idiocy upfront! i cant wait to learn more! thanks a lot for the help guys!

Posted: Tue Jun 25, 2002 8:03 am
by mikeq
I suggest you find some tutorials on databases - normalisation, 3NF, relations, data types, query language etc.

Posted: Tue Jun 25, 2002 4:30 pm
by mrpaulfrank
thanks for the info...ive found an excelent tutorial on phpmyadmin right here on this site. thanks again!

Posted: Wed Jun 26, 2002 9:31 am
by Bill H
mrpaulfrank wrote:thanks for the info...ive found an excelent tutorial on phpmyadmin right here on this site. thanks again!
So where did you find it?

Posted: Wed Jun 26, 2002 9:37 am
by twigletmac
Yeah, if you've found something really useful post the information then others don't have to ask the same question again...

Mac

tutorial

Posted: Fri Jun 28, 2002 3:58 am
by mrpaulfrank
i thought i said it in that post...i found nice tutorials right here on phpcomplete.com. just look thru them, youll find cool stuff! thanks jason.