session_start();
ob_start();
require("Cart.php");
DBinfo();
Brand();
Root();
$title="BuyerID Update";
// include("masthead.php");
$result=mysql("reminders","SELECT email FROM myNotify");
while ($row = mysql_fetch_row($result)) {
$email=$row[0];
echo "
$email
";
// $link=mysql_connect("bizshop.securesites.com","bizshop","vasia") or die("Could Not Connect");
// $link2=mysql_select_db("Cart") or die("Could not select database");
$result2=mysql("Cart","SELECT BuyerID FROM Buyers where Email='$email'");
$num_rows = mysql_num_rows($result2);
echo "NumRows $num_rows
";
if ($num_rows>='1'){
echo "SELECT BuyerID FROM Buyers where Email='$email'";
while ($row2 = mysql_fetch_row($result2)) {
$BuyerID=$row2[0];
echo "
BuyerID $BuyerID
"; } } else { $BuyerID='0'; } // $link=mysql_connect("bizshop.com","bizshop","anjin9435") or die("Could Not Connect"); $buy=mysql("reminders","Update myNotify Set BuyerID='$BuyerID' where email='$email'"); }