$notice = "SELECT id FROM notification
WHERE noti_user ='Pro'";
$noticeqry = mysqli_query($con, $notice);
$sql = "INSERT INTO `user_notification` (`notif_id`, `user_id`)
values while($noticerow = mysqli_fetch_array($noticeqry)){("$noticerow['id']", "$univuid"}";
$query= mysqli_query($con,$sql);
Not working and getting error Parse error: syntax error, the unexpected variable "$noticerow"
1 Replies
Maybe you can try insert through for loop, like this:
$notice = "SELECT id FROM notification WHERE noti_user ='Pro'";
$noticeqry = mysqli_query($con, $notice);
$row = $noticeqry->fetch_assoc();
$count_id = mysqli_num_rows($noticeqry);
for($i=0; $i < $count_id; $i++){
$noticerow = $row['id'][$i];
$sql = "INSERT INTO `user_notification` (`notif_id`, `user_id`) values ('$noticerow', '$univuid')";
$query= mysqli_query($con,$sql);
}
if($query) {
echo "New record created successfully";
} else {
echo "Error: " .