Please HELP!!!! PHP + MySQL Problem

[ncalenti]

So here is what I am trying to do but I have no clue how to go about it.  Any help appreciated.

 

I have a large table (more than 300 entries) with one of the fields called 'UPC'

So what I want to do is:

Get the first 10 UPC values

make a string of them separated by commas

execute a function with this string

Get the next 10 UPC values

execute the same function with that string

Continue until all the UPC values in the table have been used.

 

-Thanks

[Barand]

try

<?php
$sql = 'SELECT unc FROM mytable';
$res = mysql_query($sql) or die (mysql_error()."<p>$sql</p>");
while ($row = mysql_fetch_row($res)) {
    $data[] = $row[0];
}

$ar = array_chunk($data,10);

foreach ($ar as $chunk) {
    $str = join(',', $chunk);
    
    // call your_function($str)
    echo $str,'<br>';
}
?>