Database Connection should be.......
$con = mysql_connect("localhost","root","");
or
$con = mysql_connect('localhost','bcheight_textmon','fadjflka');
if(!$con)
{
die('Could not connect: '.mysql_error());
}
mysql_select_db("bcheight_text",$con); --> plz look at this line u didn't connect to the DB...
and u can follow this one......
$sql_query = mysql_query("SELECT promoters.username, promoter_sales.package_sold FROM promoters, promoter_sales WHERE promoters.username = promoter_sales.username");
while($row = mysql_fetch_array($sql_query))
{
$sold_date = $row['date_sold'];
$sold_package = $row['package_sold'];
echo "Sold Date: " . $sold_date . "Package Sold: " . $sold_package . "
";
}
Have a nice day