query($sql4)==true){
// $sql = "INSERT INTO resolvedquery (`name`,`email`,`number`,`status`) VALUES ('')";
// echo "";
// }
// }
?>
query($sqlFetch);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
$name = $row['name'];
$email = $row['email'];
$number = $row['number'];
// Update the query status to resolved
$sqlUpdate = "UPDATE query SET `status` = 1 WHERE `id` = $id";
if ($conn->query($sqlUpdate) === true) {
// Insert into resolvedquery table
$sqlInsert = "INSERT INTO resolvedquery (`name`, `email`, `number`, `status`)
VALUES ('$name', '$email', '$number', 1)";
if ($conn->query($sqlInsert) === true) {
echo "";
} else {
echo "Error: " . $conn->error;
}
} else {
echo "Error updating query status: " . $conn->error;
}
} else {
echo "";
}
}
?>