PHP - Spliting Two Numbers

right now my array is set up so the title of the picture (which is a number) is the key and the keyword or words associated with that picture are the values separated by commas:
Code: [Select]
Array(
    [1.jpg] => Tyler
    [10.jpg] => Callum
    [11.jpg] => Callum
    [12.jpg] => Adam
    [13.jpg] => Justin
    [14.jpg] => Shane
    [15.jpg] => Callum,Grant
    [16.jpg] => Justin
    [17.jpg] => Justin
    [18.jpg] => Austin
    [19.jpg] => Jarod
    [2.jpg] => Tyler
    [20.jpg] => Austin
    [21.jpg] => Tyler
    [22.jpg] => Justin
    [23.jpg] => Tyler
    [24.jpg] => Jarod
    [3.jpg] => Callum
    [4.jpg] => Shane,Callum
    [5.jpg] => Adin
    [6.jpg] => Justin
    [7.jpg] => Callum
    [8.jpg] => Adam
    [9.jpg] => Callum
    [25.jpg] => Jarod
)
im using the galleriffic jquery photo album and in the description area for the picture it shows the keywords in a hyperlink to another page were it shows all the pictures with that keyword but what i want is for when their are multiple keywords i want them to show up as separate hyperlinks

I am trying to split large csv file into manageable files to upload to database, I wrote this code and it does the job but I need to speed it up to get around the 30 second time out in php can anyone help?
Code: [Select]
<?php
$files = glob('*.txt');
foreach ($files as $file) {
$handle1 = fopen($file, "r");
$size = filesize($file);
if($size > 20000000){
$line=1;
$handle2 = fopen($line.$file, "w");
while (($data = fgetcsv($handle1, 10000, ",")) !== FALSE)
{
    $row = ($data[0]."[,]".$data[1]."[,]".$data[2]."[,]".$data[3]."[,]".$data[4]."[,]".$data[5]."[,]".$data[6]."[,]".$data[7]."[,]".$data[8]."[,]".$data[9]."[,]".$data[10]."[,]".$data[11]."[,]".$data[12]."[,]".$data[13]."[,]".$data[14]."[,]".$data[15]."[,]".$data[16]."[,]".$data[17]."[,]".$data[18]."[,]".$data[19]."[,]".$data[20]."[,]".$data[21]."[,]".$data[22]."[,]".$data[23]."[,]".$data[24]."[,]".$data[25]."[,]".$data[26]."[,]".$data[27]."[,]".$data[28]."[,]".$data[29]."[,]".$data[30]."[,]".$data[31]."[,]".$data[32]."[,]".$data[33]."[,]".$data[34]."[,]".$data[35]."[,]".$data[36]."[,]".$data[37]."[,]".$data[38]."[,]".$data[39]."[,]".$data[40]);
    if(strlen($row)>10)
    {
        $row = str_replace('"','',$row);
        $row = explode("[,]", $row);
        fputcsv($handle2, $row);
$line++;

if($line == 100000){
$handle2 = fopen($line.$file, "w");

}

if ($line == 200000){
$handle2 = fopen($line.$file, "w");

     }
if ($line == 300000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 400000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 500000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 600000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 700000){
$handle2 = fopen($line.$file, "w");

     }
if($line == 800000){
$handle2 = fopen($line.$file, "w");

}

if ($line == 900000){
$handle2 = fopen($line.$file, "w");

     }
if ($line == 1000000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 1100000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 1200000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 1300000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 1400000){
$handle2 = fopen($line.$file, "w");

     }
if ($line == 1500000){
$handle2 = fopen($line.$file, "w");

}

if ($line == 1600000){
$handle2 = fopen($line.$file, "w");

     }
if ($line == 1700000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 1800000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 1900000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 2000000){
$handle2 = fopen($line.$file, "w");

     }

if ($line == 2100000){
$handle2 = fopen($line.$file, "w");

     }
}
}
}
}
fclose($handle1);
fclose($handle2);
?>Thanks everyone

I have been working on a way to split my data into 2 columns as a way to make the page shorter and easier to read. I have been able get it to split like this

1 2
3 4
5 6

But I would rather it go like this, because it would be easier on the eyes.

1 4
2 5
3 6

This is what I have now, I have no idea if I'm even on the right track.
Code: [Select]
  <?php
include"scripts/connect.php" ;

mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM movies WHERE type LIKE 'tv' ORDER BY title";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table width="70%" align="left">
 
<?php
$i=0;
while ($i < $num/2)
 {

$title=mysql_result($result,$i,"title");

?>
<tr>
<td><a class="nav" href=/show.php?title=<?php echo urlencode($title); ?>><?php echo $title; ?></td>



<?php
while ($i >= $num/2)
 {
?>

<td><a class="nav" href=/show.php?title=<?php echo urlencode($title); ?>><?php echo $title; ?></td>
</tr>


<?php
}
$i++;

}

?>
</table>

This will show only the first half of the titles.

Thanks in advance.

hi everyone,

i just signed up on this forum. I have issue, my clients wants to save time by copying data into a textarea and then letting the script process it and store it in database.

the problem is never done that. the data is made up for eg.

Title   Mr
Name   Radio86
Address  Chiltren House
etc....

how do i split this data up and store it in database, btw ive just started programming in php in other words newbie

Please help me, thanks in advance

Hi,
I need to sort variables in groups of up to 15 and put it in an array. For example:
$exstract['center_tabOpBody_0'] =5
$exstract['center_tabOpBody_1'] =6
$exstract['center_tabOpBody_2'] =8
$exstract['center_tabOpBody_3'] =1


Should yield:
ARRAY(
          = center_tabOpBody_1,center_tabOpBody_2,center_tabOpBody_3 // <-----15 [1] = center_tabOpBody_0 //<----5
)

Is there some simple function do do the "efficiency" sort?

Thanks,
Vadim