php multiple insert help

[kontrol]

i have been trying to do this multiple insert but does not get it right

PHP Code:

<?php
$sql = "SELECT * FROM table1 WHERE id IN ('$s_id')";
$result = mysql_query($sql) or die (mysql_error());
$msg = "hello world";
while($feed = mysql_fetch_array($result));
      {
      $id[] = $feed['id'];
      $user_id[] = $feed['user_id'];
      $notice = "INSERT INTO table2 (user_id, msg) VALUES ('$user_id, '$msg')";
      $notify = mysql_query($notice) or die (mysql_error());
      }

i want get it in such a way that
if $user_id contains 1,2,3,4 then this should be how the data should be inserted
id user_id msg
1 1 hello world
2 2 hello world
3 3 hello world
4 4 hello world

[kontrol]

the user_id can not be in ascending order because it could be any user that is why i made an array to fetch the users' id. that one you saw there is just a scenario

[Rukbat]

I assume you set $s_id properly somewhere before this code. Tell us what is happening, not what's not happening. "does not get it right" isn't enough to tell us what's happening. (Are you using FirePHP to see what the code is doing, line by line?)

[JohnnyS]

Originally Posted by kontrol

i have been trying to do this multiple insert but does not get it right

PHP Code:

<?php
$sql = "SELECT * FROM table1 WHERE id IN ('$s_id')";
$result = mysql_query($sql) or die (mysql_error());
$msg = "hello world";
while($feed = mysql_fetch_array($result));
      {
      $id[] = $feed['id'];
      $user_id[] = $feed['user_id'];
      $notice = "INSERT INTO table2 (user_id, msg) VALUES ('$user_id, '$msg')";
      $notify = mysql_query($notice) or die (mysql_error());
      }

i want get it in such a way that
if $user_id contains 1,2,3,4 then this should be how the data should be inserted
id user_id msg
1 1 hello world
2 2 hello world
3 3 hello world
4 4 hello world

$user_id is an array, why are you using it as a value to insert..

try to echo each of your INSERT query.. that will help you know what is happening..

[Defrag]

You're on the right track; you just need to use the raw user ID coming from the first mysql_fetch_array instead of using the $user_id variable, which will create an populate an array of those user ID's.

PHP Code:

<?php 
    $sql = "SELECT * FROM table1 WHERE id IN ('$s_id')"; 
    $result = mysql_query($sql) or die (mysql_error()); 
    $msg = "hello world"; 
    while($feed = mysql_fetch_array($result)) { 
      $id[] = $feed['id']; 
      $user_id[] = $feed['user_id']; 
      $notice = "INSERT INTO table2 (user_id, msg) VALUES ('{$feed['user_id']}', '$msg')"; 
      $notify = mysql_query($notice) or die (mysql_error()); 
    }
?>

You don't really need the $id or $user_id variables unless you're storing them for later use.

[kontrol]

thank you my people. i used implode function and its cool.