can't write to a database...using godaddy hosting...

[spewn]

i'm trying to store info in a database. i'm running perl and the script executes fine, no problems.

the issue i'm having is the info is not being stored in the database i've created, but no errors show.

i'm using go daddy hosting, (first time), and am not too familiar with it.

$drh = DBI->install_driver("mysql");

$dsn ="DBI:mysql:database=top_clients;host=h71mysql17.secureserver.net";

$dbh = DBI->connect($dsn,"top_clients","myPass") or die "no db!";

$sth = $dbh->prepare("INSERT INTO my-clients VALUES(0,'$uname','$newPhone','$uemail','$usubject','$umessage','$ustatus','$theFullTimeIs','$theDateIs','$uip')");
$sth->execute;

everyting except my password is exactly how it appears.

is there a simple way to test the connection?

thanks for any help.

- g

 

[travs69]

Well if it doesn't error on the connect line you are getting your connection.

Do a select * from my-clients and see what it says.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those Who Say It Cannot Be Done Are Usually Interrupted by Someone Else Doing It; Give the wrong symptoms, get the wrong solutions;

 

[spewn]

i'm getting the connection. i tried the *, no dice.

i've even added the actual login and pass instead of the variable, and still nothing.

any ideas?

- g

 

[spewn]

wow. i missed the ` on the db table.

thanks for all the help.

- g