PDA

View Full Version : MySQL HELP



308holes
January 31st, 2003, 04:27
Hello all I am sooooooo New to Database Stuff

Im trying to make a mySQL database wich i did i have the database made now i need to add the info . i tryed "Structure" but was getting erros..

i need a database that can hold:

01/10/2003
Chad
On this Day i made a Cookie.

Thanks for alllll your time and help !!

ansa
January 31st, 2003, 09:27
if you've got a database, then you now need a table.

for your example you can create it like this

create table my_table_name (
thisdate date,
name varchar(100),
text text
);

this will give you a table called my_table_name with the 3 fields thisdate,name,text.

hope that helps

Andy.

308holes
January 31st, 2003, 11:14
Cool thanks for the reply Do i do this in my php code or in phpMyAdmin ?

ansa
January 31st, 2003, 13:21
in phpMyAdmin