Can not insert data

[Anon]

Does any body know how to do this?

How can I insert the results of this:

$sql = "select distinct * from customer order by Rand() limit 12";
$namo = mysql_query($sql);
$r = mysql_fetch_array($namo);

into a table with 12 rows and 3 clomuns.

This does not work:

$winsome = "INSERT INTO win (custid,winit,win_time) VALUES ('$r[custid]','$r[winit]','$r[winit]')";
$result = mysql_query($winsome);

Thank You.

[amcgrath]

Your not looping through the result set:

while($r = = mysql_fetch_array($namo)) {

// query stuff

}

[Anon]

Hey! That works . . .

Thank you very much.

[amcgrath]

You're welcome, sorray about the double '= =' i guess you overlooked it... 😉