mysql table basics

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mrpaulfrank
Forum Commoner
Posts: 33
Joined: Sun Jun 23, 2002 3:39 am

mysql table basics

Post 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!
User avatar
mikeq
Forum Regular
Posts: 512
Joined: Fri May 03, 2002 3:33 am
Location: Edinburgh, Scotland

Post by mikeq »

I suggest you find some tutorials on databases - normalisation, 3NF, relations, data types, query language etc.
mrpaulfrank
Forum Commoner
Posts: 33
Joined: Sun Jun 23, 2002 3:39 am

Post by mrpaulfrank »

thanks for the info...ive found an excelent tutorial on phpmyadmin right here on this site. thanks again!
User avatar
Bill H
DevNet Resident
Posts: 1136
Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:

Post 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?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
mrpaulfrank
Forum Commoner
Posts: 33
Joined: Sun Jun 23, 2002 3:39 am

tutorial

Post 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.
Post Reply