Php Tables

[natimage]

I'm brand new at using cpanel's phpadmin...and I'm brand new at mySQL!! I've created a database, and I've created a table. But when I try to save the table, I get errors. Is there some place I can get very detailed instructions on working with my tables in phpadmin?

[TCH-JimE]

Hi,

 

There are many detailed sites on the net to deal with php and MySQL. Here is just one : Click here You may also think about buying a book. Although this may sound odd, if you plan to do alot of MYSQL/PHP work, its handy to have a decent book which you can reference. (There also good for reading when waiting for the train/stuck in traffic etc! )

 

Jim

[natimage]

Hi, Jim. Thanks for the response. I've checked out that link and now have another question. Is it easier to use the "mySQL" provided by TotalChoice or to download MySQL onto my computer? I did do the download thing last night, but couldn't get past the "connection" dialog.

 

Thanks again.

Tracy

[TCH-Sales]

I'd say it'd probably be easier just to use the one built into the CPannel.

[TCH-JimE]

I would agree too, downloading it to your system is a very delicate issue! I would suggest keep going using cpanel and some books and simple scripts you find online. As you build up your confidence and knowledge, then you can really branch out!

 

Its always tempting (i know i still do it) to try and do something really aventrous first (mabye cos i am an Aries?) but it never fully works, or that i fully understand it. Hence i am trying to run before i can walk. Hence i'm learning to be patient and doing everything simple before getting complex!

 

keep going though, once mastered its amazing what you can turn out!

 

Jim

[natimage]

Hi, again. Thanks for the guidance about using cpanel! Here's a more specific question, because for one reason or another I just can't figure it out. I created a database and gained access to the database. Then I created a simple 2 field table. I named the fields...chose "text" as the type, and made one of them the index field. Then when I try to save the table, it gives me an error that I haven't set the length for the index field (that's not verbatim). When I type a number into the length box, it gives me a syntax error. SOOOOOOOOOO...is there some easier way to do this that I haven't figured out? I've looked at quite a bit of the help information and I've learned some things. But I can't find any info. to help me with the table building.

 

AND...once I get this blamed table created and saved...do I use phpadmin to enter all the data?

 

Sorry for all the novice questions...I will get a book soon. But, in the meantime I will take any info/help I can get! When it comes to web design I'm a self-taught creature. I'm doing pretty good so far, but this MySQL, Perl, PHP, phpAdmin, database monster has stumped me.

 

Thanks again.

Tracy

[TCH-JimE]

Hi,

 

For help creating a table:

 

http://www.mysql.com/doc/en/CREATE_TABLE.html

 

and a friendly guide here:

 

http://www.createafreewebsite.net/phpmysql...eate_table.html

 

Jim

[Spitsbe]

Hi JIm,

 

I was reading through this and thought I'd give this birthday db a try. But I can't seem to figure out how to get the "create data base utility" to work. I tried everything I can think of.

 

I can get the creat table utility to work via the internet, at least the forms come up to enter the data.

 

The tutorial says that I must use the "creat data base utilty" through the cpanel. But hence, I am confused. how is this suppose to be done. I am probably missing something silly

 

Is there a simple answer to this problem or should I contact the author of this tutorial.

 

Thanks again, and sorry for butting in on your forum Tracy.

Glenn

[Spitsbe]

Nevermind, I figured it out, Thanks anyway.

Glenn