database connectivity problem

[mscoder]

I used the following code for inserting form data into "userinfo" table of "user" database.The database and table was created on xampp(phpmyadmin).But the page displayed "Error: No database selected".... why?pls help..


<?php
$con = mysql_connect("localhost","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("user",$con);

$sql="INSERT INTO userinfo(id,pass)
VALUES
('$_POST[UID]','$_POST[pass]')";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";

mysql_close($con);
?>

[NogDog]

Put a test on the result of mysql_select_db() and make sure it's working.

(PS: Modern PHP apps should really be using either the MySQLi or PDO extension to interface with MySQL.)

[mscoder]

ok..i put the check on "mysql_select_db" and its not working...what can i do for it now??

[NogDog]

What is the error? (You can use mysql_error() there just like for any other db error.)

[daviddivine]

Okay, try something like this:
CODE:
<?php
$con = mysql_connect("localhost","","");
mysql_select_db("user",$con);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$sql="INSERT INTO userinfo(id,pass)
VALUES
('$_POST[UID]','$_POST[pass]')";
$query = mysql_query($sql,$con)
if (!$query)
{
die('Error: ' . mysql_error());
}
echo "1 record added";

mysql_close($con);
?>