MySQL INSERT QUERY

[Nickosssss]

Hello
i am trying to automate an Insert command but i need to limit it to a number stored on an array

for example:

"insert into staff_stud_alloc SELECT top_stud.stud_id, top_stud.staff_id, top_stud.top_id
from top_stud, topic, student, staff, top_staff
where
student.stud_id = top_stud.stud_id and......

												level = 'a' and top_pref = '1' limit '$row2[$j]'";

if i use normal variables like 1,2 it works....but does not work on that....

does anybody know how to do it?

thanks

[rachel2004]

Nickosssss wrote:

for example:

"insert into staff_stud_alloc SELECT top_stud.stud_id, top_stud.staff_id, top_stud.top_id
from top_stud, topic, student, staff, top_staff
where
student.stud_id = top_stud.stud_id and......

First, it helps if you show the whole SQL statement.

if i use normal variables like 1,2 it works....but does not work on that....

Yes, an INSERT...SELECT in MySQL will work if you hard-code the values as
LIMIT 1,2
So are you saying that if you use variables that it does not work as in the following:

$a = 1;
$b = 2;
$sql = "INSERT INTO Table1 (col1, col2) SELECT t.col1, t.col2 FROM Table2 AS t LIMIT ".$a.", ".$b;

Have you tried to 'echo' the value of your SQL statement to see what it looks like to MySQL?

[Nickosssss]

thanks mate...i worked out a solution and it works🙂