/home/desid573/public_html
Edit: /home/desid573/public_html/sendtofamily.php (1153B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$result = mysqli_query($conn, "SELECT * FROM booking WHERE booking_date > NOW() AND type = 'FA'");
if(!$result) {
echo $conn->error;
}
while($row = mysqli_fetch_assoc($result)){
$quote = $row["quote"];
if($quote > 90) {
$quote = $quote + 10;
} else {
$quote = $quote / 9 * 10;
}
$quote = number_format($quote, 2);
$result2 = mysqli_query($conn, "UPDATE booking SET quote = '".$quote."' WHERE id = ".$row["id"]);
if(!$result2) {
echo $conn->error;
}
}
?>