hi i will try that do i copy all that and save that as scub.php

also what you mean define $body

find out where is the problem:

PHP Code:

mysql_connect (DB_HOST , DB_USER, DB_PASSWORD) or die("Connection Err:".mysql_error());
mysql_select_db (DB_NAME)  or die("DB Selection Err:".mysql_error()); 


done that this hat i get

DB Selection Err:Access denied for user 'ekcab'@'localhost' to database 'usertable'

that means you don't have access to that database. replace current username password with the correct one.

posted by mistake opss

ok i gone onto cpanel creat and new user called ekcab and a new password this is the code i have
<?
define ('DB_USER', 'ekcab');
define ('DB_PASSWORD', '*****');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'ekcab_usertable');

$adb = mysql_connect (DB_HOST , DB_USER, DB_PASSWORD) or die("Connection Err:".mysql_error());
mysql_select_db (DB_NAME) or die("DB Selection Err:".mysql_error());

$fullname = $_POST["textfield"];
$email = $_POST["textfield2"];
$sql = "INSERT INTO ekcab_usertable (fullname, email) VALUES ('$fullname', '$email')";
mysql_query($sql);
?>
and i get this

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ekcab'@'localhost' (using password: YES) in /home/ekcab/public_html/scub.php on line 16
Connection Err:Access denied for user 'ekcab'@'localhost' (using password: YES)

Why use constants it can cause more problems than what it's worth, you must always check they are not defined, since you can't redefine a constant.

Anyways, from your screenshot your username was ekcab_info not ekcab.

Cheers,

MC

yeah i know i changed it it jsu anoying me as i cant finish rest site off with out knowing this wont work

You havent added user to the database. As long as that screen hasn't changed all you need to do is add user to database!

hi mad what you mean im not very good with php have small knolage of it

Click the button circled in screenshot.

yeha ive now done that mate it still dont want to work

Follow this tutorial.

If you aquire some knowledge of php, you may be able to exp[lain your problem better.

i do have basic knolage of php the problem is it dont seem to want connect to the database and put the informaiton in

Try this and tell me what you get.

PHP Code:

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

EDIT:
I think I've cracked your problem:

If above gets Could not connect: Access denied for user 'ekcab'@'66.118.142.108' (using password: YES) in /home/ekcab/public_html/scub.php on line 19

Use the username ecab_info not ekcab.

BEFORE I TRY THAT THIS IS THE LATEST CODE I HAVE AND THE LATEST ERROR I HAVE AS WHERE IVE BEEN MESSING ABOUT IVE CHANGED USERNAME AND PASSWORD SO ON


<?PHP

$dbh=mysql_connect ("localhost", "eKcab_admin", "<PASSWORD IS HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("ekcab_usertable");

$fullname = $_POST["textfield"];
$email = $_POST["textfield2"];
$sql = "INSERT INTO ekcab_usertable (fullname, email) VALUES ('$fullname', '$email')";
mysql_query($sql);
?>

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ekcab_admin'@'localhost' (using password: YES) in /home/ekcab/public_html/scub.php on line 12
I cannot connect to the database because: Access denied for user 'ekcab_admin'@'localhost' (using password: YES)

Honestly mate, unless you have the passowrd wrong, the user IS NOT in the database or else you would not have that error. Adding a user does not make it have access to database - although if you had added it to mysql but not to databse you would be able to connect but not select db.

Secondly try using a free database like http://freesql.org/freesql/mysql just to prove my point that THE USER HAS NOT BEEN ADDED/OR THE PASSWORD IS WRONG!

Hope this helps!

if i gave u my log in details would u have a look at for me please as it kinder holding everythink up as this script on every page dont want do rest page and find i got change sumthink if so have u got msn so i can add u and that many thanks

You can add me on msn if you like and i will help you from there. - mad_willsy@backthebulls.com

I will be on saturday and sunday from about 3AM GMT till 9PM GMT

EDIT:
Exactly what I said was wrong!

Talkupation please! :P