Help With Godaddy

[monkepinay]

Hi all, I see this seems to be the place to live if you are just getting use to PHP and MySQL like my self. How ever, I have to admit I took on a project that I had no business doing. At first a friend asked my to make him a web page, I thought, "no big, deal. I've done it a thousand times before." However, I'm coming to find out that something he is asking me to do for him is including a database, which frankly I just can't do right now. I'm just now taking a SQL class, and I don't really know how I'm passing. I'm not even sure if it's SQL, I think it's Oracle, but I don't know the difference. I was just told that I had to take this class to get my AS so I got it online a turn in an assignment every week.

 

But I digress

 

The point

 

I'm using godaddy as the server for this side (because the guy signed up for it before I had any say) and I've never used them before, let alone ever tried to use a data base on their server. So I want to do a data base, and I know the first thing to do is to create a table. I tried using the mysql query thing to drop a table but that gives me errors, and I tried to use the form that they have to create a table, but that gives me errors too. Which is freaking me out because I thought the whole thing was idiot proof.

 

So... what should my first step in making my first table in godaddy be. Maybe I'm using the wrong syntax because I'm actually use to oracle or something?

 

If anybody is familiar with godaddy please please help this noob.

[fenway]

There's nothing special about making a table there vs. anywhere else... find a control panel, and issue statements.

[monkepinay]

This might be a little more helpful with making clear what I need help with, sorry I didn't do this sooner.

 

when I click on control panel this is what it looks like

then I click on data base

then I click on mysql

now the database I wan to use is city motors. there is currently nothing in it. I click on open manager and it prompts me for my pass word. afterward I get a window that looks like this

Now when I'm in class and I want to make/add to a table I would go to something that looks like this

Which Is what I get when I click on Query Window.

-------------------

 

I think it's that I'm not coding correctly, but I'm not sure. Is it possible that I'm not going to the right place to make the first table for this database?

 

This is an example of code that I use when I'm in class that works in class but not here.

DROP TABLE CUSTOMERS;

 

Create table Customers

(Customer#  NUMBER(4) PRIMARY KEY,

LastName VARCHAR2(10),

FirstName VARCHAR2(10),

Address VARCHAR2(20),

City VARCHAR2(12),

State VARCHAR2(2),

Zip VARCHAR2(5),

Referred NUMBER(4));

 

INSERT INTO CUSTOMERS

VALUES (1001, 'MORALES', 'BONITA', 'P.O. BOX 651', 'EASTPOINT', 'FL', '32328', NULL);

Commit;

 

[monkepinay]

oh and this is the error I get with that sample code

[wildteen88]

When you get to this screen:

You see where it says (Databases)... in the drop down menu on the left you have to choose a database to use. When you select a database from that menu you should be shown a table editor on the right hand side/or an option to create a table if there is no tables currently available for that database.

[monkepinay]

When you get to this screen:

**img**

You see where it says (Databases)... in the drop down menu on the left you have to choose a database to use. When you select a database from that menu you should be shown a table editor on the right hand side/or an option to create a table if there is no tables currently available for that database.

 

Wow!! I can't believe what a simple mistake I was making, I really appreciate it.

 

Golly I feel so simple / special ed right now.

[monkepinay]

 

Ok... Another Question

Well not really a question, but... well yea...

 

Um can anybody point me in the right direction as far as having a php page to add values to the table, maybe in conjunction with a form of sorts?

[fenway]

oh and this is the error I get with that sample code

 

You need "IF EXISTS".

[fenway]

 

Ok... Another Question

Well not really a question, but... well yea...

 

Um can anybody point me in the right direction as far as having a php page to add values to the table, maybe in conjunction with a form of sorts?

Same place as before, go to the table screen by clicking on the table... you may want to look though some phpmyadmin tutorials.

[monkepinay]

Same place as before, go to the table screen by clicking on the table... you may want to look though some phpmyadmin tutorials.

 

Do you have any suggestions that are for the simple minded. I mean, I am familiar with form and with php but, what I know is limited to extremely basic...ness

[fenway]

Suggestions for what?

[markjoe]

Um can anybody point me in the right direction as far as having a php page to add values to the table, maybe in conjunction with a form of sorts?

 

Is this what you're looking for?

http://www.phpfreaks.com/tutorials/142/0.php

[monkepinay]

Um can anybody point me in the right direction as far as having a php page to add values to the table, maybe in conjunction with a form of sorts?

 

Is this what you're looking for?

http://www.phpfreaks.com/tutorials/142/0.php

 

yes actually that is some what help full.

 

By the way, how do I know what my local host is if I'm using godaddy? I tried my domain name and that really isn't working. is the the dns thing?

[TheFilmGod]

"localhost" doesn't apply to you. Since you aren't hosting it on the same machine as your mysql/db.

 

Awhile ago godaddy gave you a link on the mysql table page (before  you go into phpmyadmin) that actually gave a snippet of code to connect to the db and to query a single row.

 

Here is mine. Change your parameters:

 

<?php
//Connect To Database
$hostname="h50mysql13.secureserver.net";
$username="username";
$password="toostupidtomakearealpassword";
$dbname="wwpknights";

mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to database! Please try again later.");
mysql_select_db($dbname);

?>

 

EDIT: I use godaddy. Do not assume "localhost" EVER! I wasted three months getting annoyed over the whole thing until I figured out localhost doesn't apply to me...  :-X