PHP - Line Duplication

Hi    I am reading in data from a csv file

if (($handle = fopen("data.csv", "r")) !== FALSE) {

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

echo "User Name: $data[0]";
echo "Booking IDs: $data[1]";

}

echo "<hr>";

The problem is some of the usernames are duplicated so get outputted the same user name 20 times but with different IDs, obviously but I am unsure how to group them together.    I can't seem to figure out how to write if the next username is the same as current then just add another ID not go through the entire loop.    Any ideas?   Thanks  

As part of an image gallery I am trying to INSERT data into a table to make accessible the relevant info of individual images - the problem I have encountered is that each query seems to be being inserted twice, and I can't figure out why. The code =

Code: [Select]
<?php

/*==============================================
Connect to MySQL and select the correct database
==============================================*/
mysql_connect("localhost", "uname", "pwd") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("gallery_db") or die(mysql_error());
echo "Connected to Database gallery_db.<br />";

/*=============================================
Include the files needed to undertake this task
=============================================*/
include("functions.php");

/*=========================
Set up arrays and variables
=========================*/
$store = array();
$exif = array();

$folder = "./images/";
$insrt = 'INSERT INTO images VALUES (img_id, ';
$file_name = '';
$file_location ='';
$copyright ='';
$caption = '';
$file_date = '';
$file_time = '';
$camera = '';
$speed = '';
$fNo = '';
$ISO = '';

/*=================================
Open folder and read relevant files
=================================*/
if ($handle = opendir('./images')) {
    while (false !== ($file = readdir($handle))) {
        if ($file != "." && $file != "..") {

          $file_name = $file;  //>>> File Name <<<
          $file_location = $folder . $file;     //>>> File Location <<<

          $exif = exif_read_data($file_location, 'EXIF');   //>>> Read exif data <<<

          /*==============================================================
          Check if the 'Copyright' info existe in the exif data, and if it
          doesn't set the $copyright variable to the relevant value.
          ==============================================================*/
          if (array_key_exists('Copyright', $exif)) {
          $copyright = $exif['Copyright'];
      }
        else {
          $copyright = "copy name";
        }

        $caption = $exif['COMMENT'][0];     //>>> Get the Caption <<<

        //>>> Re-format DateTime into separate date and time var's $file_date & $file_time <<<
        $temp = substr($exif['DateTime'], 0, 10);
        $file_date = substr($temp, 8, 2) . substr($temp, 4, 4) . substr($temp, 0, 4);
        $file_time = substr($exif['DateTime'], 11, 8);
        //>>> Set the rest of the variables <<<
        $camera = $exif['Model'];   //>>> Get the camera make and model <<<
        $speed = $exif['ExposureTime'];     //>>> Get the shutter speed <<<
        $fNo = $exif['COMPUTED']['ApertureFNumber'];    //>>> Get the f No. <<<
        $ISO = $exif['ISOSpeedRatings'];        //>>> Get the ISO rating <<<

        //>>> Fill the $store[] array with the relevant bits for each seperate query <<<
        $store[] = $insrt . "'" .
        $file_name . "', " . "'" .
        $file_location . "', " . "'" .
        $copyright . "', " . "'" .
        $caption . "', " . "'" .
        $file_date . "', " . "'" .
        $file_time . "', " . "'" .
        $camera . "', " . "'" .
        $speed . "', " . "'" .
        $fNo . "', " . "'" .
        $ISO . "')";

        }
    }
    closedir($handle);
}

/*=============================================================================
Get individual queries from $store[] and INSERT INTO images the relevant VALUES
=============================================================================*/
$num_queries = count($store);       //>>> Check the number of queries in the array $store
$loop = 0;      //>>> Starting point for query No. bearing in mind that array keys are numbered from zero

while ($loop <= $num_queries - 1) {
  $query = $store[$loop];

  if (!mysql_query($query)){
    die('Error: ' . mysql_error());
 }

mysql_query($query);

  $loop++;
}

?>
I know it's not pretty, but that can be attended to once working properly. I am quite sure that it will be a very simple solution, probably so simple that I haven't even thought of it.

I've recently had a problem with my admin site where PHP sessions, which are stored in a MySQL database, are duplicating and causing the page to return to the login screen.  Usually the site works fine in Firefox, but stops working in IE and Safari.  This problem suddenly appeared over night with no change to the files. 

Due to the amount of code, I'm reluctant to post it all, but does anyone have a suggestion on why this could be happening and how to solve it? 

<?php
 // Daniel URL duplicator.
 // Input links list.
 $linksList = "links.txt";
 // How many times to duplicate the url?
 $manyTimes = 1000;
 // Read in the list.
 for ($x = 0; $x <= $manyTimes; $x++)
 {
  $handle = fopen($linksList, "r");
  $line = fgets($handle);
  echo $line;
  fclose($handle);
 }
?>

Hey Guys,   I'm stuck on this simple bit of code lol what I'm trying to do is load in a list of urls:   site1.com site2.com site3.com etc   For each site that is read, I'm trying to duplicate it X times, above would print to screen the same url 1000 times, then move onto the next print it 1000 times etc until the list is done (or how ever many times I select)   I can't think of the best way to do it!   any help would be appreciated guys!   Graham        

Hi everyone,
I don't know whether this is a PHP or MySql problem, but I think it is the former. The following code queries the database correctly, (and before you ask, there are no duplicate database entries), but the output duplicates every row. e.g.,

hammer (jpg image)
hammer
hammer (jpg image)
hammer
saw (jpg image)
saw
saw (jpg image)
saw
screwdriver (jpg image)
screwdriver
screwdriver (jpg image)
screwdriver

and so on.
I cannot see why the code causes the row to repeat.

Code: [Select]
<?php session_start(); 
if (isset($_SESSION['id'])) 
{
// Put stored session variables into local php variable
     $id   = $_SESSION['id'];
     $userId = $_SESSION['userId'];
$userGroup = $_SESSION['userGroup'];
$managerId = $_SESSION['managerId'];
}
include_once("demo_conn.php"); 
$sql = mysql_query("SELECT * FROM users WHERE id='$id'"); 
while($row = mysql_fetch_array($sql))
    { 
        // Get member data into a session variable
        $egroup = $row["egroup"];   
        session_register('egroup'); 
        $_SESSION['egroup'] = $egroup;
}   
$query = mysql_query("SELECT topics.url_big, topics.url_small, topics.title, topics.$egroup, quiz.passState, quiz.userDate FROM topics INNER JOIN quiz ON (topics.managerId = quiz.managerId) WHERE topics.$egroup = 1 ORDER BY title ASC"); 
while ($row1 = mysql_fetch_array($query))
{
 echo "<a href='../../wood/wood_tool_images/{$row1['url_big']}' target='_blank'><img src='../../wood/wood_tool_images/{$row1['url_small']}' /><br />\n"; 
 echo "{$row1['title']} <br />\n";              
}
?>