sql problems...

[Sobbs]

Ive done that, however, im still seing no error messages.

<?php
ini_set ("display_errors", "1");
error_reporting(E_ALL);

$con = mysql_connect("sql312.byethost33.com","b33_3176976","n00b1234");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }else{
echo "Connected to DB";
}

$db = mysql_select_db("b33_3176976_lunadb", $con);
if (!$db)
  {
  die('Could not connect: ' . mysql_error());
  }else{
echo "DB selected";
}

if (!mysql_query("INSERT INTO `DB_Guide` (`gid`, `uname`, `gname`, `icon`, `dsc`, `cat`, `body`, `score`) VALUES (NULL, 'test', 'test', 'test', 'test', '1', 'test', '0')")) {
  echo mysql_error();
} else {
  echo "success";
}
?>

[Ninjakreborn]

Ok do this.

Clear out all your code (back it up first and try this.

echo 'hello';

Tell us if it outputs hello.

If not try

phpinfo();

and tell us if that outputs.

 

If none of that works then there is something wrong with your server configuration, ini file, or something that is preventing PHP pages from running.

[Sobbs]

Those do work. I tried running my code on another server and I had the same results. No errors, and nothing added.

[redarrow]

echo the insert statement out then.

[Sobbs]

echo the insert statement out then.

What do you mean by that?

[Ninjakreborn]

There are no syntax errors. I just ran your code.  Most likely your INI file or server are setup to not show error messages so when you start it up it runs a problem at the very start.

I am almost sure it's you database connection information.

Have you verified your username, password, and host information are all accurate based off of your webhost.

Have you also verified the DB name as well.

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'sql312.byethost33.com' (10060) in C:\xampp\htdocs\test.php on line 5
Could not connect: Can't connect to MySQL server on 'sql312.byethost33.com' (10060)

That is my response when I run the code so there are no abnormal syntax errors or strange output errors. It's simply a connection error. If your connection information is wrong then that could be causing the blank page.

[redarrow]

businessman has asked you, can you echo the hello you said yes.

 

That means that you php server is working because the page is phasing throw php.

 

now business man cheeked your code and it working his end.

 

He gone over your code with a tooth brush and come to the conclusion,

it a database connectivity problam.

 

The reason for no errors can be a setting in the php.ini or the database schema.

 

Is there a virus on the machine? just asking.

[Ninjakreborn]

I am signing off for the time being.

If you are unable to figure this out then PM me the login information to the site..the name of the page and a link.  When that happens I will go ahead and try to work you through it manually if you are still having problems.

 

Only PM me if you have tried everything else and no-one is able to help you work through it yourself.