PHP Code:
$con = mysql_connect("localhost","user1","password") or die("Cannot connect");
mysql_select_db("pmonty7_dsd", $con) or die("Cannot select database");
$query = "SELECT * FROM randquote ORDER BY Rand() LIMIT 1";
$result = mysql_query($query,$con) or die("Result Query Error");
while($rows = mysql_fetch_array($result))
{
echo $rows['quote'] . " " . $rows['LastName'];
echo "<br />";
}
mysql_close($con);
I am getting the die message "Cannot select database"
I have no idea host is all workign fine and so is phpmyadmin and so on. But cant figure it out. also the name and table name are 100% correct.
Any idea guys?