PHP MySQL Insert new rows from previous result

Question

I have a site for events and I'm trying to create a script that sends an alert to all members who are attending. This is done by selecting all of the members from the attendance table and adding a message for each of the resulting records. The code that I have at the moment is not working. Here is the code:

$get_attendance_sql = "SELECT attendee FROM attendance WHERE event = '$event_id'";
$get_attendance_res = mysqli_query($con, $get_attendance_sql);
while($row = mysqli_fetch_assoc($get_attendance_res)){
    $event_memberid = $row["attendee"];
}

foreach($row)
{
    $insert_membernote_sql = "INSERT INTO notes (id, recipient, type, subtype, link, date) VALUES('$id', '$event_memberid', 'cancel', 'event', '$event_id', '$time')";
    $insert_membernote_res = mysqli_query($con, $insert_membernote_sql);
}

Kumar V · Accepted Answer · 2014-01-04 11:01:09Z

2

Try this code.

You need to remove foreach and move insert query inside the while loop.

$get_attendance_sql = "SELECT attendee FROM attendance WHERE event = '$event_id'";
$get_attendance_res = mysqli_query($con, $get_attendance_sql);
while($row = mysqli_fetch_assoc($get_attendance_res)){
    $event_memberid = $row["attendee"];
    $insert_membernote_sql = "INSERT INTO notes (id, recipient, type, subtype, link, date) VALUES('$id', '$event_memberid', 'cancel', 'event', '$event_id', '$time')";
    $insert_membernote_res = mysqli_query($con, $insert_membernote_sql);
}

answered Jan 4, 2014 at 11:01

Kumar V

8,8289 gold badges44 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1844933 · Accepted Answer · 2014-01-04 11:01:21Z

2

Try this... you dont need another loop for insert, while fetching you can insert

$get_attendance_sql = "SELECT attendee FROM attendance WHERE event = '$event_id'";
$get_attendance_res = mysqli_query($con, $get_attendance_sql);
while($row = mysqli_fetch_assoc($get_attendance_res)){

$event_memberid = $row["attendee"];    
$insert_membernote_sql = "INSERT INTO notes (id, recipient, type, subtype, link, date)    VALUES('$id', '$event_memberid', 'cancel', 'event', '$event_id', '$time')";
    $insert_membernote_res = mysqli_query($con, $insert_membernote_sql);
}

answered Jan 4, 2014 at 11:01

user1844933

3,4132 gold badges28 silver badges44 bronze badges

Comments

Balaji Kandasamy · Accepted Answer · 2014-01-04 11:02:01Z

1

<?php
$get_attendance_sql = "SELECT attendee FROM attendance WHERE event = '$event_id'";
$get_attendance_res = mysqli_query($con, $get_attendance_sql);
while($row = mysqli_fetch_assoc($get_attendance_res)){
    $event_memberid[] = $row["attendee"];
}

foreach($event_memberid as $memberid )
{
    $insert_membernote_sql = "INSERT INTO notes (id, recipient, type, subtype, link, date) VALUES('$id', '$memberid', 'cancel', 'event', '$event_id', '$time')";
    $insert_membernote_res = mysqli_query($con, $insert_membernote_sql);
}
?>

answered Jan 4, 2014 at 11:02

Balaji Kandasamy

4,50410 gold badges42 silver badges58 bronze badges

Collectives™ on Stack Overflow

PHP MySQL Insert new rows from previous result

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related