Jump to content

Unwanted duplication in Array


facarroll

Recommended Posts

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.

 

<?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";              
}
?>

Link to comment
https://forums.phpfreaks.com/topic/216699-unwanted-duplication-in-array/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.