Adding data to sql

[Anon]

<?php

if ($submit) {

    $link = mysql_connect("localhost", "", "") or

die("Could Not Connect To Database");
$db = mysql_select_db("db",$link) or die(mysql_error());
$sql = "INSERT INTO employees (cname,password,address,city,state,zip,phone,service,nbd,amd) VALUES
('$cname','$password','$address','$city','$state','$zip','$phone','$nbd','$amd')";
$result = mysql_query($sql);
echo "<center>Infomation successufly added to database";
}
?>

Well when i click submit on the form it says "informaton succesfully added to database" but of course, no it isin't any ideas??
Thanks
Anthony

[kid_c]

you could try this:

• remove your mysql_select_db line totally.
• $result = mysql_db_query("db",$sql,$link);
• echo mysql_error(); after $result line

that should either solve the problem or help you see what it is =)

--
Keith Bussey
[e-mail]
Programmer - WISOL.com
[phone] ext. 225