Jump to content


Photo

PHP with MySQL...


  • Please log in to reply
1 reply to this topic

#1 Korey

Korey
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 28 September 2006 - 11:44 PM

Okay, I am a noob heres my problem:

Im just starting on a news system and I neeed to create a database with the following columns:
#date
#id
#title
#body
#Author

I know ID has to be primary. But I don't understand what Length/Values1, Collation, Null, Default2 are.

Please help me out.

Thanks.  8)



#2 Demonic

Demonic
  • Members
  • PipPipPip
  • Advanced Member
  • 562 posts

Posted 29 September 2006 - 01:54 AM

make id primary like you said,then make it autoincrement so the id number increases everytime you insert news.

Value/Length is how long the post will be just make the message VARCHAR and Length/Value 255

that goes for everything.

try looking at tutorials here: http://www.pixel2lif...and_guestbooks/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users