connecting a database using godaddy

[nicoletsii]

I have been tring to connect to my database using godaddy i keep getting an error#1064 you have an error in your SQL syntax check the manual that corresponds to your MYSQL server version for the right syntax to use near
[PHP]<?php
// connect to database
$hostname = 'h41mysql47'.se cure.net';[/PHP]
How can I fix this?

[Atli]

Hi.

We need more info to be able to help you at all.

To start with, we need to see the code you are using to connect to your database.

[nicoletsii]

sorry here is the code
[PHP]<?php
//connect to database
$hostname = 'h41mysql47.sec ureserver.net';
$username = ' username';
$password = 'userpass';
$dbname = 'dbname';
$usertable = 'usertable';
$yourfield = ' yourfield';

mysql_connect($ hostname, $username, $password) OR DIE
(' unable to connect to database! please try again later.');
mysql_select_db ($databasename) ;

$query = 'select * from $usertable';
$result = mysql_query ($query);
if ($result) {
while ($row = mysql_fetch-array ($result)) {
$name = $row ['$parts'];
echo 'name:'. $name;
}
}
?>[/PHP]

When I use this code it gives me the error

#1064 you have an error in you r SQL Synax, check the manual that corresponds to you mySQL sever version for the right synax to use near '<?php
//connect to database
$hostname = 'h41mysql47.sec uresever.net at line1

This is the code & the error that i'm getting & godaddy Tech. support gave me this code & would not help my out any futher. I'm at the point to were I'm ready to get rid of godaddy.
What do you think?

[Atli]

What exactly are you doing with this code?
The error would suggest you are using it as a SQL query?

This is PHP code, meant to be executed as PHP code, not as a SQL query.
It would typically be placed in a .php file on a web-server and execute via a browser.

P.S.
Please use [code] tags when posting code examples.

[code] ...Code goes here.. [/code]

Thank you.
Moderator

[nicoletsii]

What exactly are you doing with this code?
The error would suggest you are using it as a SQL query?

This is PHP code, meant to be executed as PHP code, not as a SQL query.
It would typically be placed in a .php file on a web-server and execute via a browser.

P.S.
Please use [code] tags when posting code examples.

[code] ...Code goes here.. [/code]

Thank you.
Moderator

How would you do that? As you can tell I have no clue about servers.

[nicoletsii]

How would you do that? As you can tell I have no clue about servers.

I'm using go daddy's database mysql & they are saying that you can use in conjuction with php & other scripting languages.

[Atli]

How would you do that? As you can tell I have no clue about servers.

Ok.

Firstly, why are you attempting this?
These sort of connections are usually used with PHP web-applications, and by the sounds of it, you are not developing such an application.

If this is just a test, something your trying to learn, I would recommend finding a tutorial about the basics of web-development first.

There is really no point in learning how this code works until you have learned that.
It shouldn't take long tho and there is no shortage of material on this subject online.

[nicoletsii]

I do have an associates degree in web development but I have never had such problems connecting to a database. c I used dreamweaver to create my site & go daddy for my hosting server & for some reason u can't use the database in dreamweaver in godaddy. So I created a database in godaddy and was trying to connect it to my web site that way. Do you have any solutions to this problem? I 'm was just going to change my hosting server. I've done alot of research and have not found a solution. When I called godaddy that is the code they told me to use that is why I was trying it. Really i have 2 web sites right now that don't have a database. What do you think I should do?

[nomad]

I do have an associates degree in web development but I have never had such problems connecting to a database. c I used dreamweaver to create my site & go daddy for my hosting server & for some reason u can't use the database in dreamweaver in godaddy. So I created a database in godaddy and was trying to connect it to my web site that way. Do you have any solutions to this problem? I 'm was just going to change my hosting server. I've done alot of research and have not found a solution. When I called godaddy that is the code they told me to use that is why I was trying it. Really i have 2 web sites right now that don't have a database. What do you think I should do?

have you enabled the gui script that will all your site to read php?
if not it should be in your host settings.
nomad

[Atli]

I do have an associates degree in web development but I have never had such problems connecting to a database. c I used dreamweaver to create my site & go daddy for my hosting server & for some reason u can't use the database in dreamweaver in godaddy.

I don't really know what Dreamweaver is doing behind the scenes so I can't really say what it's doing wrong, but I know that if you can actually edit the code itself it shouldn't be hard to fix.

I actually took a couple of "Web-Development" courses in school a few years back that were all about Dreamweaver. If that is anything like what you are doing, then I would strongly recommend trying to learn the actual code behind it, not just how to create it using Dreamweaver.

Being dependent on proprietary GUI tools and wizards, like Dreamweaver, to create your web-pages is very very bad, at least if you don't know what it is that is happening behind the scenes. You are basically limiting yourself to the features Adobe figures should be automated.

Making your code do whatever you want is easy. Making Dreamweaver do anything beyond the basics is next to impossible.