PHP + MySQL Database Connecting

Anon

I have a problem connecting to a MySQL database, my knowledge of both PHP and Databases is very thin on the ground, I have set things up as simple as possible just so I can get my head aroud it, and have spoken to my host on a number of occasions without much help, to explain:

I have no Telnet Access to the MySQL Database server, I access it via a Control Panel.
I have named the database employees and it only holds 4 records (number 4 is me)

Control Panel Help Files say;
To access mySQL via your web pages, connect to the mySQL server using the following credentials.

Parameter Value
+++++++++ +++++
Username: The account's username

Password: The account's main password

Database: The account's username

Server: localhost
++++++++++++++++++++++++++++++++++++++++++

This is just a test account I have created, the details are here.
Username: nationwidetest
Password: simple

Here is the source code I am trying to connect to the database with, which is in my root folder.

<head>
<title>MySQL Database</title>
</head>
<body>
<?php

$db = mysql_connect ("localhost","root","nationwidetest","simple","nationwidetest");

mysql_select_db ("employees",$db);

$result = mysql_query("SELECT * FROM employees");

printf("First Name: %s<br>\n", mysql_result($result,0,"first"));

printf("Last Name: %s<br>\n", mysql_result($result,0,"last"));

printf("Address: %s<br>\n", mysql_result($result,0,"address"));

printf("Position: %s<br>\n", mysql_result($result,0,"position"));

?>
</body>

Anon

Sorry I forgot to post the URL:
http://test.nationwidehosting.co.uk/test.php

Anon

u got to create a table first i tink...well to create ,im having problem wit MySQL Databases so i dont know much about the tags but i know it start like CREATE TABLE tablename then blah blah blah

Anon

$db = mysql_connect ("localhost","root","nationwidetest","simple","nationwidetest");

What's that fourth argument for? The fourth argument should be a boolean if you want to use it, but you'd rarely use it...

Diego

Anon

Hi Randy, the table/database is already alraedy created, its called employees ?

Anon

Hi Diego

I dont know why I have put the 4th argument there, but thats what I'm tring to find out, I have just removed and tried the the page, this is the result...

Warning: Wrong parameter count for mysql_connect() in /usr/home/n/a/nationwidetest/public_html/test.php on line 8

Warning: Supplied argument is not a valid MySQL-Link resource in /usr/home/n/a/nationwidetest/public_html/test.php on line 10

Warning: Supplied argument is not a valid MySQL-Link resource in /usr/home/n/a/nationwidetest/public_html/test.php on line 12

Warning: Supplied argument is not a valid MySQL result resource in /usr/home/n/a/nationwidetest/public_html/test.php on line 15
First Name:

Warning: Supplied argument is not a valid MySQL result resource in /usr/home/n/a/nationwidetest/public_html/test.php on line 17
Last Name:

Warning: Supplied argument is not a valid MySQL result resource in /usr/home/n/a/nationwidetest/public_html/test.php on line 19
Address:

Warning: Supplied argument is not a valid MySQL result resource in /usr/home/n/a/nationwidetest/public_html/test.php on line 21
Position:

It was worse than this before....

Anon

---------- MySQL dump ----------

Table structure for table 'employees'

#
CREATE TABLE employees (
id tinyint(4) DEFAULT '' NOT NULL auto_increment,
first varchar(20) ,
last varchar(20) ,
address varchar(255) ,
position varchar(50) ,
PRIMARY KEY (id),
UNIQUE id (id)
);

Dumping data for table 'employees'

INSERT INTO employees VALUES('3','Brad','Johnson','1/34 Nowhere Blvd, Snowston','Doorman');
INSERT INTO employees VALUES('2','John','Roberts','45 There St, Townville','Telephonist');
INSERT INTO employees VALUES('1','Bob','Smith','128 Here St, Cityname','Marketing Manager');
INSERT INTO employees VALUES('4','Peter','Errington','10 Garden Street, Tyldesley','Web Designer');

----------- Dump ends -----------