Display issue

[Lynne]

Sorry, but I'm terrible with mysql query type issues and I think that is where the problem is. Looking at your code, each time you go through the loop, you only assign one of the screenshots to a variable. So, you can only expect it to spit out one. Then, you go through it again, and I think it is adding to it, so you can get the second one (I'm guessing). What you need to do is get each file and then all the screenshots associated with it as an array (I think? I'm not sure). Right now you aren't allowing for two screenshots (or more) per file.

This just isn't my area of expertise, sorry. It's one of those types of problems I would have to brute force code.

[Excalibur82]

Well I have some code from sending a PM to multiple users. I'll see if I can't manipulate that code to work similar for this problem.

If any other suggestions come about I'm open to them though.

--------------- Added [DATE]1239144085[/DATE] at [TIME]1239144085[/TIME] ---------------

Looks like I have failed again. My idea didn't work and so I think I'm gonna have to do a case situation.

Hell I don't know, any ideas? Anyone?

[Dismounted]

Could you post the content of the two templates used in the loop?

[Excalibur82]

This is the file display loop template:

$display_bit below

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
	<td class="alt2">
		<div class="smallfont" align="left">File: $name</div>
			<div valign="top">
			<fieldset class="statistics_group" style="float: right;">
				<legend>Options</legend>
				<ul class="list_no_decoration">
				<li><span class="shade"><a href="download.php?id=$id">Download</a></span></li>
				<li><span class="shade">Size: $bytes</span></li>
				<if condition="$bbuserinfo[userid] == $userid">
				<li><span class="shade">Delete</span></li>
				<li><span class="shade">Edit</span></li>
				<li><a href="download.php?do=screen&id=$id">Add Screenshot</a></li>
				</if>
				<li><span class="shade">Uploaded by: <a href="member.php?u=$userid">$username</a></span></li>
				</ul>
			</fieldset>
			</div><br />
		<div class="smallfont" align="left">Details: $description</div>
	</td>
</tr>
<tr>
	<td class="alt2">
		<div valign="top">
		<fieldset class="statistics_group" style="float: left;">
				<legend>Screenshots</legend>
				<if condition="$screenshot">$display_shots<else />No screen shots have been added.</if>
		</fieldset>
		</div>
	</td>
</tr>
</table>
<br />

This is the screenshot display loop:
$display_shots below

<a href="screen.php?img=$sid" target="_blank"><img src="screen.php?img=$sid" width="150" border="0"></a>&nbsp;&nbsp;

[Dismounted]

Have you checked for duplicate entries in the database?

[Excalibur82]

Yep, thats why I took it down to only 2 entries so that way I know for sure there are only 2 entries, different names and all.

[Excalibur82]

Still needing help please.

--------------- Added [DATE]1239425673[/DATE] at [TIME]1239425673[/TIME] ---------------

EDIT: Here is some help: http://www.bluefirecreation.com/download.php
Username: Guest
Password: guest

[Excalibur82]

I provided login to view that page so everyone can see the issue, maybe helping in determining the issue.

[Lynne]

OK, so right now, it is showing the first entry twice, and the second time it's shown it is showing the image twice. The second item is fine and not being shown twice. Is that what is currently going on? (it should really only show entry 1 and 3, correct?)

[Excalibur82]

Correct, the first two entries are one in the same but yes 1 and 3 or 2 and 3 should be the only ones showing.